Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Saturday, 23 August 2014

Create table in MySql

We can create table in MySql with the help of following syntax:-

create table table_name
(
column_name data_type,
column_name data_type
.....
(n)
);

Below is the example:-

CREATE TABLE EMPLOYEE
(
EMP_ID INT,
EMP_NAME VARCHAR(20),
EMP_ADR VARCHAR(20), 
);




Read Also:- Create table in Oracle
Please provide your feedback in the comments section above. Please don't forget to follow.