Hi Kranthi!
Kranthi schrieb: > 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(), > [[...]] > ) I don't know Microsoft SQL Server details, but this seems to be the equivalent of what is called "auto_increment" in MySQL. This might be a start point for reading: http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@oracle.com ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven Amtsgericht Muenchen: HRA 95603 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org