生成五十个用户的数据插入语句,包括id、name、sex、pwd、email等信息
时间: 2023-03-28 18:02:28 浏览: 66
INSERT INTO users (id, name, sex, pwd, email) VALUES
(1, '张三', '男', '123456', 'zhangsan@example.com'),
(2, '李四', '女', '654321', 'lisi@example.com'),
(3, '王五', '男', 'qwerty', 'wangwu@example.com'),
(4, '赵六', '女', 'asdfgh', 'zhaoliu@example.com'),
(5, '钱七', '男', 'zxcvbn', 'qianqi@example.com'),
(6, '孙八', '女', 'poiuyt', 'sunba@example.com'),
(7, '周九', '男', 'mnbvcx', 'zhoujiu@example.com'),
(8, '吴十', '女', 'lkjhgf', 'wushi@example.com'),
(9, '郑十一', '男', '098765', 'zhengshiyi@example.com'),
(10, '王十二', '女', '123abc', 'wangshier@example.com'),
(11, '张十三', '男', 'abc123', 'zhangshisan@example.com'),
(12, '李十四', '女', '456def', 'lishisi@example.com'),
(13, '赵十五', '男', 'def456', 'zhaoshiwu@example.com'),
(14, '钱十六', '女', '789ghi', 'qianshiliu@example.com'),
(15, '孙十七', '男', 'ghi789', 'sunshiqi@example.com'),
(16, '周十八', '女', '123456', 'zhoushiba@example.com'),
(17, '吴十九', '男', '654321', 'wushijiu@example.com'),
(18, '郑二十', '女', 'qwerty', 'zhengershier@example.com'),
(19, '王二十一', '男', 'asdfgh', 'wangershiyi@example.com'),
(20, '张二十二', '女', 'zxcvbn', 'zhangershier@example.com'),
(21, '李二十三', '男', 'poiuyt', 'liershisan@example.com'),
(22, '赵二十四', '女', 'mnbvcx', 'zhaoershiyi@example.com'),
(23, '钱二十五', '男', 'lkjhgf', 'qianshier@example.com'),
(24, '孙二十六', '女', '098765', 'sunshiliu@example.com'),
(25, '周二十七', '男', '123abc', 'zhoushiqu@example.com'),
(26, '吴二十八', '女', 'abc123', 'wuerba@example.com'),
(27, '郑二十九', '男', '456def', 'zhengershiqi@example.com'),
(28, '王三十', '女', 'def456', 'wangshisan@example.com'),
(29, '张三十一', '男', '789ghi', 'zhangsanshiyi@example.com'),
(30, '李三十二', '女', 'ghi789', 'lishier@example.com'),
(31, '赵三十三', '男', '123456', 'zhaosanshiyi@example.com'),
(32, '钱三十四', '女', '654321', 'qianshisi@example.com'),
(33, '孙三十五', '男', 'qwerty', 'sunshiwu@example.com'),
(34, '周三十六', '女', 'asdfgh', 'zhoushiba@example.com'),
(35, '吴三十七', '男', 'zxcvbn', 'wushiqi@example.com'),
(36, '郑三十八', '女', 'poiuyt', 'zhengershijiu@example.com'),
(37, '王三十九', '男', 'mnbvcx', 'wangshisi@example.com'),
(38, '张四十', '女', 'lkjhgf', 'zhangsishi@example.com'),
(39, '李四十一', '男', '098765', 'lishiwu@example.com'),
(40, '赵四十二', '女', '123abc', 'zhaoshiba@example.com'),
(41, '钱四十三', '男', 'abc123', 'qianshisan@example.com'),
(42, '孙四十四', '女', '456def', 'sunshisi@example.com'),
(43, '周四十五', '男', 'def456', 'zhoushiwu@example.com'),
(44, '吴四十六', '女', '789ghi', 'wushier@example.com'),
(45, '郑四十七', '男', 'ghi789', 'zhengershiqi@example.com'),
(46, '王四十八', '女', '123456', 'wangshiwu@example.com'),
(47, '张四十九', '男', '654321', 'zhangsishi@example.com'),
(48, '李五十', '女', 'qwerty', 'liushi@example.com'),
(49, '赵五十一', '男', 'asdfgh', 'zhaowuyi@example.com'),
(50, '钱五十二', '女', 'zxcvbn', 'qianshier@example.com');
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)