employees.sql

来自「php开发实例完全剖析」· SQL 代码 · 共 12 行

use test;
CREATE TABLE employees (  id tinyint(4) NOT NULL AUTO_INCREMENT, 
				first varchar(20),  
				last varchar(20),   
				address varchar(255),
				position varchar(50),
				PRIMARY KEY (id),  
				UNIQUE id (id)
			);
INSERT INTO employees VALUES (1,'Bob','Smith','128 Here St, Cityname','Marketing Manager');
INSERT INTO employees VALUES (2,'John','Roberts','45 There St , Townville','Telephonist');
INSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd, Snowston','Doorman');