随笔分类 -  MySQL

SQL语句记录
摘要：UPDATE EXAM_SCORE t1 SET end_class_time = ( SELECT create_date_time FROM ( SELECT MAX(create_date_time) AS create_date_time, exam_score_id FROM ANSWER 阅读全文
posted @ 2020-11-02 07:47 晴和琼林 阅读(81) 评论(0) 推荐(0)
SQL关键字执行顺序
摘要：select[distinct] from join（如left join） on where group by having union order by limit 阅读全文
posted @ 2020-10-29 19:17 晴和琼林 阅读(104) 评论(0) 推荐(0)
MyISAM与InnoDB的区别是什么？
摘要：MyISAM与InnoDB的区别 阅读全文
posted @ 2020-05-18 15:17 晴和琼林 阅读(159) 评论(0) 推荐(0)