;s how it's listed in the manual.
>
> date_add([thedatefield],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 questio
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 14:28
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 (
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 hav
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 wher
:[EMAIL PROTECTED]]
>
> Perl has functions to do this.
> If you are writing an import, use language native functions.
> For a "load data in file", just how would you expect this to work?
>
> Serge Paquin wrote:
>
>>Hello All,
>>
>> I'
I am 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 Paqui
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 para
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 Tue
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 ha
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 o
- 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. T
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: Replicatio
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 b
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 a
I am just in the process of migrating a few sites from Oracle to MySQL. I
had access to both servers and wrote a little PHP program that queried one
and wrote to the other. I think that will be your best bet. Install a
temporary Oracle server import the DMP file. I used a utility called TORA
t
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 hav
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 fir
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]>
T
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: N
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;
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&qu
Hello,
I am setting up mysqld-max with InnoDB Tables. How can I set autocommit to
off? I want this a global option for the DBMS.
Thanks,
Serge.
-
Before posting, please check:
http://www.mysql.com/manual.php (th
23 matches
Mail list logo