about sequence of rows
Posted: Fri Jul 09, 2004 12:40 am
I have table which has two columns
city_id distance
now i want data to be stored in sequence as i entered it and retrieve it in the same sequence. neither city_id is order nor distance. I have inserted data many times in sequence but when i view the contents of table es the order of rows is changed. anybody can tell me why.
Secondly as i told before both of my columns are unordered so how can i implement indexes on it.previusly i had a third column in it with the name seq_id which was in ordered form but now i m not allowed to use that so i need some other way to do that may be through indexing. how can i do that.[/mysql_man]
city_id distance
now i want data to be stored in sequence as i entered it and retrieve it in the same sequence. neither city_id is order nor distance. I have inserted data many times in sequence but when i view the contents of table es the order of rows is changed. anybody can tell me why.
Secondly as i told before both of my columns are unordered so how can i implement indexes on it.previusly i had a third column in it with the name seq_id which was in ordered form but now i m not allowed to use that so i need some other way to do that may be through indexing. how can i do that.[/mysql_man]