편집을 취소할 수 있습니다. 이 편집을 되돌리려면 아래의 바뀐 내용을 확인한 후 게시해주세요.
최신판 | 당신의 편집 | ||
34번째 줄: | 34번째 줄: | ||
<source lang='mysql'> | <source lang='mysql'> | ||
CREATE TABLE posts ( | CREATE TABLE posts ( | ||
id | id int(11) unsigned NOT NULL AUTO_INCREMENT, | ||
subject varchar(255) NOT NULL, | subject varchar(255) NOT NULL, | ||
content mediumtext, | content mediumtext, | ||
48번째 줄: | 48번째 줄: | ||
<source lang='console'> | <source lang='console'> | ||
mysql> CREATE TABLE posts ( | mysql> CREATE TABLE posts ( | ||
-> id | -> id int(11) unsigned NOT NULL AUTO_INCREMENT, | ||
-> subject varchar(255) NOT NULL, | -> subject varchar(255) NOT NULL, | ||
-> content mediumtext, | -> content mediumtext, | ||
61번째 줄: | 61번째 줄: | ||
<source lang='console'> | <source lang='console'> | ||
mysql> DESC posts; | mysql> DESC posts; | ||
+-----------+ | +-----------+------------------+------+-----+---------+----------------+ | ||
| Field | Type | | Field | Type | Null | Key | Default | Extra | | ||
+-----------+ | +-----------+------------------+------+-----+---------+----------------+ | ||
| id | | | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | ||
| subject | varchar(255) | | subject | varchar(255) | NO | | NULL | | | ||
| content | mediumtext | | content | mediumtext | YES | | NULL | | | ||
| created | datetime | | created | datetime | YES | | NULL | | | ||
| user_id | int(10) unsigned | | user_id | int(10) unsigned | NO | | NULL | | | ||
| user_name | varchar(32) | | user_name | varchar(32) | NO | | NULL | | | ||
| hit | int(10) unsigned | | hit | int(10) unsigned | NO | | 0 | | | ||
+-----------+ | +-----------+------------------+------+-----+---------+----------------+ | ||
7 rows in set (0. | 7 rows in set (0.00 sec) | ||
</source> | </source> | ||