적수네 동네 - 질문과 답변 [ 게시물 수정 ]

	>> Edit article


			이름
			제목
			패스워드

너무너무 감사합니다.
해봐야지
 : <pre>
: 테이블 특정 레코드 삭제하기 
: mysql> delete from 테이블명 where 열명 = &#039;레코드명(데이터명)&#039;;
: 
: 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 &#039;help;&#039; or &#039;h&#039; for help. Type &#039;c&#039; 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 = &#039;webmail&#039;;
: Query OK, 1 row affected (0.00 sec)
: 
: mysql> exit
: Bye
: [bh@Zeus FreeBSD]%
: 
: --
: ==================== 
: 헛소리 하는 daemon 
: ====================
: </pre>--내서명은 복잡해서...