使用java实现数据库编程第五章 事务，视图，索引，备份和恢复

– 1 创建视图：数据来源于原始表

CREATE VIEW student_result 
AS  
SELECT s.studentName AS 姓名,r.studentResult AS 成绩,r.examDate AS 考试时间
FROM student AS s,result AS r 
WHERE s.studentNo = r.studentNo

– 2 查看视图

SELECT * FROM student_result

– 查看所有视图

USE information_schema;
SELECT * FROM views;

– 创建索引

CREATE INDEX index_student_studentName ON student(studentName);

– 删除索引

DROP INDEX index_student_studentName ON student 

– 查看索引

SHOW INDEX FROM student


SHOW INDEX FROM student\G;  加上\G表示格式化 在DOS命令窗口中

备份数据库

mysqldump –u root –p myschool student > d:\backup\student0306.sql
注意d:\backup\目录必须存在，文件student0306.sql不能事先存在


mysqldump –help