Hi,
Le 08/08/2014 17:48, Johan De Meersman a écrit :
>
> As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr
> plus the rightmost key (right next to return) on the middle row. Enjoy
> spraining your fingers :-p
>
> /johan
>
Alt-GR plus '7' for French keyboard layout
- Original Message -
> From: "florent larose"
> Subject: sql syntax error
>
> near ''membres2' WHERE
> [...]
> FROM 'espace_membre2'.'membres2' WHERE
You were on the right path - mysql is wibbly about quotes. Either remove the
quotes entirely ( espace_membre2.membres2 ) or try backtick
I think datediff only takes two arguments and you have three listed.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Chris Kavanagh
Sent: Monday, January 31, 2005 5:33 PM
To: mysql@lists.mysql.com
Subject: Re: SQL syntax error: help a noob
Thanks very much for the replies, guys. My version is "4.1.7-max".
The error message I get is:
--
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use nea
[snip]
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone very
kindly gave me and I only have a vague idea of what the first line's doing!
Can anyone see the problem here?
SELECT DATEDIFF(leadtime_type, GET
Chris Kavanagh wrote:
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT DATEDIFF
On Sat, Nov 13, 2004 at 12:46:12PM -0800, Stuart Felenstein wrote:
>
> --- Jim Winstead <[EMAIL PROTECTED]> wrote:
>
> > You can't compare a column with a comma-delimited
> > list of numbers like
> > that...
>
> What should the seperator be then ?
My point was that you can't compare a colum
--- Jim Winstead <[EMAIL PROTECTED]> wrote:
> You can't compare a column with a comma-delimited
> list of numbers like
> that...
What should the seperator be then ?
Thank you
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
On Sat, Nov 13, 2004 at 12:30:43PM -0800, Stuart Felenstein wrote:
> $sql = "SELECT PostStart, JobTitle, Industry,
> LocationState, VendorID
> FROM VendorJobs";
> echo $sql;
> //if ($Ind)
> $sql .= "WHERE VendorJobs.Industry = $s_Ind";
>
> As you can see above s_ind is an array , comma
> d
Hi Asif,
Asif Iqbal wrote:
I have been pushing my syslogs to the following mysql table
However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax
You need to escape those reserved characters, i.e. have ' replaced by \'
because otherwise mysql will treat the apostrophe as
In the last episode (Nov 30), Steve Osborne said:
> I created the file with ver 3.23.43, tried to recreate database on
> 3.22.32. I administer 2 other databases the same commands and they
> work fine. I looked at the difference in the sql files, and those
> ones don't contain the PACK_KEYS statem
?
Steve
[EMAIL PROTECTED]
- Original Message -
From: "Steve Werby" <[EMAIL PROTECTED]>
To: "Steve Osborne" <[EMAIL PROTECTED]>; "MySQL (E-mail)"
<[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 2:58 PM
Subject: Re: SQL syntax error
> "
"Steve Osborne" <[EMAIL PROTECTED]> wrote:
> I am receiving the following error when I try to restore a database backup
> from an .sql file:
> ERROR 1064 at line 12: You have an error in your SQL syntax near
> 'PACK_KEYS=1' at line 11
> ) TYPE=ISAM PACK_KEYS=1;
>
> Cmd used to create sql:
> mysq
13 matches
Mail list logo
