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?