两个表JOIN形成新表 原始表jjdb_test、fkdb_test,新表jjdb_fkdb_test CREATE TABLE IF NOT EXISTS jjdb_fkdb_test( SELECT jjdb_test.*,fkdb_test.* FROM jjdb_test JOIN fkdb_test ON jjdb_test.jjdbh = fkdb_test.jjdbh_f)