Question

I don't know how to write sql query to create table plzz help me

Answer 1

For example , if you are creating a table for the employers of a company

Table emp

CREATE TABLE emp (EMPNO int(4), ENAME varchar(10), JOB varchar(9),

MGR int(4) , HIREDATE date , SAL decimal(7,2),  COMM decimal(7,2),

DEPTNO int(2));