mysql 使用select建表_mysql create创建表、insert into插入数据、select查询数据实例

mysql创建表的sql代码如下：

CREATE TABLE Employee(

id int,

first_name VARCHAR(15),

last_name VARCHAR(15),

start_date DATE,

end_date DATE,

salary FLOAT(8,2),

city VARCHAR(10),

description VARCHAR(15)

);

或者是

CREATE TABLE IF NOT EXISTS Employee(

id int,

first_name VARCHAR(15),

last_name VARCHAR(15),

start_date DATE,

end_date DATE,

salary FLOAT(8,2),

city VARCHAR(10),

description VARCHAR(15)

);

mysql insert into插入数据代码如下：

insert into Employee(id,first_name,last_name,start_date,end_Date,salary,City,Description) values (8,'James','Cat','19960917','20020415',1232.78,'Vancouver','Tester');

/* http://www.manongjc.com/article/1437.html */

或批量插入：

insert into Employee(id,first_name,last_name,start_date,end_Date,salary,City,Description) values (8,'James','Cat','19960917','20020415',1232.78,'Vancouver','Tester'),(7,'David','Larry', '19901231','19980212',7897.78,'New York', 'Manager');

select查询表数据：

SELECT * FROM Employee WHERE (id,first_name) = (1,'Jason');