help on mysql

Article View: bit.databases.mssql-l

Article #138

Back to bit.databases.mssql-l Previous Next

#138

From: Goldencat
Date: Wed, 18 Oct 2000 00:00

7 lines
921 bytes

i need to give an id by (today's date + a number)
like 200010170001....200010170002...and go on
how to do it under mysql?
event_id date+int unsigned not null auto_increment primary key ????
i know it's not work. hope you know what's my means.

goldencat

Technical Details

Message-ID: <Nv7H5.357$TO4.21406@bgtnsc04-news.ops.worldnet.att.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,fc32b9a928be99c4,start
X-Google-Attributes: gidf6611,public
From: "Goldencat" <ruili@worldnet.att.net>
Subject: help on mysql
Date: 2000/10/18
Message-ID: <Nv7H5.357$TO4.21406@bgtnsc04-news.ops.worldnet.att.net>
X-Deja-AN: 682697762
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@worldnet.att.net
X-Trace: bgtnsc04-news.ops.worldnet.att.net 971834477 12.78.99.214 (Wed, 18 Oct 2000 02:01:17 GMT)
Organization: AT&T Worldnet
X-MSMail-Priority: Normal
NNTP-Posting-Date: Wed, 18 Oct 2000 02:01:17 GMT
Newsgroups: bit.databases.mssql-l