I believe the following will work:
date_add([thedatefield],Interval 15 days)
I am almost sure I got the syntax right off the top of my head. Check mysql.com for
date functions if the above doesn't work.
Serge.
On Wed, 26 Mar 2003 10:16:18 -0500
Tom Ray [EMAIL PROTECTED] wrote:
I have a
The DISTINCT is almost usless when done on a GROUP BY clause. Also DISTINCT operates
on the entire row and not just on the field.
ie It will give you DISTINCT measurement, sum(val), pcfver, hour, release. And not
just DISTINCT measurement results.
Serge.
On Wed, 26 Mar 2003 12:00:24 -0600
Do a print $testField; first. I think what might be happing is that you have register
globals turned off (as you should it's a security problem).
Try:
$sql = INSERT INTO testTable values ('', '${_REQUEST['testField']}');
and see if that solves your problem.
Serge.
On Wed, 26 Mar 2003
],Interval 15 day)
Mark
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: DATE function question
I believe the following will work:
date_add([thedatefield],Interval 15 days)
I am almost
Hello,
A few months ago I asked to have the ability to turn off autocommit at a
server level. I was told by a mySQL rep that this would not be added to the
3.23 tree but would be added to the 4 tree.
Well since 4 has been declared stable I have upgraded. Now I am trying
to find out
Hello All,
I'm just plugging away at a converion project where we are migrating to mySQL.
I am getting increasingly down on the poor support for importing dates into mySQL.
In the near future could we expect a function that is basicaly the opposite to
date_format where the first
blaming mySQL with the problem. It's a feature that
both Oracle and MS SQL have the ability to do but mySQL cannot. It's a
feature deficency that makes life harder to deal with Dates and mySQL if
you don't want to use ISO.
Serge.
On 15 Oct 2002, at 12:10, Serge Paquin wrote:
I'm just
Hello,
I am having troubles with Load Data Infile and cannot figure out the problem.
I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So
when I import I only get '-00-00' rather than the date. How can I tell MySQL what
the format is?
I
This is the only option? That's not a very automated process and I must import this
data once a day. I also will not be able to get them to reformate their data since
I'm only one of many many people downloading everyday. Is their no way for load data
to do this automaticaly?
Serge.
On
I think this is a touch on the negative side. I'm sure many people get soured on
MySQL when they to a post here and get yelled at for not trying hard enough. It
sounds like Mary is having a valid problem. Her query works fast in one database and
slow in the other. Because she did not come
Hello,
I am trying to setup replication to be used basicaly as a hot backup.
My production database uses INNODB tables. I would like my Replication
database to just my MyISAM since I do not need transactions on that one.
Just a copy of the data. I followed the process to create the slave
Hello,
I'm not sure I am still using 3.23.
Serge.
- Original Message -
From: Eric Frazier [EMAIL PROTECTED]
To: Serge Paquin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 10:05 PM
Subject: Re: Replication with INNODB
Hi,
I am confused. I just tried
- Original Message -
From: [EMAIL PROTECTED]
To: Serge Paquin [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 3:41 AM
Subject: Re: replication
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
I store images in the database for a few reasons. I do make sure they are
in their own table though and link to another table via a key so I would
have tbllisting with all the textual data information on a listing and then
tbllisting_image which is just the primary key linking to tbllisting and
I use blob columns. One thing I do though is store them in there own table
and not in a table with other data. I just link through primary key.
That way when you are not looking for an image the database does not have to
deal with it. Also it's easier for disaster recovery since you do not
This is more of a php question. explode $string on (space) which will
give you an array. Loop through the array first with $sql.=WHERE
whatevercolumn LIKE '%$val%' then for every other entry change WHERE to
AND.
Serge.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To:
SELECT * FROM tbl WHERE this=that limit 1,10;
SELECT * FROM tbl WHERE this=that limit 11,10;
SELECT * FROM tbl WHERE this=that limit 21,10;
SELECT * FROM tbl WHERE this=that limit 31,10;
etc etc etc...
syntax: limit [start row],[# of rows to return]
To get a total first do a COUNT(*) on the
It looks like your field is a text field rather than BIGINT or some
numerical field. Changing the field type should solve your problem.
Serge.
- Original Message -
From: CVIOG at UGA [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 4:22 PM
Subject: Basic Q's:
Because the PHP interface is based on the C interface. It hit's the C
interface at some point since PHP is itself written in C.
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 7:44 PM
Subject: Commands out of sync; you
as it is now. I have
looked high and low but I can only find reference to the default setting of
mysql autocommit being 1 and no reference on how to change that default.
Thanks,
Serge.
- Original Message -
From: Oliver Vecernik [EMAIL PROTECTED]
To: Serge Paquin [EMAIL PROTECTED]
Cc: [EMAIL
20 matches
Mail list logo
