- MySQL CREATE TABLE
- MySQL 테이블 생성
1 예시1: dept[ | ]
MySQL
Copy
CREATE TABLE dept (
dept_no INT(11) unsigned NOT NULL,
dept_name VARCHAR(32) NOT NULL,
PRIMARY KEY (dept_no)
);
실행결과
Console
Copy
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)
Console
Copy
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[ | ]
MySQL
Copy
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)
);
실행결과
Console
Copy
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)
Console
Copy
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 같이 보기[ | ]
편집자 Jmnote Jmnote bot
로그인하시면 댓글을 쓸 수 있습니다.