Problems with SQL commands to Create a table?

Question

I need the SQL code that will create a table structure for a table named EMP_1. This table is a subset of the EMPLOYEE table.
The basic EMP_1 table structure is:
EMP_NUM CHAR(3),
EMP_LNAME VARCHAR(15),
EMP_FNAME VARCHAR(15),
EMP_INITIAL CHAR(1),
EMPL_HIREDATE DATE,
JOB_CODE CHAR(3).
JOB_CODE is the FK to JOB.

I have entered this command like 15 times and I keep getting the error that a line is missing right parenthesis, and I put it in there. Can someone tell me how to format this correctly?

Answer 1

This will work in MySQL:



CREATE TABLE IF NOT EXISTS EMP_1

(

EMP_NUM NOT CHAR(3) NOT NULL,

EMP_LNAME VARCHAR(15),

EMP_FNAME VARCHAR(15),

EMP_INITIAL CHAR(1),

EMPL_HIREDATE DATE,

JOB_CODE CHAR(3) NOT NULL

PRIMARY KEY(EMP_NUM),

FOREIGN KEY(JOB_CODE) REFERENCES JOB (JOB_CODE)

)

Answer 2

what exactly do you mean by structure? heres the sql's great tutorial on tables and everything else.. http://dev.mysql.com/doc/refman/5.0/en/creating-tables.html

Answer 3

If you used the "insert" statement on the students table, did you use "commit;" afterward?