mysql的一些常用语句

-----------------------------------------------------------------
----------------mysql的登陆--------------------------------------
-----------------------------------------------------------------

mysql>mysql -u DQHK -p

-----------------------------------------------------------------
----------------查看所有数据库-----------------------------------
-----------------------------------------------------------------

mysql>show databases;

-----------------------------------------------------------------
----------------使用某个数据库-----------------------------------
-----------------------------------------------------------------

mysql>use DQHK;

-----------------------------------------------------------------
----------------删除某个数据库-----------------------------------
-----------------------------------------------------------------

mysql>drop database db_name;

------------------------------------------------------------------
----------------创建用户liutuo使之能从本地和远程访问--------------
------------------------------------------------------------------

mysql>grant all privileges on *.* to 'liutuo'@'localhost' identified by '123452' with grant option;

mysql>grant all privileges on *.* to 'liutuo'@'%' identified by '123452' with grant option;

------------------------------------------------------------------
----------------创建数据库DQHK_20080904---------------------------
------------------------------------------------------------------

mysql>create database DQHK_20080904;

------------------------------------------------------------------
----------------导出数据------------------------------------------
------------------------------------------------------------------

[web@nwtgzlx ~]$ mysqldump -u liutuo -p -h localhost DQHK > DQHK_20080904.SQL;

------------------------------------------------------------------
----------------导入数据------------------------------------------
------------------------------------------------------------------

mysql>source /home/web/DQHK_20080904.SQL;

------------------------------------------------------------------
----------------删除数据------------------------------------------
------------------------------------------------------------------

mysql>select count(*) from DirectoryMaster where sourceid=2;

mysql>delete from BusinessNameIndex where directoryid in(select directoryid from DirectoryMaster where sourceid=2);

mysql>delete from CategorySearch where directoryid in(select directoryid from DirectoryMaster where sourceid=2);

mysql>delete from ContactInfo where directoryid in(select directoryid from DirectoryMaster where sourceid=2);

mysql>delete from ResidentialNameIndex where directoryid in(select directoryid from DirectoryMaster where sourceid=2);

mysql>delete from CaptionIndex where directoryid in(select directoryid from DirectoryMaster where sourceid=2);

mysql>delete from GovernmentNameIndex where directoryid in(select directoryid from DirectoryMaster where sourceid=2);

mysql>delete from  DirectoryMaster where sourceid=2;