hi.
yes it is possible.
1. Create an new column which has an auto_increment option
2. Insert the first dataset manually as followed:
" INSERT INTO test (auto, char) VALUES ('100', 'Hello World!') "
3. From there on your auto column will count starting from 100, 101, 102,
...
Greeting
- Daniel Backhausen
---
N2MEDIA web- & multimediadesign
http://www.N2media.de - mailto:[EMAIL PROTECTED]
-----Ursprüngliche Nachricht-----
Von:
Gesendet: Montag, 7. Januar 2002 13:25
Betreff: auto_increment
Return-path: <[EMAIL PROTECTED]>
Envelope-to: [EMAIL PROTECTED]
Delivery-date: Mon, 07 Jan 2002 13:24:17 +0100
Received: from [192.58.197.162] (helo=web.mysql.com)
by mxng03.kundenserver.de with smtp (Exim 3.22 #2)
id 16NYp5-0002jj-00
for [EMAIL PROTECTED]; Mon, 07 Jan 2002 13:24:15 +0100
Received: (qmail 2142 invoked by uid 7797); 7 Jan 2002 12:17:41 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe:
<mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 2128 invoked from network); 7 Jan 2002 12:17:40 -0000
Message-ID: <00f101c19776$4ca52130$0e64a8c0@mmehta>
From: "Manish Mehta" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Subject: auto_increment
Date: Mon, 7 Jan 2002 17:54:48 +0530
MIME-Version: 1.0
Content-Type: text/plain;
charset="x-user-defined"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-MDRemoteIP: 192.168.100.14
X-Return-Path: [EMAIL PROTECTED]
X-MDaemon-Deliver-To: [EMAIL PROTECTED]
Hi
Is it possible auto_increment start 100 instead of 1 .
for example
create table a
( a int(10) primary key auto_increment 100);
Manish Mehta
E-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
