I have one table on my computer and one remote to my host on Internet.
I have this problem:
I use =>
ALTER TABLE hotels1 DROP ID;
ALTER TABLE hotels1
AUTO_INCREMENT=1,
ADD ID int unsigned not null auto_increment default '0' first,
ADD primary key (ID);
to refresh the ID starting from 1.
BUT: In my remote table, the records are displayed with ID *AND* Name in
accending order wich doesn't happent to my local table:
ID NAME
1 ACH
2 ADA
3 ARIS
ecc. (in remote table)
ID NAME
1 XEN
2 VER
3 TOUR
ecc (in local table)
So how is possible to change the local table - I suppose this is only
possible- to set the IDs identicals to Local+remote tables?
I need this to pass the UPDATEs I make to local table by coping the query to
remote table.
PS. I deleted all recs on remote table, I export the data from my local and
re-create the data to remote and I run the above query , still the same. I
think something is different on Internet server's MySQL config.
Thanks
Makis
---------------------------------------------------------------------
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
