2006-04-22 (토), 00:49 +0100, Philippe Poelvoorde 쓰시길: > Hi, > > > mysql> select * from user_todo_german_english where wordid = '86851' and > > posn = '1' and pos = 'm' AND mb_id='curious'; > > +---------+--------+------+------+---------------------+ > > | mb_id | wordid | posn | pos | date_col | > > +---------+--------+------+------+---------------------+ > > | curious | 86851 | 1 | 0 | 2006-04-22 08:14:12 | > > +---------+--------+------+------+---------------------+ > > 1 row in set, 1 warning (0.00 sec) > > > > mysql> select * from user_todo_german_english where wordid = '86851' and > > posn = '1' and pos = 'm' AND mb_id='curious'; > > +---------+--------+------+------+---------------------+ > > | mb_id | wordid | posn | pos | date_col | > > +---------+--------+------+------+---------------------+ > > | curious | 86851 | 1 | 0 | 2006-04-22 08:14:12 | > > +---------+--------+------+------+---------------------+ > > 1 row in set, 1 warning (0.00 sec) > > there are clear warnings, what are they ? > mysql> show warnings; +---------+------+---------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------+ | Warning | 1292 | Truncated incorrect DOUBLE value: 'm' | +---------+------+---------------------------------------+ 1 row in set (0.00 sec)
mysql> -- my site <a href="http://www.myowndictionary.com">myowndictionary</a> was made to help students of many languages learn them faster. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]