Yurttas/PL/DBL/mysql-f-2010/01/Company-A/Employee-cre.sql
Revision as of 01:58, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Employee-cre.sql REM REM: \. set-db.sql CREATE TABLE Employee(fname VARCHAR(12) NOT NULL, ...")
1/*
2REM
3REM
4REM Employee-cre.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11CREATE TABLE Employee(fname VARCHAR(12) NOT NULL,
12 minit CHAR,
13 lname VARCHAR(16) NOT NULL,
14 ssn CHAR(9) NOT NULL,
15 bdate CHAR(9),
16 address VARCHAR(24),
17 sex CHAR,
18 salary FLOAT,
19 superssn CHAR(9),
20 dno INTEGER NOT NULL,
21 PRIMARY KEY(ssn));