Bugreport: Incorrect rows affected number!
Below sequence shows that MySQL returned 0 rows affected after it deleted 2 records. Regards, Gunter Environment: W2K, mysql. 3.23.41-max-nt mysql select * from mmecounter; +--++-+--+-+ --++-+--++++ | ID | Modified | Machine_ref | Category | Name| ValueNum | ValueFloat | ValueString | DataType | Spare1 | Spare2 | Spare3 | +--++-+--+-+ --++-+--++++ | -4636453695223307315 | 20011027125508 | 2 | TESTCategory | TestKey | 0 | 0 | TestText|1 | NULL | NULL | NULL | | -4636453695223154567 | 20011027125508 | 2 | TESTCategory | TestKey | 0 | 0 | TestText|1 | NULL | NULL | NULL | +--++-+--+-+ --++-+--++++ 2 rows in set (0.00 sec) mysql delete from mmecounter; Query OK, 0 rows affected (0.00 sec) mysql delete from mmecounter where ValueNum=0; Query OK, 0 rows affected (0.00 sec) mysql select * from mmecounter; Empty set (0.00 sec) Gunter Leeb Director of Development MachineGeneration Inc. [EMAIL PROTECTED] Direct: (512) 266 2139 Main: (512) 266 9580 - 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
Reverse string matching
Hi, Consider Name LIKE 'ABC%' finds all names that start with ABC. I am looking for the reverse: I have a string and I am looking for all the records that have a name which is the BEGINNING of this string. As an example: I have'ABCDE' and I want rows contains 'ABCD' or 'ABC' or just 'A' found. Is there a way to do this with SQL and MySQL in particular (and not send a query for each substring)? Your help is appreciated, Thanks, Gunter Leeb Director of Development MachineGeneration Inc. [EMAIL PROTECTED] Direct: (512) 266 2139 Main: (512) 266 9580 - 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
Critical TIMESTAMP issue?
Hi everyone, TIMESTAMP types are supposed to contain millis and even nonos. How can I ensure these are set, retrieved and used for ORDER BY and comparisons in MySQL? I cannot find a way to get even millis back. Also MySQL does not seem to order by this information. See below example. Is this a bug? Is there a work around? My application requires to catch inter-second events and to maintain their order. Also what is the SQL standard way to manipulate below sec columns. Your help is very appreciated. Please reply to me directly (as well). Gunter Leeb Output: mysql insert MMEReason(ID, Modified, Event_ref) values(-1, '2001-09-26 16:08:09.01299', -1); Query OK, 1 row affected (0.00 sec) mysql insert MMEReason(ID, Modified, Event_ref) values(-2, '2001-09-26 16:08:09.01399', -1); Query OK, 1 row affected (0.00 sec) mysql insert MMEReason(ID, Modified, Event_ref) values(-3, '2001-09-26 16:08:09.01199', -1); Query OK, 1 row affected (0.00 sec) mysql select ID, Modified from MMEReason order by modified; +++ | ID | Modified | +++ | -3 | 20010926160809 | | -2 | 20010926160809 | | -1 | 20010926160809 | +++ 3 rows in set (0.00 sec) Environment: Mysql: V. 3.23.41-max-nt JDBC MM-mysql. V.2.0.6 recent Microsoft JVM Win2K Gunter Leeb Director of Development MachineGeneration Inc. [EMAIL PROTECTED] Direct: (512) 266 2139 Main: (512) 266 9580 - 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
tee crashes the mysql client
Hi, A minor bug report: mysql tee c:\dev\sqlout.txt mysql: Can't create/write to file 'c:\dev\sqlout.txt' (Errcode: 2) Logging to file 'c:\dev\sqlout.txt' If the file is locked for whatever reason, it crashes with: The instruction at 0x77f821e1 referenced memory at 0x34. The memory could not be read. Environment: Mysql: V. 3.23.41-max-nt JDBC MM-mysql. V.2.0.6 recent Microsoft JVM Win2K Gunter Leeb Director of Development MachineGeneration Inc. [EMAIL PROTECTED] Direct: (512) 266 2139 Main: (512) 266 9580 - 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