empdata.sql

SQL Database, simple program for sql learner

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);