Bugreport: Incorrect rows affected number!

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

Reverse string matching

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

tee crashes the mysql client

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

Critical TIMESTAMP issue?

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