I no longer have the original post in my inbox, I had a problem with
fetchmail which downloaded all the messages a couple hundred times, so i
did a mass delete.
All you should have to do is wrap the statement in () like:
UPDATE table name SET field=(field+1) WHERE where clause
This will
I want to create a cron job that does nightly backups of a database, tars
and gzips it, then ftps it to another server.
I was wondering what the perferred method of copying the data would be.
mysqldump, mysqlhotcopy or just copying the files.
=S.
Aravind,
MySQL stores all dates as -MM-DD, if you must use MM/DD/ then you
can store it as a string.
The best method would be to let MySQL store the date as -MM-DD and
use:
select date_format(mydate, '%m/%d/%Y');
That will return mydate as MM/DD/.
=S.
On Tue, 26 Feb 2002,
It would help to see either the PHP code or the SQL statement.
=S.
On Tue, 26 Feb 2002, Edward Ionescu wrote:
Hello,
I'm using MySQL 3.23.32 and PHP. When an URL is etieved from the database,
two things can happen:
1. it's working
2. it's not working and in look like:
