首页zs age:28,salary:20000,address:beijing ls age:25,salary:10000,address:sh as age:30,salary:30000,address:sz fs age:24,salary:8000,address:sz建表

zs age:28,salary:20000,address:beijing ls age:25,salary:10000,address:sh as age:30,salary:30000,address:sz fs age:24,salary:8000,address:sz建表

时间: 2024-01-07 10:05:51 浏览: 72

好的，以下是根据你提供的信息创建的表： ``` CREATE TABLE employees ( name VARCHAR(50) NOT NULL, age INT NOT NULL, salary INT NOT NULL, address VARCHAR(100) NOT NULL ); ``` 然后，你可以通过以下 SQL 语句将员工信息插入到表中： ``` INSERT INTO employees (name, age, salary, address) VALUES ('zs', 28, 20000, 'beijing'), ('ls', 25, 10000, 'sh'), ('as', 30, 30000, 'sz'), ('fs', 24, 8000, 'sz'); ``` 请注意，这只是一个示例，实际的表结构可能需要根据具体需求进行调整。

阅读全文