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 - truncates some working tables [WORKS
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
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
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
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),