>Description:
a simple select on a large table does not use an indexed column when the WHERE
clause uses a != b
The same query using as WHERE a < b OR a > b (which of course does the same)
*does* use an index.
>How-To-Repeat:
mysql < 1; *** actually
same query, index on numbe
>Description:
the character '-' in username or hostname is not accepted by the GRANT sql
statement.
>How-To-Repeat:
grant all on *.* to [EMAIL PROTECTED];
>Fix:
don't use dashes, fixing the SQL parser.
>Submitter-Id:
>Originator:Bas
>Description:
a mysql -p db < file.sql fails when sql contains TEXT fields that are long
>How-To-Repeat:
create table with text column,fill it with text,
mysqldump this table into file.sql
mysql -p db < file.sql
>Fix:
linewrapping the mysqldump file is a workaroun
reason to "to many connections"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi,
why its mysql database over random record use?
hi,
why its mysql database over random record use?
excuse me
have can I get from mysql database random 6 data item?
l me how I can solve this and/or where I can find
documentation on MySQLGui
Kind regards,
Bas Mooyman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
Hi all,
I am trying to couple Openoffice.org to MySQL using ODBC. Does anybody
have an odbc driver functioning on a mandrake 8.2 linux machine? If so
please tell me how to do it.
Kind regards,
Bas Mooyman.
-
Before
AND ICA_1_SplitInter.I1_Proc_Dt is null;
This is wierd since it not such a complex SQL after all...
>How-To-Repeat:
Resumbit the SQL above
>Fix:
Not found a workaround yet...
>Submitter-Id: Bas van Ritbergen
>Originator:Super-User
>Organization: O2 the Netherlands
work and will 4.0.17 be able to
read the 4.0.20 generated data files without problems?
I'd love to upgrade the 4.0.17 server but it's running another database
that really can't go offline.
Thanks in advance,
Bas.
--
MySQL General Mailing List
For list archives: http://list
except there's no need to stripslashes(), in fact it could even break things..
unless you have magic_quotes_runtime enabled (default is off in the latest php)
bvr.
On Mon, 17 Dec 2001 16:33:24 -0700, Kevin Stone wrote:
>Ahh.. I was about to reply but nevermind. The two functions you're talk
12 matches
Mail list logo
