摘要:
--drop table test CREATE TABLE test ( name VARCHAR(12), scores INT ) INSERT INTO test SELECT '周杰伦',230 UNION SELECT '周星驰',100 UNION SELECT '成龙',150 UNION SELECT '李连杰',200 UNION SELECT '莉莉',260 SELECT * FROM test /* name scores 成龙 150 莉莉 260 李连杰 200 周杰伦 230 周星驰 阅读全文