>> Delete Reply from No. 53602 article
No. RE: MySQL일반계정자 삭제하려면...

등록 2002-07-26 00:15:00 By localhost     조회 4
이름 바다사랑    

		<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>
[관리자] 패스워드를 입력 하십시오. 답장이 존재하면 함께 삭제됩니다.[ 목록 | 이전 ]
패스워드:    

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