MySQL 테이블 생성 CREATE TABLE

MySQL CREATE TABLE

MySQL 테이블 생성

1 예시1: dept

CREATE TABLE dept (
  dept_no INT(11) unsigned NOT NULL,
  dept_name VARCHAR(32) NOT NULL,
  PRIMARY KEY (dept_no)
);

실행결과

mysql> CREATE TABLE dept (
    ->   dept_no INT(11) unsigned NOT NULL,
    ->   dept_name VARCHAR(32) NOT NULL,
    ->   PRIMARY KEY (dept_no)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> DESC dept;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| dept_no   | int(11) unsigned | NO   | PRI | NULL    |       |
| dept_name | varchar(32)      | NO   |     | NULL    |       |
+-----------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

2 예시2: posts

CREATE TABLE posts ( 
  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  subject varchar(255) NOT NULL,
  content mediumtext,
  created datetime,
  user_id int(10) unsigned NOT NULL,
  user_name varchar(32) NOT NULL,
  hit int(10) unsigned NOT NULL default '0',  
  PRIMARY KEY (id)
);

실행결과

mysql> CREATE TABLE posts ( 
    ->   id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   subject varchar(255) NOT NULL,
    ->   content mediumtext,
    ->   created datetime,
    ->   user_id int(10) unsigned NOT NULL,
    ->   user_name varchar(32) NOT NULL,
    ->   hit int(10) unsigned NOT NULL default '0',  
    ->   PRIMARY KEY (id)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> DESC posts;
+-----------+---------------------+------+-----+---------+----------------+
| Field     | Type                | Null | Key | Default | Extra          |
+-----------+---------------------+------+-----+---------+----------------+
| id        | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| subject   | varchar(255)        | NO   |     | NULL    |                |
| content   | mediumtext          | YES  |     | NULL    |                |
| created   | datetime            | YES  |     | NULL    |                |
| user_id   | int(10) unsigned    | NO   |     | NULL    |                |
| user_name | varchar(32)         | NO   |     | NULL    |                |
| hit       | int(10) unsigned    | NO   |     | 0       |                |
+-----------+---------------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)

3 같이 보기

• MySQL 테이블 구조 확인 DESCRIBE
• MySQL 테이블 생성 쿼리 보기 SHOW CREATE TABLE
• MySQL 테이블명 변경 RENAME TABLE
• MySQL 테이블 삭제 DROP TABLE
• MySQL 컬럼 추가
• 직원 테이블 EMPLOYEE 샘플
• 부서 테이블 DEPARTMENT 샘플
• DB 테이블
• DDL