Well I believe I'll need to update mysql since I just realized this
server is using 3.23. Gotta love taking something over from someone and
finding out they weren't very good at the job to begin with.
Karl Larsen wrote:
Hi Remo, your method works fine on version 4.1 and the one shown
for ve
Hi Remo, your method works fine on version 4.1 and the one shown for
version 5 does not work here. Nice to know there is a SQL word
AUTO_INCREMENT to do the job.
Karl
Remo Tex wrote:
If you are using autoincrement filed you could try this:
ALTER TABLE `my_database`.`my_table` AUTO_I
If you are using autoincrement filed you could try this:
ALTER TABLE `my_database`.`my_table` AUTO_INCREMENT = 201;
...or else if it is some stored proc you should find and edit table
where it sotres index/counter data..
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I h
Under mysql 5.0.18 you can do something like:
// get the current value of the auto_increment counter
mysql> select @@auto_increment_offset;
+-+
| @@auto_increment_offset |
+-+
|1105 |
+-+
1 row in set (0.00
Hi Tom
CREATE TEMPORARY TABLE tt SELECT * FROM your_table;
TRUNCATE your_table;
UPDATE tt SET your_index = NULL;
INSERT INTO your_table SELECT * FROM tt;
suomi
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I hope)..I have a database that
has a field in it that autoindexes the
