mysql常用指令

//启动mysql服务
net start mysql

//停止mysql服务
net stop mysql

//连接mysql服务器
mysql -u root -p

//退出mysql
exit;

//查看所有数据库
show databases;

//创建数据库 gapworks (UTF8中文)
create database `gapworks` character SET 'utf8' collate 'utf8_general_ci';

//选择数据库 gapworks
use gapworks;

//删除数据库 gapworks
drop database gapworks;

//查看所有表
show tables;

//删除表 singlemeasure_result
drop table singlemeasure_result;

//增加远程访问权限  
grant all privileges on *.* to 'root'@'%' identified by '123456';
flush privileges;

//group by问题修正
SET GLOBAL sql_mode =`STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION`;