CREATE TABLE - Structured Query Language
04-04-2018    449 times


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));

sql create table

Create table from an existing table with all data

mysql> create table emp1 as select * from emp;

sql create table

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

sql create table
    Author Details
Arnab De
I have over 16 years of experience working as an IT professional, ranging from teaching at my own institute to being a computer faculty at different leading institute across Kolkata. I also work as a web developer and designer, having worked for renowned companies and brand. Through tutorialathome, I wish to share my years of knowledge with the readers.
    Related Post
  Query About the post