×
FREE ASSISTANCE FOR THE INQUISITIVE PEOPLE
Tutorial Topics
X
softetechnologies
SQL - Structured Query Language
CREATE TABLE - Structured Query Language - SQL
718    Arnab De    04/04/2018   

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

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
SQL - Structured Query Language
softetechnologies
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.
Enter New Comment
Comment History
No Comment Found Yet.
Albert Einstein
Education is what remains after one has forgotten what one has learned in school.
Albert Einstein
217
23.83
Today So Far
Total View (Lakh)
softetechnologies
01/01/2018     30778
28/06/2017     25550
02/08/2017     22003
26/05/2018     19715
15/05/2017     19354
06/07/2017     17900
21/04/2018     16863
01/08/2017     16539
01/07/2017     14551
25/04/2018     13616
softetechnologies