MySQL批量插入语句生成40行用户数据
INSERT INTO users (name, gender, age, address, qq, email, username, password) VALUES ('张三', '男', 25, '湖南', '123456789', 'zhangsan@example.com', 'zhangsan', 'password1'), ('李四', '男', 30, '广州', '987654321', 'lisi@example.com', 'lisi', 'password2'), ('王五', '女', 22, '广西', '567891234', 'wangwu@example.com', 'wangwu', 'password3'), ('赵六', '男', 28, '湖南', '456789123', 'zhaoliu@example.com', 'zhaoliu', 'password4'), ('孙七', '女', 26, '广州', '789123456', 'sunqi@example.com', 'sunqi', 'password5'), ('周八', '男', 32, '广西', '234567891', 'zhouba@example.com', 'zhouba', 'password6'), ('吴九', '女', 24, '湖南', '912345678', 'wujiu@example.com', 'wujiu', 'password7'), ('郑十', '男', 29, '广州', '145678901', 'zhengshi@example.com', 'zhengshi', 'password8'), ('王十一', '女', 27, '广西', '823456789', 'wangshiyi@example.com', 'wangshiyi', 'password9'), ('陈十二', '男', 31, '湖南', '356789012', 'chenershi@example.com', 'chenershi', 'password10'), ('杨十三', '女', 23, '广州', '678901234', 'yangshisan@example.com', 'yangshisan', 'password11'), ('刘十四', '男', 28, '广西', '901234567', 'liushi@example.com', 'liushi', 'password12'), ('何十五', '女', 25, '湖南', '189012345', 'heshishi@example.com', 'heshishi', 'password13'), ('郭十六', '男', 30, '广州', '543210987', 'guoshiliu@example.com', 'guoshiliu', 'password14'), ('林十七', '女', 22, '广西', '765432109', 'linqishiqi@example.com', 'linqishiqi', 'password15'), ('徐十八', '男', 29, '湖南', '876543210', 'xubashi@example.com', 'xubashi', 'password16'), ('曾十九', '女', 27, '广州', '210987654', 'zengshijiu@example.com', 'zengshijiu', 'password17'), ('蔡二十', '男', 31, '广西', '321098765', 'caiershi@example.com', 'caiershi', 'password18'), ('黄二十一', '女', 23, '湖南', '432109876', 'huangershiyi@example.com', 'huangershiyi', 'password19'), ('谢二十二', '男', 28, '广州', '654321098', 'xiereshi'er@example.com', 'xiereshi'er', 'password20'), ('邓二十三', '女', 25, '广西', '987654321', 'dengershisan@example.com', 'dengershisan', 'password21'), ('彭二十四', '男', 30, '湖南', '123456789', 'pengershis'i@example.com', 'pengershis'i', 'password22'), ('钟二十五', '女', 22, '广州', '567891234', 'zhongershiwu@example.com', 'zhongershiwu', 'password23'), ('秦二十六', '男', 29, '广西', '789123456', 'qiner'shiliu@example.com', 'qiner'shiliu', 'password24'), ('梁二十七', '女', 27, '湖南', '234567891', 'liangershiqi@example.com', 'liangershiqi', 'password25'), ('韦二十八', '男', 31, '广州', '912345678', 'weiershi'ba@example.com', 'weiershi'ba', 'password26'), ('姜二十九', '女', 23, '广西', '145678901', 'jiangershijiu@example.com', 'jiangershijiu', 'password27'), ('龙三十', '男', 28, '湖南', '823456789', 'longsan'shi@example.com', 'longsan'shi', 'password28'), ('许三十一', '女', 25, '广州', '356789012', 'xusan'shiyi@example.com', 'xusan'shiyi', 'password29'), ('韩三十二', '男', 30, '广西', '678901234', 'hansanshi'er@example.com', 'hansanshi'er', 'password30'), ('唐三十三', '女', 22, '湖南', '901234567', 'tangsanshisan@example.com', 'tangsanshisan', 'password31'), ('冯三十四', '男', 29, '广州', '189012345', 'fengsanshis'i@example.com', 'fengsanshis'i', 'password32'), ('程三十五', '女', 27, '广西', '543210987', 'chengsanshiwu@example.com', 'chengsanshiwu', 'password33'), ('戴三十六', '男', 31, '湖南', '765432109', 'daisanshishiliu@example.com', 'daisanshishiliu', 'password34'), ('孟三十七', '女', 23, '广州', '876543210', 'mengsanshishiqi@example.com', 'mengsanshishiqi', 'password35'), ('向三十八', '男', 28, '广西', '210987654', 'xiangsanshishi'ba@example.com', 'xiangsanshishi'ba', 'password36'), ('贾三十九', '女', 25, '湖南', '321098765', 'jiasanshishijiu@example.com', 'jiasanshishijiu', 'password37'), ('马四十', '男', 30, '广州', '432109876', 'mas'ishi@example.com', 'mas'ishi', 'password38'
原文地址: https://www.cveoy.top/t/topic/qajL 著作权归作者所有。请勿转载和采集!