List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 12 1999 8:55am
Subject:mysql reversing data
View as plain text  
>>>>> "kenford" == kenford  <kenford@stripped> writes:

kenford> Does anyone know why mysql reversing the data?

kenford> loop{
kenford> mysql("wwwsearch", "insert into title values('$url_id','$wordsT_SQ')");
kenford> }


kenford> Data to mysql
kenford> ---------------
kenford> url_id|wordsT_SQ
kenford> 1        2
kenford> 2        4
kenford> 3        22
kenford> 4        23



kenford> The result is being reversed.

mysql> select * from title;

kenford> Data from mysql
kenford> ---------------
kenford> url_id|wordsT_SQ
kenford> 1        23
kenford> 2        33
kenford> 3        4
kenford> 4        2




kenford> CREATE TABLE title (
kenford> url_id			int(9) default '0' not null,       # 1,2,3,4,....
kenford> site_title		int(7) default '0' not null,       # 1,23,4,66,....			
kenford> index			title_index(site_title)
kenford> );


Hi!

The above shouldn't happen.

Please start with mysqld --log, rerun your test and send us the
part of the log file that shows your queries!

Regards,
Monty
Thread
mysql reversing datakenford12 Jun
  • mysql reversing dataMichael Widenius12 Jun