SELECT ‘第一中学‘ as school, class, name, geography FROM test_table WHERE test = 1;
插入新table：
REPLACE INTO test_school(school, class, name, geography) SELECT ‘第一中学‘ as school, class, name, geography FROM test_table WHERE test = 1;
SELECT ‘第一中学‘ as school, class, name, geography FROM test_table WHERE test = 1;
插入新table：
REPLACE INTO test_school(school, class, name, geography) SELECT ‘第一中学‘ as school, class, name, geography FROM test_table WHERE test = 1;