From: Christian Parpart
Date: September 17 2005 3:07pm
Subject: Re: UUIDs - first usage for me
List-Archive: http://lists.mysql.com/mysql/189204
Message-Id: <200509171707.56711.trapni@gentoo.org>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart2618371.xKMObN5h8K";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart2618371.xKMObN5h8K
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On Saturday 17 September 2005 08:34, Gleb Paharenko wrote:
> mysql> show create table ui\G;
>
> *************************** 1. row ***************************
>
> Table: ui
>
> Create Table: CREATE TABLE `ui` (
>
> `uuid()` varchar(36) NOT NULL default ''

I've been testing your example as I feel really much safer with UUIDs inste=
ad=20
of auto_increments, however, my column datatype is VARCHAR(12) so 24bytes=20
shorter than a usual UUID, although, all uuid() SELECTs differ only in firs=
t=20
12 bytes - why?

Regards,
Christian Parpart.

--nextPart2618371.xKMObN5h8K
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQBDLDFMPpa2GmDVhK0RAvQiAJ90LbEZYNlhnsuTtX/fy6DgHyBtzQCfQKGb
qHAsepPTL7lCGAvHxLM1oiQ=
=fW9y
-----END PGP SIGNATURE-----

--nextPart2618371.xKMObN5h8K--