Syntax Difference between MS Sql and My Sql

please check the following links,

http://vijaymodi.wordpress.com/2007/11/24/syntax-difference-between-ms-sql-and-my-sql/

http://www.mssqltips.com/sqlservertutorial/2204/mysql-to-sql-server-coding-differences/

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