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

등록 2002-07-26 08:44:00 By localhost     조회 6
이름 바다사랑    

		너무너무 감사합니다.
해봐야지
 : <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