mysql 常用数据库命令 （linux 下特殊操作）

1、CREATE DATABASE test DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

drop database test;

2、 source file.sql;

3、mysqldump  -u root -p test > d:/test20171117.sql；

4、linux下查询布尔值 

select agreeCopy+b'0'from lottery_scheme_backups where (state =2 or state = 5) and 
sponsorName = "小崽子";
查询布尔值 ： select agreeCopy+b'0；'

5.linux下查询中文显示乱码；

执行

set character_set_client = utf8;


set character_set_server = utf8;


set character_set_connection = utf8;


set character_set_database = utf8;（可不执行）


set character_set_results = utf8;


show variables like "%character%";

后，可正常显示中文；