An Oracle DB programmer reviewed a query that I wrote and told me that
putting constants at the beginning of the query would make it slower. I
thought I'd go to the experts on MySQL and be told the truth one way of
the other.
Example query:
SELECT
TABLE1.COL,
TABLE2.COL
FROM
OS: Compaq Tru 64 4.0F
Compiler: GNU GCC 3.0.4 - libstdc++.3.0.4
MySQL 3.23.49
MySQL Protocol 10 - libmysqlclient.so.10.0.0
After upgrading apache/php with the new 3.23.49 libs all of my previously
working 'C' mysql applications have died. This is okay on one hand cause I
am moving them to 'php'
> set SQL_BIG_TABLES = 1;
You also will have to keep in mind that now that a filesystem is being
used for the MySQL work you'll need the room to do it. In some cases the
default MySQL install uses '/var/tmp' for it's chalkboard which in some OS
installations, referring to UNIX of course
Our programming crew does not give us (Web Services) access to Oracle. We
of course don't care kuz' mySQL suits us fine. But now we have run into a
pickle. They are handing us text cdf files for import. One of the fields
they are giving us is in the following condition:
02-SEP-02
We need to do
Thanks... That's exactly what I was looking for. Simple and elegant.
Rob.
On Tue, 18 Dec 2001, Roger Baklund wrote:
> Asuming all dates are 20xx:
>
> mysql> select
> @d:='01-DEC-18',@d2:=concat('20',mid(@d,1,2),'-',field(mid(@d,4,3),
> 'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OC
Hello all,
MySQL 3.23.51
Apache 1.3.26
In my php connection to MySQL I send a message if there is a problem.
Today for the first time in 3 years of MySQL/Apache use I received the
following error message:
[26-Sep-2002 15:49:14] ERROR: Couldn't connect to the DB while drawing the
main page qui
Hello all,
I have a cron job that:
1 - truncates some working tables [WORKS | BOTH]
2 - does a mysqlimport on some CDF files [WORKS | MASTER_ONLY]
3 - truncates a selection of production tables [WORKS | BOTH]
4 - select from working into production tables [WORKS | BOTH]
Step 4 doesn't work on
Sorry to have bothered the list, for anyone's info...
You have to have the CDF files on `all' servers, not just the MASTER in
order for the mysqlimport to work.
Robert B.
On Tue, 29 Oct 2002, zxcv wrote:
>
> Hello all,
>
> I have a cron job that:
>
> 1 - t
