CREATE TABLE STATEMENT - SQL

We can create tables to store data using CREATE TABLE Statement in any RDBMS. This Statement is differ in different RDBMS.

Basic Systax:

CREATE TABLE <table-name>(List of fields with comma (,) sepators);

Create table statement in MySQL.

mysql>CREATE TABLE emp(eid int(11),ename varchar(40),doj date,salary double(10,2),deptno int(11));

Create table from an existing table with all data

mysql> create table emp1 as select * from emp;

Create table from an existing table with no data

mysql> create table emp2 as select * from emp where eid=-1;
Query OK, 0 rows affected
Records: 0  Duplicates: 0  Warnings: 0