>> 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>

Copyleft 1999-2026 by JSBoard Open Project Theme Designed by IDOO All right reserved