empdata.sql

来自「SQL Database, simple program for sql lea」· SQL 代码 · 共 1 行

create database if not exists employees;          use employees;          drop table if exists emptable;          create table if not exists emptable               (empid char(5) primary key,               firstname varchar(20),                lastname varchar(30),               street varchar(20),                city varchar(20),                state varchar(20),                zip char(10),               homephone varchar(12),                officephone varchar(12),               department varchar(12),                yearsemploy int,                monthpay float);           insert into emptable values(               'ID111',               'Frank',               'Smith',               '55 South','Fullerton','CA','99999',               '444-4444','1234','Sales',               5,4543.33);