1.查看路径
show variables like ‘datadir‘;
2.show databases;
3.create database course;
4.use course;
5.create table student(id type);
6.show full fields from student;
7.show grants;
8.mysqldump -uroot -p course >E:sql1/mysql.bak.sql
9.drop table student;
10. source E:sql1/mysql.bak.sql
11.drop database course;