"select CURTIME - " 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 - ". See : [root@test01 /root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL co

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, wil

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, wil

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