From: Charles Kirby
Date: March 31 1999 3:33pm
Subject: Re: Start Slips with "50000"?
List-Archive: http://lists.mysql.com/mysql/1241
Message-Id: <Pine.BSI.3.95.990331102627.8076A-100000@shell.monmouth.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

No explanation for this... however, it worked for me once I implemented an
idea from Jim Faucette.
Later on, I realized that the only reason it hadn't worked for me was that
the thing in brackets here... <'50000'> is a string, whereas <50000> is an
integer!  (Although I can't explain why this doesn't jibe with your
information below).

When I made the update using sid=50000 instead of sid='50000' it worked.

Thanks, ck

On Wed, 31 Mar 1999, Christian Mack wrote:

> Charles Kirby wrote:
> > 
> > Hi folks... maybe someone can help with this one.
> > 
> > I want to start my Slip numbering with 50,000 instead of 1, and I thought
> > I was being smart by just doing UPDATE slips SET sid='50000' where
> > sid='1', but this doesn't work!  sid is INT(11); I tried sid='500' but
> > this was no good either (in either case, browsing gives "no tickets
> > defined."
> > 
> > Any ideas anyone?
> > 
> > Thanks!
> > ck
> 
> Hi Charles
> 
> Sorry, but I couldn't reproduce your problem.
> This obviously works for me:
> mysql> CREATE TABLE slips (sid INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY);
> Query OK, 0 rows affected (0.22 sec)
> 
> mysql> INSERT INTO slips VALUES(1);
> Query OK, 1 row affected (0.01 sec)
> 
> mysql> UPDATE slips SET sid='50000' WHERE sid='1';
> Query OK, 1 row affected (0.01 sec)
> Rows matched: 1  Changed: 1  Warnings: 0
> 
> mysql> INSERT INTO slips VALUES (NULL);
> Query OK, 1 row affected (0.01 sec)
> 
> mysql> SELECT * FROM slips;
> +-------+
> | sid   |
> +-------+
> | 50000 |
> | 50001 |
> +-------+
> 2 rows in set (0.03 sec)
> 
> Tschau
> Christian
> 
>