Å×À̺í±îÁö ´Ù ¸¸µé¾úÀ¸´Ï ·¹Äڵ带 Ãß°¡, »èÁ¦, ¼öÁ¤À» Çغ¼°Ô¿ä!
ÀÏ´Ü Ãß°¡´Â ´ÙÀ½ Äõ¸®¹®À» µû¸¨´Ï´Ù.
insert into [Å×À̺í À̸§] value('','');
value °ýÈ£ ¾È¿¡ µ¥ÀÌÅ͸¦ ¼ø¼´ë·Î ±âÀÔÇÏ¸é µË´Ï´Ù.
°¢ µ¥ÀÌÅ͸¶´Ù '' ·Î óÀ½°ú ³¡À» ±¸ºÐÇÕ´Ï´Ù.
µ¥ÀÌÅÍ°¡ ¼ýÀÚÀÎ °æ¿ì¿¡´Â ''¸¦ ¾²Áö ¾Ê¾Æµµ µË´Ï´Ù.
mysql> insert into user value('aiesko', 'mysql', 2, '2010-06-30'); Query OK, 1 row affected (0.02 sec)
±×·³ ÀÌÁ¦ Àß Ãß°¡°¡ µÇ¾ú´ÂÁö Á¶È¸¸¦ ÇÑ ¹ø Çغ¼°Ô¿ä!
select [*] from [Å×À̺í À̸§] [¿É¼Ç];
*Àº ¾î¶² Ç׸ñÀ» Á¶È¸ÇÏ°í ½ÍÀºÁö ÀÔ·ÂÇÕ´Ï´Ù.
ÄÄÇ»ÅÍ ¾ð¾î ±×´ë·Î *Àº ¸ðµÎ¸¦ ³ªÅ¸³»°í, id¸¸ Á¶È¸ÇÏ°í ½ÍÀ¸¸é id¸¦ ÀÔ·ÂÇÏ¸é µË´Ï´Ù.
¿É¼ÇÀº Á¦°¡ ¾Ë°í ÀÖ´Â °ÍÀº Á¤·Ä order by °¡ ÀÖ½À´Ï´Ù. <- µ¥ÀÌÅÍ°¡ ¸¹¾ÆÁ³À» ¶§ ±× ¶§ Æ÷½ºÆ® ÇÏÁö¿ä,
¶Ç ´Ù¸¥ ¿É¼ÇÀº ÀÏÄ¡ ¿É¼ÇÀÌ ÀÖÁö¿ä,
mysql> select * from user; +--------+-------+------+------------+ | id | pw | age | birth | +--------+-------+------+------------+ | aiesko | mysql | 2 | 2010-06-30 | +--------+-------+------+------------+ 1 row in set (0.00 sec)
mysql> select id,pw from user; +--------+-------+ | id | pw | +--------+-------+ | aiesko | mysql | +--------+-------+ 1 row in set (0.01 sec)
mysql> select * from user where age=2; +--------+-------+------+------------+ | id | pw | age | birth | +--------+-------+------+------------+ | aiesko | mysql | 2 | 2010-06-30 | +--------+-------+------+------------+ 1 row in set (0.03 sec)
ù ¹ø°´Â ÀÏ¹Ý Á¶È¸, µÎ ¹ø°´Â Àüü Á¶È¸ Áß id¿Í pw¸¸ Ãâ·Â, ¼¼ ¹ø°´Â ³ªÀÌ°¡ 2ÀÎ ¿À» ¸ðµÎ Ãâ·ÂÀÌ°ÚÁÒ,
Á¶ÇÕ? ¹æ½ÄÀº ¸¹°íµµ ¸¹½À´Ï´Ù ¤¾¤¾
µåµð¾î »èÁ¦!
¿©±â¼ÀÇ »èÁ¦´Â ¶Ç drop ¾Æ´Ï¶ó delete°¡ ¸Â½À´Ï´Ù ¤»¤»
delete from [Å×À̺í À̸§] [»èÁ¦ÇÒ ¿ÀÇ Á¶°Ç];
mysql> delete from user where age=2; Query OK, 1 row affected (0.04 sec)
mysql> select * from user; Empty set (0.00 sec)
½Å±âÇÏ°íµµ ½Å±âÇÕ´Ï´Ù.
ÀÌÁ¦ ¼öÁ¤¸¸ ³²¾Ò³×¿ä,
¼öÁ¤ Äõ¸®¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
update [Å×À̺í À̸§] set [¹Ù²Ü °ª] [¹Ù²Ü Çà]
mysql> create table users( -> id varchar(16), -> pw varchar(16), -> age varchar(2)); Query OK, 0 rows affected (0.03 sec)
mysql> insert into users value('aiesko', 'qmffhrm', 10); Query OK, 1 row affected (0.03 sec)
mysql> update users set pw=PASSWORD('qmffhrm') where pw='qmffhrm'; ERROR 1406 (22001): Data too long for column 'pw' at row 1
¿Í³ª! ÀÌ·± ¹®Á¦°¡ ¹ß»ýÇÏ´Â ±º¿ä,
¼öÁ¤ Äõ¸®¹®Àº ¸Â½À´Ï´Ù¸¸, ºñ¹Ð¹øÈ£¸¦ ¾ÏÈ£ÈÇÏ´Â °úÁ¤¿¡¼ ¾ÏÈ£ÈµÈ ºñ¹Ð¹øÈ£¸¦ 16¹ÙÀÌÆ®¿¡ ÀúÀåÀ» ¸øÇÏ´Â ¿¡·¯¿ä,
±×·¯´Ï ¿©·¯ºÐÀº Àúó·³ µÇÁö ¸¶½Ã±¸¿ä, ¿©Â÷ÇÇ varchar´Ï±ñ ÇÑ 128·Î Àâ¾Æ¹ö·Á¿ä ¤»¤» ¤Ð¤Ð
¾ÏÈ£È °úÁ¤À» º¸¿©ÁÖ±â À§ÇØ,, Å×ÀÌºí ¼öÁ¤ ¤Ð¤Ð
mysql> create table edit( -> id varchar(128), -> pw varchar(128), -> age int); Query OK, 0 rows affected (0.03 sec)
mysql> desc edit; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | id | varchar(128) | YES | | NULL | | | pw | varchar(128) | YES | | NULL | | | age | int(11) | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ 3 rows in set (0.01 sec)
mysql> insert into edit value('aiesko', 'qmffhrm', 10); Query OK, 1 row affected (0.02 sec)
mysql> update edit set pw=PASSWORD('qmffhrm') where pw='qmffhrm'; Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from edit; +--------+-------------------------------------------+------+ | id | pw | age | +--------+-------------------------------------------+------+ | aiesko | *50BE32A38E517B51B112442FA3CC10411123CEC0 | 10 | +--------+-------------------------------------------+------+ 1 row in set (0.00 sec)
ÀÌ·¸°Ô ¸ÚÁö°Ô ¾ÏÈ£ÈµÈ ºñ¹Ð¹øÈ£·Î ¼öÁ¤ÀÌ µÈ´ä´Ï´Ù.^^
´ÙÀ½ Æ÷½ºÆ®¿¡¼´Â ÀÌÁ¦ µåµð¾î MFC¿Í ¿¬µ¿ Æ÷½ºÆÃÀ» Çϳª¿ä? ¤¾¤¾ mysql, mysql¾ÏÈ£È, mysqlÅ×À̺í, query, Äõ¸®¹®
|