CREATE TABLE `historeResult`(
SELECT `result`.*
FROM `result` INNER JOIN `student` ON `result`.`studentNo`=`student`.`studentNo`
INNER JOIN `grade` ON `grade`.`gradeId`=`student`.`gradeId`
WHERE 1=2
);
DROP TABLE IF EXISTS `historyStudent`;
CREATE TABLE `historyStudent`(
SELECT `student`.*
FROM `student` INNER JOIN `grade` ON `grade`.`gradeId`=`student`.`gradeId`
WHERE 1=2
);
START TRANSACTION;
/*--查询result表中所有Y2学员的考试成绩,保存到新表HistoreResult*/
INSERT INTO historeResult
SELECT `result`.*
FROM `result` INNER JOIN `student` ON `result`.`studentNo`=`student`.`studentNo`
INNER JOIN `grade` ON `grade`.`gradeId`=`student`.`gradeId`
WHERE `gradeName`='Y2&#
mysql-上机练习2
最新推荐文章于 2024-07-06 21:03:48 发布
这篇博客主要介绍了MySQL的一些实际操作练习,包括数据查询、增删改查等基础操作,旨在提升数据库管理技能。
摘要由CSDN通过智能技术生成