cd C:\Windows\System32
open cmd.ext with administrator’s authoriity
log in mysql database
mysql -u root -p
password: none
create database
create DATABASE ‘databse_name’;
show all databases
show databases;
show basic info of ‘database_name’
show create database ‘database_name’;
enter the database
use ‘database_name’
#create table
create table mole_qm_info(name type(),…);
show tabe info
desc ‘table_name’
参考来源:
https://zhuanlan.zhihu.com/p/370510336