使用MySQL创造一个表具有四种信息不少于五十条

CREATE TABLE my_table ( id INT(11) NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, age INT(3) NOT NULL, gender VARCHAR(10) NOT NULL, address VARCHAR(100) NOT NULL, PRIMARY KEY (id) );

INSERT INTO my_table (name, age, gender, address) VALUES ('John Smith', 25, 'Male', '123 Main St, Anytown USA'), ('Jane Doe', 32, 'Female', '456 High St, Anytown USA'), ('Bob Johnson', 45, 'Male', '789 Broadway, Anytown USA'), ('Samantha Lee', 28, 'Female', '246 Elm St, Anytown USA'), ('Michael Brown', 39, 'Male', '135 Oak St, Anytown USA'), ('Emily Davis', 22, 'Female', '789 Maple St, Anytown USA'), ('David Rodriguez', 31, 'Male', '369 Pine St, Anytown USA'), ('Ashley Kim', 27, 'Female', '246 Cedar St, Anytown USA'), ('William Jones', 41, 'Male', '579 Walnut St, Anytown USA'), ('Jessica Chang', 24, 'Female', '369 Cherry St, Anytown USA'), ('Mark Davis', 29, 'Male', '135 Orange St, Anytown USA'), ('Alex Kim', 37, 'Male', '579 Pine St, Anytown USA'), ('Amanda Lee', 26, 'Female', '789 Cedar St, Anytown USA'), ('Sarah Johnson', 33, 'Female', '246 Walnut St, Anytown USA'), ('Chris Brown', 38, 'Male', '369 Maple St, Anytown USA'), ('Jennifer Smith', 23, 'Female', '579 Main St, Anytown USA'), ('Ryan Lee', 30, 'Male', '135 High St, Anytown USA'), ('Stephanie Davis', 27, 'Female', '789 Broadway, Anytown USA'), ('Eric Rodriguez', 42, 'Male', '246 Elm St, Anytown USA'), ('Rachel Kim', 25, 'Female', '369 Oak St, Anytown USA'), ('Jason Jones', 34, 'Male', '579 Maple St, Anytown USA'), ('Hannah Chang', 21, 'Female', '135 Cherry St, Anytown USA'), ('Brandon Davis', 31, 'Male', '789 Orange St, Anytown USA'), ('Nicole Lee', 26, 'Female', '369 Pine St, Anytown USA'), ('Justin Johnson', 39, 'Male', '579 Cedar St, Anytown USA'), ('Megan Brown', 28, 'Female', '246 Walnut St, Anytown USA'), ('Matthew Smith', 27, 'Male', '135 Maple St, Anytown USA'), ('Lauren Davis', 23, 'Female', '789 Main St, Anytown USA'), ('Adam Rodriguez', 41, 'Male', '246 High St, Anytown USA'), ('Katie Kim', 22, 'Female', '369 Broadway, Anytown USA'), ('Andrew Jones', 35, 'Male', '579 Elm St, Anytown USA'), ('Olivia Chang', 25, 'Female', '135 Oak St, Anytown USA'), ('Jacob Davis', 30, 'Male', '789 Pine St, Anytown USA'), ('Taylor Lee', 29, 'Female', '246 Cedar St, Anytown USA'), ('Kevin Johnson', 40, 'Male', '369 Walnut St, Anytown USA'), ('Grace Brown', 24, 'Female', '579 Cherry St, Anytown USA'), ('Steven Smith', 28, 'Male', '246 Orange St, Anytown USA'), ('Kayla Davis', 26, 'Female', '135 Pine St, Anytown USA'), ('Daniel Rodriguez', 43, 'Male', '789 Cedar St, Anytown USA'), ('Chloe Kim', 23, 'Female', '369 Walnut St, Anytown USA'), ('Robert Jones', 36, 'Male', '579 Maple St, Anytown USA'), ('Madison Chang', 20, 'Female', '246 Cherry St, Anytown USA'), ('Joshua Davis', 32, 'Male', '135 Orange St, Anytown USA'), ('Emma Lee', 31, 'Female', '789 Main St, Anytown USA'), ('Christopher Johnson', 38, 'Male', '246 High St, Anytown USA'), ('Lily Brown', 27, 'Female', '369 Broadway, Anytown USA'), ('Nicholas Smith', 26, 'Male', '579 Elm St, Anytown USA'), ('Avery Davis', 24, 'Female', '135 Oak St, Anytown USA'), ('Gabriel Rodriguez', 44, 'Male', '789 Pine St, Anytown USA'), ('Victoria Kim', 22, 'Female', '246 Cedar St, Anytown USA'), ('Joshua Jones', 37, 'Male', '369 Walnut St, Anytown USA'), ('Natalie Chang', 19, 'Female', '579 Cherry St, Anytown USA'), ('Ethan Davis', 33, 'Male', '246 Orange St, Anytown USA'), ('Isabella Lee', 30, 'Female', '135 Pine St, Anytown USA'), ('Tyler Johnson', 37, 'Male', '789 Cedar St, Anytown USA'), ('Zoe Brown', 25, 'Female', '369 Walnut St, Anytown USA'), ('Brandon Smith', 29, 'Male', '579 Maple St, Anytown USA'), ('Sophia Davis', 22, 'Female', '246 Cherry St, Anytown USA'), ('Christopher Rodriguez', 45, 'Male', '135 Orange St, Anytown USA'), ('Haley Kim', 21, 'Female', '789 Main St, Anytown USA'), ('David Jones', 34, 'Male', '246 High St, Anytown USA'), ('Alyssa Chang', 18, 'Female', '369 Broadway, Anytown USA'), ('William Davis', 31, 'Male', '579 Elm St, Anytown USA'), ('Kaylee Lee', 28, 'Female', '135 Oak St, Anytown USA'), ('Jacob Johnson', 36, 'Male', '789 Pine St, Anytown USA'), ('Emma Brown', 23, 'Female', '246 Cedar St, Anytown USA')