Hi there,
I am having a problem with MySQL 5.0.45 returning what I consider to be
unexpected results.
Basically I am attempting the following query, and ALL records are being
returned.
" SELECT * FROM `jos_products_orders` WHERE NOT `method` "
I have pasted table structure, and some sample da
Dominic Baines wrote:
> After a pretty long time I have returned to being a mysql DBA again after
> spending a lot of time with Oracle and MSSQL.
>
> I have several databases that I need to to work on, all various source builds
> from 4.1.16 to 4.0.20 and the average database contains some 200 o
glenn
Union is 4.0 feature.
david
>Notwithstanding end-of-life status, is there an issue in MySQL
>v3.23 r.e. the "union" operator?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 11:11 AM 1/14/2008, Saravanan wrote:
Hi,
Server parses the statement only once and executes them with the small
difference. It reduces parsing time. Clients don't need to send the full
statement again and again. It reduces traffic.
Saravanan
Saravanan,
Thanks for your qui
Are you using the PREPARE STATEMENT server-side syntax or an emulated
prepared statement like in PDO?
-jay
mos wrote:
I would like to speed up my Select queries since I'm executing approx
5,000 of them, same syntax but the search values for 2 columns will
change with each query. Will I see an
Hi,
Server parses the statement only once and executes them with the small
difference. It reduces parsing time. Clients don't need to send the full
statement again and again. It reduces traffic.
Saravanan
--- On Mon, 1/14/08, mos <[EMAIL PROTECTED]> wrote:
> From: mos <[EMAIL PROTECTED]>
> S
OldManRiver wrote:
Hope all this helps. I'm looking into "how to post a bug" for MySQL as I
think that is my next step.
Have you tried http://bugs.mysql.com/ ? ;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
Hi,
What kind of storage engine you are using? Did u try to remove the database
directory from the file system? Could you paste the output you get when you are
trying to drop tables and database.
Check in the database directory for .frm file. If you found them without data
and index files. Try
All,
It was suggested by contributors to other brds, that I try to fix my problem
with the customary "MySQL" Toolset. I downloaded and implemented the
toolset, but still had same results.
Also posted this at:
http://forums.mysql.com/read.php?34,191303,191723#msg-191723
http://forums.devshed.co
I would like to speed up my Select queries since I'm executing approx 5,000
of them, same syntax but the search values for 2 columns will change with
each query. Will I see any performance increase if I prepare the statement
and use parameters? (I don't need to use the query cache since the resu
Hi Dom,
On Jan 14, 2008 10:49 AM, Dominic Baines <[EMAIL PROTECTED]> wrote:
> After a pretty long time I have returned to being a mysql DBA again after
> spending a lot of time with Oracle and MSSQL.
>
> I have several databases that I need to to work on, all various source builds
> from 4.1.16
The CSV engine requires that every field be surrounded by double quotes.
If your text has double quotes, escape them or change them.
If you don't have that kind of time...
You may want to do this the weird way using Microsoft Access.
1. Install MyODBC (Takes like 30 seconds or less)
2.
Hi Hiep,
Here's what I do when I need to do that. First save it as a .csv file
and then follow this:
load data infile '/path/to/file' into table MyTable fields terminated
by '\t' lines terminated by 'w'
that has always worked for me.
Hope it helps!
On Jan 14, 2008, at 10:51 AM, Hiep Ng
After a pretty long time I have returned to being a mysql DBA again after
spending a lot of time with Oracle and MSSQL.
I have several databases that I need to to work on, all various source builds
from 4.1.16 to 4.0.20 and the average database contains some 200 or more
tables. Some are cluster
hi everyone,
i have a large ms excel data (text) file that i need to import to my table
in mysql. does any one have a suggestion how to do this? i'm try to
export to csv file, then import to my table, but i have so much problems
with delimeters
thanks
--
MySQL General Mailing List
For li
Or maybe the pid is still existing?
-Original Message-
From: Ross Crawford [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 12, 2008 5:13 PM
To: mysql@lists.mysql.com
Subject: Unable to restart after crash
Hi,
My mysql server crashed last night, and when it rebooted, was unable to
res
Just four days ago I released the winter issue of MySQL Magazine
(http://www.mysqlzine.net). However, I wanted to go ahead and get the
jump on the spring issue as this quarter will be quite busy. Many of us
are either speaking at the MySQL User's Conference or attending it in
April. The spri
Hi Iago, all,
[EMAIL PROTECTED] wrote:
Hi, Joerg.
Thanks for the response.
In ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-4.0/ and other
similars that I find looking for "mysql/Downloads/MySQL-4.0" in google there
is only MySQL 4.0.26 and 4.0.27.
both the 4.0 and 4.1 MySQL rele
Moon's Father schrieb:
On Jan 14, 2008 7:00 AM, Daevid Vincent <[EMAIL PROTECTED]> wrote:
I saw this on the PHP list and was wondering if there is any merit to it?!
I would be surprised if disabling networking made a difference. I'm only
concerned about the added speed. I get the security bene
19 matches
Mail list logo
