用 username password name birthday sex telephoneemail status code写50条mysql数据且status为char类型的
INSERT INTO users (username, password, name, birthday, sex, telephone, email, status, code) VALUES ('user1', '123456', 'John', '1990-01-01', 'Male', '1234567890', 'john@example.com', 'Active', 'A001'), ('user2', 'password123', 'Jane', '1995-05-10', 'Female', '9876543210', 'jane@example.com', 'Inactive', 'A002'), ('user3', 'abc123', 'Mike', '1988-11-15', 'Male', '4567890123', 'mike@example.com', 'Active', 'A003'), ('user4', 'qwerty', 'Lisa', '1992-03-20', 'Female', '7890123456', 'lisa@example.com', 'Active', 'A004'), ('user5', 'password', 'David', '1985-07-25', 'Male', '2345678901', 'david@example.com', 'Inactive', 'A005'), ('user6', 'pass123', 'Sarah', '1998-09-30', 'Female', '9012345678', 'sarah@example.com', 'Active', 'A006'), ('user7', '123abc', 'Tom', '1987-04-05', 'Male', '3456789012', 'tom@example.com', 'Active', 'A007'), ('user8', 'abcd1234', 'Emily', '1993-02-15', 'Female', '6789012345', 'emily@example.com', 'Inactive', 'A008'), ('user9', 'password456', 'Chris', '1991-06-12', 'Male', '0123456789', 'chris@example.com', 'Active', 'A009'), ('user10', 'qwerty123', 'Amy', '1994-08-22', 'Female', '9012345678', 'amy@example.com', 'Active', 'A010'), ('user11', 'pass567', 'Mark', '1989-12-07', 'Male', '2345678901', 'mark@example.com', 'Inactive', 'A011'), ('user12', '12345678', 'Anna', '1996-10-17', 'Female', '4567890123', 'anna@example.com', 'Active', 'A012'), ('user13', 'password789', 'Jason', '1986-02-27', 'Male', '7890123456', 'jason@example.com', 'Active', 'A013'), ('user14', 'abc123def', 'Mary', '1997-04-23', 'Female', '2345678901', 'mary@example.com', 'Inactive', 'A014'), ('user15', 'passpass', 'Emma', '1999-08-05', 'Female', '9012345678', 'emma@example.com', 'Active', 'A015'), ('user16', 'qwertyuiop', 'Daniel', '1984-06-29', 'Male', '3456789012', 'daniel@example.com', 'Active', 'A016'), ('user17', 'password1234', 'Olivia', '1992-12-11', 'Female', '6789012345', 'olivia@example.com', 'Inactive', 'A017'), ('user18', 'abcdefg', 'Kevin', '1990-09-12', 'Male', '0123456789', 'kevin@example.com', 'Active', 'A018'), ('user19', 'passpass123', 'Sophia', '1995-07-08', 'Female', '9012345678', 'sophia@example.com', 'Active', 'A019'), ('user20', '1234567890', 'Jacob', '1988-03-16', 'Male', '2345678901', 'jacob@example.com', 'Inactive', 'A020'), ('user21', 'password12345', 'Grace', '1993-01-25', 'Female', '4567890123', 'grace@example.com', 'Active', 'A021'), ('user22', 'abc123456', 'Ben', '1991-11-20', 'Male', '7890123456', 'ben@example.com', 'Active', 'A022'), ('user23', 'qazwsx', 'Lily', '1997-09-02', 'Female', '2345678901', 'lily@example.com', 'Inactive', 'A023'), ('user24', 'poiuyt', 'Andrew', '1986-07-13', 'Male', '9012345678', 'andrew@example.com', 'Active', 'A024'), ('user25', 'password123456', 'Mia', '1999-05-18', 'Female', '3456789012', 'mia@example.com', 'Active', 'A025'), ('user26', 'abcdef', 'Jonathan', '1994-03-11', 'Male', '6789012345', 'jonathan@example.com', 'Inactive', 'A026'), ('user27', 'pass1234', 'Chloe', '1989-01-07', 'Female', '0123456789', 'chloe@example.com', 'Active', 'A027'), ('user28', '123456789', 'Hannah', '1996-11-22', 'Female', '9012345678', 'hannah@example.com', 'Active', 'A028'), ('user29', 'passwordpass', 'Jack', '1987-05-14', 'Male', '2345678901', 'jack@example.com', 'Inactive', 'A029'), ('user30', 'qwerty12345', 'Sophie', '1992-09-30', 'Female', '4567890123', 'sophie@example.com', 'Active', 'A030'), ('user31', 'abc12345678', 'Luke', '1985-11-01', 'Male', '7890123456', 'luke@example.com', 'Active', 'A031'), ('user32', 'pass123456', 'Nora', '1990-07-19', 'Female', '2345678901', 'nora@example.com', 'Inactive', 'A032'), ('user33', 'password1234567', 'Jacob', '1995-12-08', 'Male', '9012345678', 'jacob@example.com', 'Active', 'A033'), ('user34', 'abcdefgh', 'Ella', '1988-08-14', 'Female', '3456789012', 'ella@example.com', 'Active', 'A034'), ('user35', 'passpasspass', 'Liam', '1993-06-04', 'Male', '6789012345', 'liam@example.com', 'Inactive', 'A035'), ('user36', '1234567890', 'Ava', '1991-04-09', 'Female', '0123456789', 'ava@example.com', 'Active', 'A036'), ('user37', 'password12345', 'Noah', '1994-02-28', 'Male', '9012345678', 'noah@example.com', 'Active', 'A037'), ('user38', 'qwertyui', 'Amelia', '1986-12-14', 'Female', '2345678901', 'amelia@example.com', 'Inactive', 'A038'), ('user39', 'abcdefghi', 'Ethan', '1999-10-23', 'Male', '5678901234', 'ethan@example.com', 'Active', 'A039'), ('user40', 'pass5678', 'Isabella', '1998-08-07', 'Female', '9012345678', 'isabella@example.com', 'Active', 'A040'), ('user41', '123abc', 'Mason', '1987-06-19', 'Male', '2345678901', 'mason@example.com', 'Inactive', 'A041'), ('user42', 'password1234', 'Mia', '1993-04-11', 'Female', '4567890123', 'mia@example.com', 'Active', 'A042'), ('user43', 'abcdefg', 'Lucas', '1996-02-22', 'Male', '7890123456', 'lucas@example.com', 'Active', 'A043'), ('user44', 'pass12345', 'Emily', '1988-12-02', 'Female', '2345678901', 'emily@example.com', 'Inactive', 'A044'), ('user45', '1234567', 'Abigail', '1995-10-15', 'Female', '9012345678', 'abigail@example.com', 'Active', 'A045'), ('user46', 'password12', 'Alexander', '1989-08-25', 'Male', '3456789012', 'alexander@example.com', 'Active', 'A046'), ('user47', 'abcdefghij', 'Evelyn', '1992-06-30', 'Female', '6789012345', 'evelyn@example.com', 'Inactive', 'A047'), ('user48', 'passpass12', 'James', '1997-05-23', 'Male', '0123456789', 'james@example.com', 'Active', 'A048'), ('user49', '123456789', 'Elizabeth', '1991-03-17', 'Female', '9012345678', 'elizabeth@example.com', 'Active', 'A049'), ('user50', 'password123', 'William', '1986-01-05', 'Male', '2345678901', 'william@example.com', 'Inactive', 'A050')
原文地址: https://www.cveoy.top/t/topic/iBOF 著作权归作者所有。请勿转载和采集!