以 id int11 NOT NULL AUTO_INCREMENT username varchar20 NOT NULL password varchar20 DEFAULT NULL name varchar20 DEFAULT NULL gender varchar20 DEFAULT NULL age int11 DEFAULT NULL phone varchar20 DE
INSERT INTO table_name (id, username, password, name, gender, age, phone, department) VALUES (1, 'user1', 'password1', 'John Doe', 'male', 25, '1234567890', 'IT'), (2, 'user2', 'password2', 'Jane Smith', 'female', 30, '9876543210', 'HR'), (3, 'user3', 'password3', 'Michael Johnson', 'male', 35, '5555555555', 'Marketing'), (4, 'user4', 'password4', 'Emily Davis', 'female', 28, '1111111111', 'Finance'), (5, 'user5', 'password5', 'Robert Wilson', 'male', 32, '9999999999', 'Sales'), (6, 'user6', 'password6', 'Emma Thompson', 'female', 27, '7777777777', 'IT'), (7, 'user7', 'password7', 'David Anderson', 'male', 31, '8888888888', 'HR'), (8, 'user8', 'password8', 'Olivia Taylor', 'female', 29, '2222222222', 'Marketing'), (9, 'user9', 'password9', 'James Harris', 'male', 33, '4444444444', 'Finance'), (10, 'user10', 'password10', 'Sophia Brown', 'female', 26, '6666666666', 'Sales'), (11, 'user11', 'password11', 'Daniel Wilson', 'male', 30, '5555555555', 'IT'), (12, 'user12', 'password12', 'Isabella Thompson', 'female', 25, '7777777777', 'HR'), (13, 'user13', 'password13', 'Ethan Anderson', 'male', 29, '8888888888', 'Marketing'), (14, 'user14', 'password14', 'Mia Taylor', 'female', 32, '2222222222', 'Finance'), (15, 'user15', 'password15', 'Alexander Harris', 'male', 27, '4444444444', 'Sales'), (16, 'user16', 'password16', 'Ava Brown', 'female', 31, '6666666666', 'IT'), (17, 'user17', 'password17', 'Jacob Johnson', 'male', 28, '1111111111', 'HR'), (18, 'user18', 'password18', 'Charlotte Smith', 'female', 33, '9876543210', 'Marketing'), (19, 'user19', 'password19', 'William Doe', 'male', 26, '1234567890', 'Finance'), (20, 'user20', 'password20', 'Sophia Wilson', 'female', 30, '9999999999', 'Sales')
原文地址: http://www.cveoy.top/t/topic/iJK5 著作权归作者所有。请勿转载和采集!