Hi ,

         I am migrating the database from mssql server to Mysql.i am getting
problem with newid(),I don't know about newid(),i am using mysql migration
tool kit.

if anybody knows please help me. 

Ex:

CREATE TABLE cust

(

 cust_id uniqueidentifier NOT NULL

   DEFAULT newid(),

 company varchar(30) NOT NULL,

 contact_name varchar(60) NOT NULL, 

 address varchar(30) NOT NULL, 

 city varchar(30) NOT NULL,

 state_province varchar(10) NULL,

 country varchar(20) NOT NULL, 

 )

GO

 

Thanks & Regards,

Kranthi

Reply via email to