1. ¿øÇÏ´Â Å×À̺íÀ» Çϳª ¸¸µé¾î º¾½Ã´Ù. ¹æ¹ýÀº ´ÙÀ½°ú °°½À´Ï´Ù.
mysql> create table book(num int,name varchar(20),office varchar(20));
Query OK, 0 rows affected (0.07 sec) 2.
Á¦´ë·Î ¸¸µé¾î Á³´ÂÁö È®ÀÎÇÏ´Â ¹æ¹ý
mysql> show tables +----------------+
| Tables in test |
+----------------+
| book |
+----------------+
1 row in set (0.00 sec) 3. ¾î¶² ±¸Á¶·Î
¸¸µé¾î Á³³ª È®ÀÎÇÏ´Â ¹æ¹ý
mysql> desc book +--------+-------------+------+-----+---------+-------+
| Field | Type |
Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| num | int(11) |
YES | | NULL |
|
| name | varchar(20) | YES | |
NULL | |
| office | varchar(20) | YES | |
NULL | |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
4. Å×À̺í¾È¿¡ °ªÀ» ³Ö´Â ¹æ¹ý - insert
mysql> insert into book values('1','È«±æµ¿','Çö´ë');
Query OK, 1 row affected (0.00 sec) 5.
Á¦´ë·Î ÀÔ·ÂÀÌ µÇ¾ú³ª È®ÀÎÇÏ´Â ¹æ¹ý
mysql> select * from book; +------+--------+--------+
| num | name | office |
+------+--------+--------+
| 1 | È«±æµ¿ | Çö´ë |
+------+--------+--------+
1 row in set (0.00 sec) 6. ¶Ç ÀÔ·ÂÇÏ´Â
¹æ¹ý
mysql> insert into book values('2','ÀÓ²©Á¤','»ï¼º');
Query OK, 1 row affected (0.00 sec) 7.
´Ù½Ã È®ÀÎÇÏ´Â ¹æ¹ý
mysql> select * from book; +------+--------+--------+
| num | name | office |
+------+--------+--------+
| 1 | È«±æµ¿ | Çö´ë |
| 2 | ÀÓ²©Á¤ | »ï¼º |
+------+--------+--------+
2 rows in set (0.00 sec)
|
|