windows环境创建mysql数据库

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

上一篇:课程笔记 Info 90002 Part 2 - Advanced Database


下一篇:oracle For loop,隐式游标