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