너무너무 감사합니다.
해봐야지
: <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>--내서명은 복잡해서...