Hi all,
I am trying to optimize my database tables at midnight, using winnt, delphi,
and libmysql.dll. I want to execute a sequence like:
mysql_select_db(sql, some_database);
mysql_query(sql, 'OPTIMIZE TABLE MyTable');
mysql_select_db(sql, another_database);// error
mysql_query(sql,
hi,
MATCH is a reserved word. Try to rename your table.
HTH.
Anton Tichawa.
> -Original Message-
> From: Chris Aitken [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 1:09 PM
> To: [EMAIL PROTECTED]
> Subject: Weird Error Inserting
>
>
>
hi,
try your first SELECT statement, but with
ORDER BY table1.table1_row
maybe this helps (I didnt try it).
Anton Tichawa
> -Original Message-
> From: Bruno Faé [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 5:44 PM
> To: [EMAIL PROTECTED]
> Subject: Query Error
>
>
Hi Riccardi,
>
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
> Hi, Moreno
>
try
DECIMAL(15,9)
because I think the first argument specifies the total number of digits.
hello list,
Michael Thygs is right, but the expression can be simplified. We have to
assume that all dates are in correct order, i. e. for each date pair the
following relation is true:
from date <= to date
When a date range from tab1 does NOT overlap a date range from tab2, then
the tab1 ran
Hi,
I have problems with full-text search. My table contains text lines from
computer-generated log files rather than documents written by humans, and so
my first problem is that I need an exact match rather than a relevance
value, i. e. if the search string is 'ai', I really need all rows conta
