<pre>
테이블 특정 레코드 삭제하기
mysql> delete from 테이블명 where 열명 = '레코드명(데이터명)';
EXAMPLE]
[bh@Zeus FreeBSD]% mysql -uroot -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 8052 to server version: 3.23.49
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
mysql> select Host,User from user;
+----------------+---------+
| Host | User |
+----------------+---------+
| localhost | root |
| izb.knu.ac.kr | root |
| localhost | |
| izb.knu.ac.kr | |
| localhost | ssarbab |
| localhost | bh |
| localhost | webmail |
| localhost | sne |
| % | bh |
| localhost | dongari |
+----------------+---------+
11 rows in set (0.02 sec)
mysql> delete from user where User = 'webmail';
Query OK, 1 row affected (0.00 sec)
mysql> exit
Bye
[bh@Zeus FreeBSD]%--====================
헛소리 하는 daemon
====================
</pre>