select CURTIME - field of type TIME returns NULL sometimes

2002-10-15 Thread Joao A. Marques
Hi, I´m getting problem with function CURTIME(). The problem happens, apparently, when then current seconds of the current time (server´s time) is between 43 and 59, as result of CURTIME - field of type TIME. See : [root@test01 /root]# mysql Welcome to the MySQL monitor. Commands end with ; or

Index X No Index

2002-05-17 Thread Joao A. Marques
Hi, Let´s supose that we have a table with this features : - about 7 records; - only a primary index; - about 30 fields; - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS typically uses about 3 or 4 fields in the WHERE clause. Creating indexes, one for each field used on SELECTS,

Index X No Index

2002-05-16 Thread Joao A. Marques
Hi, Let´s supose that we have a table with this features : - about 7 records; - only a primary index; - about 30 fields; - 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS typically uses about 3 or 4 fields in the WHERE clause. Creating indexes, one for each field used on SELECTS,

Re: Lock databases

2002-04-19 Thread Joao A. Marques
Is it ok for version 3.22.32 ? João Alexander Marques [EMAIL PROTECTED] Uranet Projetos Sistemas Ltda. Tel. : 55 11 3242-1353 - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Kory Wheatley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 5:22 PM