net start mysql
net close mysql
服务无法启动的时候
netstat -aon|findstr "3306"; //查看端口
taskkill /f /pid 123 //杀掉某个进程
mysql -u root -p
create databases xxxx
create table xxx
show databases;
use databasesname;
show tables;
describe tablename; //查看表的结构
select * from tablename; //查看某个表的全部
select name from tablename where name='xxx';
update tablename set name='' where name='xxx';
insert into tablename(name,age) values('name','1');
