Question

Create a table employee (EMPNO int primary key, ENAME varchar (20) not null, JOB varchar (20), MGR int, HIRE DATE date, SALARY int, COMM decimal (5,2), DEPTNO int)?
MYSQL!!!!!!!!!!!!!!!!!!!!

Answer 1

create table employee

(

Empno integer primary key,

Ename varchar (20) not null,

JOB varchar (20),

MGR integer,

HIREDATE date,

SAL integer,

COMM decimal number(5,2),

DEPTNO integer

);

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!