Showing posts with label primary key constraint In My Sql. Show all posts
Showing posts with label primary key constraint In My Sql. Show all posts

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