mysql的简单语句

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;

mysql的简单语句

标签：use   ant   nts   语句   from   rop   mysqldump   roo   creat