Mysql Problem with id
Posted: Tue Jul 24, 2007 3:58 am
a strange problem faced me with my database
when i insert a data into a table suppose a, b, c, d
i expect that they are inserted in rows like this
id value
1 a
2 b
3 c
4 d
but what happens something else like this
id value
4 d
3 c
2 b
1 a
and sometimes like this
id value
1 a
3 c
2 b
4 d
but when i converted the table from MyIsam to InnoDB i think this problem has finished . What happens ?!
when i insert a data into a table suppose a, b, c, d
i expect that they are inserted in rows like this
id value
1 a
2 b
3 c
4 d
but what happens something else like this
id value
4 d
3 c
2 b
1 a
and sometimes like this
id value
1 a
3 c
2 b
4 d
but when i converted the table from MyIsam to InnoDB i think this problem has finished . What happens ?!