Monday 28 July 2014

Add primary key constraint in MySql syntax

syntax for an primary key in My Sql

Create Table tablename
(
      [columnname] [datatype] [columnconstraint] [table constraint] [column name]
);


Example:

Create Table Table1
(
      ID Not Null auto_Increment,
      Name varchar(256) ,
      primary key (ID)
);

Happy Scripting :)

No comments:

Post a Comment