登陆:
在MySQL的根目录的bin文件夹下,输入
mysql -uroot -p
创建一个名为Course的数据库:
create database Course;
在数据库中插入名为teacher的表,包含四项:
create table teacher(
tea_id int(10) not null auto_increment primary key,
tea_name varchar(255),
tea_department varchar(255),
tea_major varchar(255)
);
在表中插入数据:
insert into teacher
(tea_name, tea_department, tea_major)
values
("Jim", "EE", "Information technology"),
("Duke", "CS", "Software Engineering"),
("Woody", "CS", "Software Engineering");
查看表的格式等信息:
desc teacher;
效果如下:
查看表的内容:
select * from teacher;
效果如下:
删除表:
drop table teacher;
导出文件:
退出MySQL系统后,在根目录的bin文件夹下,之后输入密码:
mysqldump -u root -p Course > D:\Course.sql