1.插入多条数据：
INSERT INTO think_user (user,email,date)
SELECT ‘雪莲花开‘ ,‘xuelianflower@qq.com‘,NOW()
UNION ALL
SELECT ‘青春如此浪荡‘ ,‘youngth@yahu.com‘,NOW()
UNION ALL
SELECT ‘暖心向阳i‘ ,‘warnheart@sohu.com‘,NOW()
UNION ALL
SELECT ‘如果没有明天‘ ,‘tommorrow@hotmail.com‘,NOW()
UNION ALL
SELECT ‘残阳照、墨痕‘ ,‘canyang@gmail.com‘,NOW()
UNION ALL
SELECT ‘久伴成了酒伴‘ ,‘wine@163.com‘,NOW()
UNION ALL
SELECT ‘萌神无敌i‘ ,‘mengshen@126.com‘,NOW();
2.插入单条数据：
INSERT INTO users (username,sex,birth) VALUES (‘Lee‘,‘x‘,NOW());
原文：http://www.cnblogs.com/webskill/p/4850759.html