CREATE TABLE customer ( customer_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, gender ENUM( male , female ) NOT NULL, phone VARCHAR(20) NOT NULL, address VARCHAR(200) NOT NULL )插入张三，李四，王五，王二麻的基本数据

好的，您可以使用以下SQL语句来插入这四个人的基本数据：

INSERT INTO customer (name, gender, phone, address) VALUES 
('张三', 'male', '13811111111', '北京市朝阳区'),
('李四', 'male', '13922222222', '上海市浦东新区'),
('王五', 'male', '13633333333', '广州市天河区'),
('王二麻', 'male', '13744444444', '深圳市南山区');

执行后，您可以使用`SELECT * FROM customer;`来查看插入的数据。

相关问题

CREATE TABLE customer ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, gender ENUM('男', '女') NOT NULL, phone VARCHAR(20) NOT NULL, address VARCHAR(100) NOT NULL ); CREATE TABLE car_model( id INT PRIMARY KEY AUTO_INCREMENT, brand VARCHAR(50) NOT NULL, model VARCHAR(50) NOT NULL, price DECIMAL(10,2) NOT NULL ); CREATE TABLE car( model_id INT PRIMARY KEY AUTO_INCREMENT, color VARCHAR(50) NOT NULL, description VARCHAR(50) NOT NULL ); CREATE TABLE order1( id INT PRIMARY KEY AUTO_INCREMENT, customer_id INT NOT NULL, car_id INT NOT NULL, order_date DATETIME NOT NULL , price DECIMAL(10,2) NOT NULL, ); CREATE TABLE employee( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, gender ENUM('男', '女') NOT NULL, phone VARCHAR(20) NOT NULL, address VARCHAR(100) NOT NULL, salary DECIMAL(10,2) NOT NULL给出五个存储函数以及调用语句 );

存储函数1：

DELIMITER //
CREATE FUNCTION get_total_price(order_id INT)
RETURNS DECIMAL(10,2)
BEGIN
DECLARE total_price DECIMAL(10,2);
SELECT SUM(price) INTO total_price FROM order1 WHERE id = order_id;
RETURN total_price;
END//
DELIMITER ;

调用语句：SELECT get_total_price(1);

存储函数2：

DELIMITER //
CREATE FUNCTION get_customer_orders(customer_name VARCHAR(50))
RETURNS INT
BEGIN
DECLARE order_count INT;
SELECT COUNT(*) INTO order_count FROM order1 o JOIN customer c ON o.customer_id = c.id WHERE c.name = customer_name;
RETURN order_count;
END//
DELIMITER ;

调用语句：SELECT get_customer_orders('John Doe');

存储函数3：

DELIMITER //
CREATE FUNCTION get_employee_salary_increase(employee_id INT, percent DECIMAL(10,2))
RETURNS DECIMAL(10,2)
BEGIN
UPDATE employee SET salary = salary * (1 + percent/100) WHERE id = employee_id;
RETURN salary;
END//
DELIMITER ;

调用语句：SELECT get_employee_salary_increase(1, 10);

存储函数4：

DELIMITER //
CREATE FUNCTION get_model_count(brand_name VARCHAR(50))
RETURNS INT
BEGIN
DECLARE model_count INT;
SELECT COUNT(*) INTO model_count FROM car_model WHERE brand = brand_name;
RETURN model_count;
END//
DELIMITER ;

调用语句：SELECT get_model_count('Toyota');

存储函数5：

DELIMITER //
CREATE FUNCTION get_car_info(car_id INT)
RETURNS VARCHAR(100)
BEGIN
DECLARE car_info VARCHAR(100);
SELECT CONCAT(c.color, ' ', cm.brand, ' ', cm.model) INTO car_info FROM car c JOIN car_model cm ON c.model_id = cm.id WHERE c.id = car_id;
RETURN car_info;
END//
DELIMITER ;

调用语句：SELECT get_car_info(1);

CREATE TABLE employee ( employee_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, gender ENUM('male', 'female') NOT NULL, phone VARCHAR(20) NOT NULL, address VARCHAR(200) NOT NULL )中插入亚索，永恩，锐雯，盖伦的基本数据

好的，您可以使用以下SQL语句来插入这四个员工的基本数据：

INSERT INTO employee (name, gender, phone, address) VALUES 
('亚索', 'male', '13811112222', '艾欧尼亚'),
('永恩', 'male', '13922223333', '诺克萨斯'),
('锐雯', 'female', '13633334444', '艾欧尼亚'),
('盖伦', 'male', '13744445555', '德玛西亚');

执行后，您可以使用`SELECT * FROM employee;`来查看插入的数据。