table에서 create, select, update, delete , insert, drop하기

UPDATE문
====================================================================
update [테이블 이름] set [필드1] = [값1], [필드2]=[값2] ,..where [조건]
====================================================================
mysql> select * from MEMBER;
+----------+----------+--------+-------+
| MEMBERID | PASSWORD | NAME   | EMAIL |
+----------+----------+--------+-------+
| binian   | 1234     | 한성빈 | NULL  |
| happy    | qwer     | 강'군  | NULL  |
+----------+----------+--------+-------+

mysql> update MEMBER set EMAIL='happynewmind@hotmail.com' where NAME='한성빈';
Query OK, 1 row affected (0.16 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from MEMBER;
+----------+----------+--------+--------------------------+
| MEMBERID | PASSWORD | NAME   | EMAIL                    |
+----------+----------+--------+--------------------------+
| binian   | 1234     | 한성빈 | happynewmind@hotmail.com |
| happy    | qwer     | 강'군  | NULL                     |
+----------+----------+--------+--------------------------+
2 rows in set (0.00 sec)

mysql> update MEMBER set EMAIL='kangkun@hotmail.com' where NAME="강'군";
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from MEMBER;
+----------+----------+--------+--------------------------+
| MEMBERID | PASSWORD | NAME   | EMAIL                    |
+----------+----------+--------+--------------------------+
| binian   | 1234     | 한성빈 | happynewmind@hotmail.com |
| happy    | qwer     | 강'군  | kangkun@hotmail.com      |
+----------+----------+--------+--------------------------+
2 rows in set (0.00 sec)