creating MySql tables

 

mysql> CREATE DATABASE BANK ;    

  Query OK, 1 row affected (0.00 sec)   

mysql> USE BANK ;

Database changed

mysql> CREATE TABLE EMP

    -> (

    -> EMPNO INTEGER,

    -> ENAME CHAR(15),

    -> JOB CHAR(15),

    -> MGR INTEGER,

    -> HIREDATE DATE,

    -> SAL INTEGER,

    -> COMM INTEGER,

    -> DEPTNO INTEGER ) ;

Query OK, 0 rows affected (0.07 sec)

mysql> INSERT INTO EMP VALUES(8369,'SMITH','CLERK',8902,'1990-12-18',800,100,20);                                                                            

  Query OK, 1 row affected (0.04 sec)         

                                 

mysql> SELECT * FROM EMP ;

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
8369	SMITH	CLERK	8902	1990-12-18	800	100	20
8499	ANYA	SALESMAN	8698	1991-02-20	1600	300	30
8521	SETH	SALESMAN	8698	1991-02-22	1250	500	30
8566	MAHADEVAN	MANAGER	8839	1991-04-02	2985	200	20
8698	BINA	MANAGER	8839	1991-05-01	2850	400	30
8839	AMIR	MANAGER	8840	1991-11-18	3000	200	10
8993	TAJINDER	SALESMAN	8888	1992-03-11	3300	210	10
8999	HARPREET	CLERK	8878	1992-03-20	300	100	20