CREATE TABLE test_table select m.*, s.number,s.description, s.expect from manualcase m left join step s on s.manualcase_id = m.id where m.module_id=653 order by m.id desc
例子CREATE TABLE test_table select m.*, s.number,s.description, s.expect from manualcase m left join step s on s.manualcase_id = m.id where m.module_id=653 order by m.id descCREARE负责创建新表,新表的内容是SELECT...