MySQL 批量添加用户数据 - 40行INSERT语句

INSERT INTO table_name (name, gender, age, address, qq, email, username, password) VALUES ('\u5f20\u4e09', '\u7537', 20, '\u5317\u4eac\u5e02', '123456789', 'zhangsan@qq.com', 'zhangsan', '123456'), ('\u674e\u56db', '\u7537', 25, '\u4e0a\u6d77\u5e02', '987654321', 'lisi@qq.com', 'lisi', '654321'), ('\u738b\u4e94', '\u7537', 30, '\u5e7f\u5dde\u5e02', '456789123', 'wangwu@qq.com', 'wangwu', '789456'), ('\u80e1\u516d', '\u5973', 22, '\u6df1\u5733\u5e02', '321654987', 'zhaoliu@qq.com', 'zhaoliu', '987654'), ('\u5218\u4e03', '\u5973', 28, '\u676d\u5dde\u5e02', '654987321', 'sunqi@qq.com', 'sunqi', '654987'), ('\u5468\u516b', '\u7537', 32, '\u5357\u4eac\u5e02', '789123456', 'zhouba@qq.com', 'zhouba', '321654'), ('\u90d1\u4e5d', '\u5973', 24, '\u6210\u90fd\u5e02', '159753246', 'zhengjiu@qq.com', 'zhengjiu', '159753'), ('\u94b1\u5341', '\u7537', 26, '\u91cd\u5e86\u5e02', '357951246', 'qianshi@qq.com', 'qianshi', '753951'), ('\u6770\u5341\u4e00', '\u5973', 23, '\u6b66\u6c49\u5e02', '951753246', 'zhushiyi@qq.com', 'zhushiyi', '357951'), ('\u5218\u5341\u4e8c', '\u7537', 27, '\u957f\u6c99\u5e02', '753951246', 'liushier@qq.com', 'liushier', '951753'), ('\u9648\u5341\u4e09', '\u5973', 29, '\u897f\u5b89\u5e02', '246753951', 'chensanshi@qq.com', 'chensanshi', '753951'), ('\u6768\u5341\u56db', '\u7537', 26, '\u6d4e\u5357\u5e02', '951246753', 'yangshisi@qq.com', 'yangshisi', '246753'), ('\u9ec4\u5341\u4e94', '\u7537', 31, '\u77f3\u5bb6\u5e84\u5e02', '753357951', 'huangshiwu@qq.com', 'huangshiwu', '357951'), ('\u5434\u5341\u516d', '\u5973', 25, '\u798f\u5dde\u5e02', '246951753', 'wushiliu@qq.com', 'wushiliu', '951753'), ('\u6797\u5341\u4e03', '\u5973', 27, '\u5357\u660c\u5e02', '357246951', 'linshiqi@qq.com', 'linshiqi', '246951'), ('\u90b5\u5341\u516b', '\u7537', 30, '\u5408\u80a5\u5e02', '753951357', 'guoshiba@qq.com', 'guoshiba', '951357'), ('\u4f55\u5341\u4e5d', '\u5973', 24, '\u5357\u5b81\u5e02', '951357246', 'heshijiu@qq.com', 'heshijiu', '357246'), ('\u9a6c\u4e8c\u5341', '\u7537', 28, '\u53a6\u95e8\u5e02', '246953357', 'maershier@qq.com', 'maershier', '953357'), ('\u7387\u4e8c\u5341\u4e00', '\u5973', 26, '\u957f\u6625\u5e02', '357246953', 'luoershiyi@qq.com', 'luoershiyi', '246953'), ('\u6881\u4e8c\u5341\u4e8c', '\u7537', 29, '\u54c8\u5c14\u57ce\u5e02', '953357246', 'liangershier@qq.com', 'liangershier', '357246'), ('\u5b8b\u4e8c\u5341\u4e09', '\u5973', 23, '\u547c\u548c\u5410\u5e02', '246953357', 'songersanshi@qq.com', 'songersanshi', '953357'), ('\u90b5\u4e8c\u5341\u56db', '\u7537', 27, '\u5170\u5dde\u5e02', '357246953', 'guoershisi@qq.com', 'guoershisi', '246953'), ('\u8c22\u4e8c\u5341\u4e94', '\u7537', 25, '\u94f6\u5ddd\u5e02', '953357246', 'xieshawu@qq.com', 'xieshawu', '357246'), ('\u9648\u4e8c\u5341\u516d', '\u5973', 28, '\u4e4c\u9c81\u6728\u6865\u5e02', '246953357', 'hanershiu@qq.com', 'hanershiu', '953357'), ('\u5510\u4e8c\u5341\u4e03', '\u7537', 24, '\u897f\u5b81\u5e02', '357246953', 'tangershisan@qq.com', 'tangershisan', '246953'), ('\u90ed\u4e8c\u5341\u516b', '\u5973', 26, '\u547c\u4e34\u8d1d\u5170\u805a\u7533', '953357246', 'caoshierba@qq.com', 'caoshierba', '357246'), ('\u4e01\u4e8c\u5341\u4e5d', '\u7537', 23, '\u4e4c\u9c81\u6728\u6865\u5e02', '246953357', 'dingershiu@qq.com', 'dingershiu', '953357'), ('\u9647\u4e09\u5341', '\u7537', 27, '\u90a2\u5c14\u585e\u62c9\u65af\u5e02', '357246953', 'dengerwu@qq.com', 'dengerwu', '246953'), ('\u9648\u4e09\u5341\u4e00', '\u5973', 25, '\u5305\u9876\u5e02', '953357246', 'xiaoshisan@qq.com', 'xiaoshisan', '357246'), ('\u7a0b\u4e09\u5341\u4e8c', '\u7537', 28, '\u535a\u95e8\u5170\u5e81\u5e02', '246953357', 'chengershier@qq.com', 'chengershier', '953357'), ('\u6c6a\u4e09\u5341\u4e09', '\u5973', 24, '\u94dc\u6765\u90a6\u5170\u805a', '357246953', 'wangershisan@qq.com', 'wangershisan', '246953'), ('\u53f3\u4e09\u5341\u56db', '\u7537', 26, '\u547c\u4e34\u8d1d\u5170\u805a\u7533', '953357246', 'yeshisier@qq.com', 'yeshisier', '357246'), ('\u4f59\u4e09\u5341\u4e94', '\u7537', 25, '\u4e4c\u9c81\u6728\u6865\u5e02', '246953357', 'yushiwu@qq.com', 'yushiwu', '953357'), ('\u7389\u4e09\u5341\u516d', '\u5973', 29, '\u90a2\u5c14\u585e\u62c9\u65af\u5e02', '357246953', 'yushiliu@qq.com', 'yushiliu', '246953'), ('\u4efb\u4e09\u5341\u4e03', '\u7537', 23, '\u5305\u9876\u5e02', '953357246', 'rensanshi@qq.com', 'rensanshi', '357246'), ('\u5b59\u4e09\u5341\u516b', '\u5973', 27, '\u535a\u95e8\u5170\u5e81\u5e02', '246953357', 'yaosanba@qq.com', 'yaosanba', '953357'), ('\u6f58\u4e09\u5341\u4e5d', '\u7537', 24, '\u94dc\u6765\u90a6\u5170\u805a', '357246953', 'pansanshiu@qq.com', 'pansanshiu', '246953'), ('\u80a1\u56db\u5341', '\u7537', 28, '\u547c\u4e34\u8d1d\u5170\u805a\u7533', '953357246', 'yuansishi@qq.com', 'yuansishi', '357246')