+++ ȨÁ¦ÀÛ ¹ÙÀ̺í +++
ȨÁ¦ÀÛ ¹ÙÀ̺í ÀÌ »çÀÌÆ®´Â ÀÌ¿µÂù´ÔÀÇ »çÀÌÆ®¸¦ º¹¿øÇÑ °ÍÀÔ´Ï´Ù.
Untitled Document
Html
Dhtml
Css
Php
Asp
Cgi
Java Script
Java Applet
Multimedia
Win Tip
Mysql - insert
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)
                                   
Update : 2000/08/01 [µ¹¾Æ°¡±â]