1 |
Å×ÀÌºí »ý¼ºÇϱâ
( CREATE TABLES ) |
|
|
Database ³»¿¡ »õ·Î¿î Å×À̺íÀ» »ý¼ºÇÕ´Ï´Ù.
|
|
|
create
table »ý¼ºÇÒ
Å×À̺í¸í ( Çʵå¸í
µ¥ÀÌÅÍŸÀÔ( ), Çʵå¸í
µ¥ÀÌÅÍŸÀÔ, ... ); | |
|
|
¿¹ |
name °ú num Çʵ带 °®´Â test Å×À̺íÀ» »ý¼ºÇϱâ |
|
|
mysql> create table test(
-> name char(10),
-> num int(5)
-> );
Query OK, 0 rows affected (0.00 sec)
| |
|
|
2 |
Å×À̺í
»èÁ¦Çϱâ ( DROP TABLE
) |
|
|
Database ³»¿¡ »ý¼ºµÇ¾î Àִ ƯÁ¤ Å×À̺íÀ» »èÁ¦ ÇÕ´Ï´Ù.
|
|
|
|
¿¹ |
test Å×À̺í
»èÁ¦Çϱâ |
|
|
mysql> drop table test;
Query OK, 0 rows affected (0.00 sec) |
|
|