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
hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my
system : windows 7 / wampserver 2).
i have a bug when i am running my connection to database webpage.
My error message is the following :
Erreur SQL : You have an error in your SQL syntax; check the manual that
correspon
Always echo out your SQL string, it will make it a lot more obvious.
You want to see the result. I php concatenated string can be
confusing at times.
Also, you are not escaping your data, so if you had a word of 'stops,
here' that would break it as well.
So in your case, you very well m
Thanks, Scott.
I thought I couldn't have missed ','(comma) before. But today somehow it
works... ;;
I wasted hours figuring this out, but you saved me!
Maybe I'm still a complete newbie!
Thanks, again. Have a great day. :)
On Thu, Apr 30, 2009 at 12:52 PM, Scott Haneda wrote:
>
> On Apr 29,
On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote:
This is MySQL data structure. - I underlined where it causes the error
message. (datetime)
`id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
`Revenue` mediumint(6) NO
Thanks. NOW() and php date(); work for my newly created test tables, but it
doesn't work for my working table. I can't insert date, time or now()
into my old table (which is as below).
For now, I'm using MySQL auto timestamp ('Updated' field), but I need to
insert date when the data was created!
We need to see your entire query and the table structure. timestamp
fields can have options set to auto update them, where order matters,
and only one field can support that feature.
Please supply more data.
On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote:
You have an error in your SQL synt
Can you please give the full table structure and query?
On Tue, Apr 28, 2009 at 23:18, Antonio PHP wrote:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'Created = NOW(),
> Updated = NOW()' at line 8
>
> 'C
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Created = NOW(),
Updated = NOW()' at line 8
'Created' and 'Updated' are set to datetime (InnoDB).
The same syntax works for some newly created tables... and gives
On 31 Jan 2005, at 11:39 pm, Tom Crimmins wrote:
I think datediff only takes two arguments and you have three listed.
Nailed it! Thanks, Tom.
Best regards,
CK.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Dear list,
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_t
--- Jim Winstead <[EMAIL PROTECTED]> wrote:
> My point was that you can't compare a column with an
> array
> of numbers using the '=' operator. You have to use
> the IN
> operator, as in the line of code I posted:
Thank you Jim , it's working now!
Stuart
--
MySQL General Mailing List
For li
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
I've had this going over on the php-general list.
Thought I would throw it out here . Running PHP 4.0.22
Keep getting this error -
SELECT PostStart, JobTitle, Industry, LocationState,
VendorID FROM VendorJobsSELECT PostStart, JobTitle,
Industry, LocationState, VendorID FROM VendorJobsWHERE
Vendo
com> cc:
Fax to:
06/16/200
From: Scott Fletcher [mailto:[EMAIL PROTECTED]
> When I use this SQL statement, ...
>
> --snip--
> UPDATE BUSINESS_CATEGORY SET
> (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) =
> ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '73
When I use this SQL statement, ...
--snip--
UPDATE BUSINESS_CATEGORY SET
(BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) =
('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788'
--snip--
I get the SQL syntax error saying,
--snip--
You ha
I'm using amavisd-new -20030616p9, RH 3.0 ES and mysql 3.23.58-1 trying
to do sql lookups for user prefs. I've done this before and have
compared my sql statements and can't figure out the problem.
When i start amavisd-new with the debug switch, here's what i get:
# /usr/local/sbin/amavisd debu
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
Hi All
I have been pushing my syslogs to the following mysql table
However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax
Here are two lines with ' from my syslog:
Jan 1 03:58:15 dal-svcs-02.inet.qwest.net 203: *Jan 1 08:58:13.926
UTC: %PFINIT-SP-5-CONFIG_SYNC: Syn
on:
Server101.com
>MySQL support: none
>Synopsis: Replication halts with sql syntax error
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.54 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver
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
Sorry for the repost of this problem, but I can't find the answer anywhere,
and I'm stuck here until I solve this.
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 1
I keep getting this error.
table products created: create table products (
sku VARCHAR(20) NOT NULL PRIMARY KEY,
description VARCHAR(255) NOT NULL,
price DECIMAL(12,2) NOT NULL, index(price),
author_editor VARCHAR(80),
isbn VARCHAR(20),
url VARCHAR(40),
title VARCHAR(128) DEFAULT '' NOT NULL, ind
33 matches
Mail list logo