Database in Linux

Follow the instruction to create database and tabel in mysql.

Go to terminal with root.
Assuming you have installed mysql in your linux version and no password for accessing mysql.
#mysql -u root
mysql> create database new;
Query OK, 1 row effected (0.02 Sec)
mysql> use new;
database changed
mysql>create table emp_data(EMP_NO varchar(10),EMP_NAME varchar(30),EMP_ADDRESS varchar(60),EMP_AGE varchar(3),EMP_GENDER varchar(6),EMP_DESIGNATION varchar(15),EMP_BASIC_SALARYvarchar(10));

TABLE CREATED SUCCESSFULLY.