用 username password name birthday sex telephoneemail status code写50条mysql数据
以下是一个示例的MySQL数据插入语句,包含了50条数据:
INSERT INTO users (username, password, name, birthday, sex, telephone, email, status, code) VALUES ('user1', 'password1', 'John Doe', '1990-01-01', 'M', '1234567890', 'user1@example.com', 'active', 'code1'), ('user2', 'password2', 'Jane Smith', '1995-02-02', 'F', '9876543210', 'user2@example.com', 'inactive', 'code2'), ('user3', 'password3', 'David Johnson', '1985-03-03', 'M', '1112223333', 'user3@example.com', 'active', 'code3'), ('user4', 'password4', 'Sarah Williams', '1992-04-04', 'F', '4445556666', 'user4@example.com', 'active', 'code4'), ('user5', 'password5', 'Michael Brown', '1988-05-05', 'M', '7778889999', 'user5@example.com', 'inactive', 'code5'), ('user6', 'password6', 'Jessica Miller', '1993-06-06', 'F', '2223334444', 'user6@example.com', 'active', 'code6'), ('user7', 'password7', 'Christopher Davis', '1987-07-07', 'M', '5556667777', 'user7@example.com', 'active', 'code7'), ('user8', 'password8', 'Amanda Wilson', '1991-08-08', 'F', '8889990000', 'user8@example.com', 'inactive', 'code8'), ('user9', 'password9', 'Matthew Anderson', '1986-09-09', 'M', '3334445555', 'user9@example.com', 'active', 'code9'), ('user10', 'password10', 'Emily Martinez', '1994-10-10', 'F', '6667778888', 'user10@example.com', 'active', 'code10'), ('user11', 'password11', 'Andrew Taylor', '1989-11-11', 'M', '2223334444', 'user11@example.com', 'inactive', 'code11'), ('user12', 'password12', 'Olivia Thomas', '1990-12-12', 'F', '5556667777', 'user12@example.com', 'active', 'code12'), ('user13', 'password13', 'Daniel Hernandez', '1985-01-13', 'M', '8889990000', 'user13@example.com', 'active', 'code13'), ('user14', 'password14', 'Sophia Moore', '1992-02-14', 'F', '3334445555', 'user14@example.com', 'inactive', 'code14'), ('user15', 'password15', 'James Clark', '1988-03-15', 'M', '6667778888', 'user15@example.com', 'active', 'code15'), ('user16', 'password16', 'Isabella Rodriguez', '1993-04-16', 'F', '2223334444', 'user16@example.com', 'active', 'code16'), ('user17', 'password17', 'Joseph Lee', '1987-05-17', 'M', '5556667777', 'user17@example.com', 'inactive', 'code17'), ('user18', 'password18', 'Mia Walker', '1991-06-18', 'F', '8889990000', 'user18@example.com', 'active', 'code18'), ('user19', 'password19', 'David Young', '1986-07-19', 'M', '3334445555', 'user19@example.com', 'active', 'code19'), ('user20', 'password20', 'Abigail Hall', '1994-08-20', 'F', '6667778888', 'user20@example.com', 'active', 'code20'), ('user21', 'password21', 'William Allen', '1989-09-21', 'M', '2223334444', 'user21@example.com', 'inactive', 'code21'), ('user22', 'password22', 'Elizabeth King', '1990-10-22', 'F', '5556667777', 'user22@example.com', 'active', 'code22'), ('user23', 'password23', 'Charles Scott', '1985-11-23', 'M', '8889990000', 'user23@example.com', 'active', 'code23'), ('user24', 'password24', 'Sofia Green', '1992-12-24', 'F', '3334445555', 'user24@example.com', 'inactive', 'code24'), ('user25', 'password25', 'Christopher Adams', '1988-01-25', 'M', '6667778888', 'user25@example.com', 'active', 'code25'), ('user26', 'password26', 'Ava Baker', '1993-02-26', 'F', '2223334444', 'user26@example.com', 'active', 'code26'), ('user27', 'password27', 'Matthew Gonzalez', '1987-03-27', 'M', '5556667777', 'user27@example.com', 'inactive', 'code27'), ('user28', 'password28', 'Harper Nelson', '1991-04-28', 'F', '8889990000', 'user28@example.com', 'active', 'code28'), ('user29', 'password29', 'Ethan Carter', '1986-05-29', 'M', '3334445555', 'user29@example.com', 'active', 'code29'), ('user30', 'password30', 'Amelia Hill', '1994-06-30', 'F', '6667778888', 'user30@example.com', 'active', 'code30'), ('user31', 'password31', 'Alexander Mitchell', '1989-07-31', 'M', '2223334444', 'user31@example.com', 'inactive', 'code31'), ('user32', 'password32', 'Sophie Perez', '1990-08-01', 'F', '5556667777', 'user32@example.com', 'active', 'code32'), ('user33', 'password33', 'Benjamin Roberts', '1985-09-02', 'M', '8889990000', 'user33@example.com', 'active', 'code33'), ('user34', 'password34', 'Grace Turner', '1992-10-03', 'F', '3334445555', 'user34@example.com', 'inactive', 'code34'), ('user35', 'password35', 'Daniel Phillips', '1988-11-04', 'M', '6667778888', 'user35@example.com', 'active', 'code35'), ('user36', 'password36', 'Chloe Campbell', '1993-12-05', 'F', '2223334444', 'user36@example.com', 'active', 'code36'), ('user37', 'password37', 'William Evans', '1987-01-06', 'M', '5556667777', 'user37@example.com', 'inactive', 'code37'), ('user38', 'password38', 'Natalie Edwards', '1991-02-07', 'F', '8889990000', 'user38@example.com', 'active', 'code38'), ('user39', 'password39', 'Henry Collins', '1986-03-08', 'M', '3334445555', 'user39@example.com', 'active', 'code39'), ('user40', 'password40', 'Lily Stewart', '1994-04-09', 'F', '6667778888', 'user40@example.com', 'active', 'code40'), ('user41', 'password41', 'Josephine Sanchez', '1989-05-10', 'F', '2223334444', 'user41@example.com', 'inactive', 'code41'), ('user42', 'password42', 'Christopher Morris', '1990-06-11', 'M', '5556667777', 'user42@example.com', 'active', 'code42'), ('user43', 'password43', 'Zoe Rogers', '1985-07-12', 'F', '8889990000', 'user43@example.com', 'active', 'code43'), ('user44', 'password44', 'Julian Rivera', '1992-08-13', 'M', '3334445555', 'user44@example.com', 'inactive', 'code44'), ('user45', 'password45', 'Audrey Peterson', '1988-09-14', 'F', '6667778888', 'user45@example.com', 'active', 'code45'), ('user46', 'password46', 'Luke Murphy', '1993-10-15', 'M', '2223334444', 'user46@example.com', 'active', 'code46'), ('user47', 'password47', 'Avery Gray', '1987-11-16', 'F', '5556667777', 'user47@example.com', 'inactive', 'code47'), ('user48', 'password48', 'Scarlett Cook', '1991-12-17', 'F', '8889990000', 'user48@example.com', 'active', 'code48'), ('user49', 'password49', 'Jack Long', '1986-01-18', 'M', '3334445555', 'user49@example.com', 'active', 'code49'), ('user50', 'password50', 'Hannah Bell', '1994-02-19', 'F', '6667778888', 'user50@example.com', 'active', 'code50');
请注意,上述示例中的“users”是表名,需要根据实际情况进行替换。此外,日期格式可能需要根据数据库配置进行调整
原文地址: http://www.cveoy.top/t/topic/iBOu 著作权归作者所有。请勿转载和采集!