From: Joerg Bruehe
Date: August 13 2010 10:01am
Subject: Re: Reg: Migration
List-Archive: http://lists.mysql.com/mysql/222520
Message-Id: <4C6517E6.1060705@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

Hi Kranthi!


Kranthi schrieb:
> Hi ,
>=20
>          I am migrating the database from mssql server to Mysql.i am ge=
tting
> problem with newid(),I don't know about newid(),i am using mysql migrat=
ion
> tool kit.
>=20
> if anybody knows please help me.=20
>=20
> Ex:
>=20
> 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=F6rg

--=20
Joerg Bruehe,  MySQL Build Team,  joerg.bruehe@stripped
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