Bugreport: Incorrect rows affected number!

2001-10-27 Thread Gunter Leeb
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

Reverse string matching

2001-09-30 Thread Gunter Leeb
'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

Critical TIMESTAMP issue?

2001-09-26 Thread Gunter Leeb
. 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

tee crashes the mysql client

2001-09-26 Thread Gunter Leeb
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