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
>
>