启动mysql服务
net start mysql
关闭mysql服务
net stop mysql
登入mysql
mysql -u root -p
创建数据库
CREATE DATABASE springdatajpa;
切换数据库
use springdatajpa
查看数据表的所有内容
select * from user
上面的user是一个已经存在的表
向表中插入数据:
insert into user(id,age,sex,user_name) values(4,9,'女','爱丽');
insert into h5user (opid,mccode,teacct,paydate,querydate,remarks,enable,withholding_flag)
values('o_XOw1bc51n3j1CyXmUIWguAnsO4','000536','12345678','20170731','28','test','1','0');
delete from h5user where opid = 'o_XOw1bc51n3j1CyXmUIWguAnsO4';
查看所有数据库
show databases;
查看所有表
show tables;
删除表和库:
drop table 表名;
drop database 库名;
删除列:
ALTER TABLE tableName DROP COLUMN columnName;
https://www.cnblogs.com/yuchuan/p/mysql_1.html
查看表的字段类型:
describe 表名;
更改表某列的字段类型(比如将int类型改成varchar(255)):
alter table 表名 modify column 列名 varchar(255);
https://blog.csdn.net/qq_35840325/article/details/78662896