MySQL Table
SQL
Structured(๊ตฌ์กฐํ๋์ด์๋ค.) Query(๋ฐ์ดํฐ๋ฒ ์ด์ค์ ์ง์ํ๋ค.) Language์ ์ฝ์์ด๋ค.
์๋์ ์ธ ๋ฐ์ดํฐ๋ฒ ์ด์ค ์์คํ ์ด SQL๋ก ์๋๋๊ณ ์๋ค.
ํ
์ด๋ธ ๊ตฌ์กฐ
์ค์ตํ๊ธฐ
ํ
์ด๋ธ ์์ฑํ๊ธฐ

mysql> CREATE TABLE topic(
-> id INT(11) NOT NULL AUTO_INCREMENT,
-> title VARCHAR(100) NOT NULL,
-> description TEXT NULL,
-> created_at DATETIME NOT NULL,
-> author VARCHAR(30) NULL,
-> profile VARCHAR(100) NULL,
-> PRIMARY KEY(id));
Query OK, 0 rows affected (0.11 sec)
NOT NULL : ๊ณต๋ฐฑ์ ํ์ฉํ์ง ์๋๋ค.
AUTO_INCREMENT : ์๋์ผ๋ก ํ๊ฐ์ฉ ์ฆ๊ฐํ๋ค.
PRIMARY KEY : ์ค๋ณต์ด ๋์ง ์๋ ๊ฐ, ์๋ณ์
ํ
์ด๋ธ ๋ณด๊ธฐ
mysql> SHOW TABLES;
+-------------------------+
| Tables_in_opentutorials |
+-------------------------+
| topic |
+-------------------------+
1 row in set (0.01 sec)
ํ
์ด๋ธ ๊ตฌ์กฐ ๋ณด๊ธฐ
mysql> DESC topic;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| title | varchar(100) | NO | | NULL | |
| description | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| author | varchar(30) | YES | | NULL | |
| profile | varchar(100) | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
6 rows in set (0.01 sec)
Last updated
Was this helpful?