MySQL的三层结构
SQL语句分类
基本指令
CREATE DATABASE ybj_db01
DROP DATABASE db01
CREATE DATABASE ybj_db02 CHARACTER SET utf8
CREATE DATABASE ybj_db03 CHARACTER SET utf8 COLLATE utf8_bin
SELECT * FROM USER WHERE NAME = 'tom'
SHOW DATABASES
SHOW CREATE DATABASE ybj_db01
DROP DATABASE `ybj_db02`
mysqldump -u root -p -B ybj_db03 ybj_db01 > d:\\bak.sql
source d:\\bak.sql
mysqldump -u root -p ybj_db03 user > d:\\bak.sql
CREATE TABLE `user`(
`id` INT,
`name` VARCHAR(255),
`password` VARCHAR(255),
`birthday` DATE)
CHARACTER SET utf8 COLLATE utf8_bin ENGINE INNODB;