HI
You may get other replies to the contrary, but in my knowledge, no you
cannot do what you asking. However, I can suggest that you create the table
in MYSQL with the auto-number column, then in access delete the auto number
column so that when you import into MYSQL no value is passed for that field
number, then MYSQL will do it automatically and it will be sequential. That
is what I did and it looked well. THe only difference is I imported it into
MYSQL, then delete the column, did a mysqldump -n -t -c (so that it gave me
complete insert strings, specying the column names (else it would complain
the two tables don't agree)) and then I recreated the table with a
auto-number column and imported my dump file.
Regards
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Rory O'Connor
> Sent: 18 July 2001 07:56
> To: [EMAIL PROTECTED]
> Subject: re-indexing records
>
>
> I'm a bit of a mysql newbie...excuse if this is rudimentary.
>
> I imported about 5000 records and realized that the index is
> a bit scewy
> since i deleted alot of records while it was in access.
> rather than fix
> it in access and re-import it, is there an easy way to re-index the
> records in mysql?
>
> thanks!
>
> providing the finest in midget technology
>
> ---------------------------------------------------------------------
> 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
