mysql TIP

Mysql user 등록
GRANT ALL PRIVILEGES ON *.* to user@localhost IDENTIFIED BY 'user' WITH GRANT OPTION;
insert into user values('localhost', 'user', password('user'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');

use mysql;

delete from user where user='해당사용자ID';

delete from db where user='해당사용자ID';

MYSQL 메모리 지우기!!
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MYSQL DUMP TABLE-
mysqldump -u user -puser --skip-lock-table --database user_db --tables Table_Info --skip-extended-insert > Table_Info.sql

MYSQL DUMP DB -

mysqldump -uuser -puser --databases user_db -q --skip-extended-insert --skip-lock-tables > user_20061201.sql

mysqldump -uuser -puser --databases user_db -q --skip-extended-insert --skip-lock-tables --default-character-set=latin1 > user_db_20061013.sql
mysql 중복제거
select distinct 제목 from 테이블명;

Inner Join
SELECT B.Table_Value FROM Table_A_Info A INNER JOIN Table_B_Info B ON (A.Value = B.Value AND A.Version = B.Version AND A.Re_ID = B.Re_ID ) WHERE A.System_Info = '3' AND A.Version_Info = 'xxx' AND A.Relation_Info = 'xxxx';