- Original Message -
From: florent larose florent.lar...@hotmail.com
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 (
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: Scott Yamahata [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, December 29, 2006 1:29 AM
Subject: SQL syntax
Hi, I'm getting the following error message:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL
Hi Scott, all,
Scott Yamahata wrote:
Hi, I'm getting the following error message:
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 ' enabled
= '1'' at line 3INSERT INTO clf_cities SET cityname = 'Santa
Hi,
have you checked the 'enabled' field datatype or can you give the query.
Thanks
ViSolve DB Team.
- Original Message -
From: Scott Yamahata [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, December 29, 2006 11:59 AM
Subject: SQL syntax
Hi, I'm getting the following
Hi Scott,
at line 3INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid
= , enabled = '1'
The error is because you havent specified the value for the column
countryid. If you do not want to insert the value to the column
countryid then use the following query.. do not leave the
Siegfried Heintze [EMAIL PROTECTED] wrote on 06/29/2005 03:09:28
PM:
671 Did not find any old versions with SELECT cJobTitle FROM
jobtitlecount
WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to
insert
one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTitle)
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an entry, I try an insert:
Siegfried Heintze wrote:
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find
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
[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,
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 near
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
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
delimited.
--- 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:
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 column with an
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 4:08 PM
To: [EMAIL PROTECTED]
Subject: SQL Syntax Problem
$sql = 'SELECT
F.IDArea,
C.IDArea, C.Name, C.Pop, C.Nationality,
C.NationalityPlural, C.NationalityAdjective FROM
Think I found it. I made the changes with explanations of what I did.
If you have any further questions feel free to ask. Oh and this should
be on the list for others to see and maybe learn from
Respectfully,
Ligaya Turmelle
head[DATABASE CONNECTION]/head
body
div class=formdiv
--- Ligaya Turmelle [EMAIL PROTECTED] wrote:
Think I found it. I made the changes with
explanations of what I did.
If you have any further questions feel free to ask.
Oh and this should
be on the list for others to see and maybe learn
from
Wow, thanks so much for going to all that
It's not translating your vars to their respective values.
I didn't look to see why...
But MySQL doesn't know what
$_POST['order']
is.
David Blomstrom wrote:
This may be a purely PHP problem, but the error
message says SQL syntax. Check the manual that
corresponds to your MySQL server
First echo out the SQL and verify it is what you are expecting. If it
isn't try changing it to:
$sql =
'SELECT F.IDArea,
C.IDArea,
C.Name,
C.Pop,
C.Nationality,
C.NationalityPlural,
C.NationalityAdjective
FROM cia_people C, famarea2 F
WHERE
-Heinz Schulz; [EMAIL PROTECTED]
Subject: Re: SQL Syntax Question
- Original Message -
From: Karl-Heinz Schulz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 9:18 PM
Subject: SQL Syntax Question
I tried to get an answer on the PHP mailing list and I was told
Karl-Heinz Schulz wrote:
Thank you for trying to help me.
The output is wrong
I get either
Event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
that query is wrong :
$eventdetail_query = mysql_query(select informations, titles, file_name
from eventdetail, event where
]
Sent: Wednesday, August 04, 2004 5:52 AM
To: Karl-Heinz Schulz
Cc: [EMAIL PROTECTED]
Subject: Re: SQL Syntax Question
Karl-Heinz Schulz wrote:
Thank you for trying to help me.
The output is wrong
I get either
Event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3
- Original Message -
From: Karl-Heinz Schulz [EMAIL PROTECTED]
To: 'Philippe Poelvoorde' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 6:41 AM
Subject: RE: SQL Syntax Question
Philippe,
I changed my to the following but the result is now (I deleted
- Original Message -
From: Karl-Heinz Schulz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 9:18 PM
Subject: SQL Syntax Question
I tried to get an answer on the PHP mailing list and I was told that this
list would be quicker to get me a solution.
I have two
Hi,
Then: INSERT INTO Extra_Credit (Student_ID, Points) SELECT MAX(Student_ID)
from Students,
(1) ...VALUE ('25');
or
(2) ... '25' as Points;
I think this is your query:
INSERT INTO Extra_Credit(Student_ID, Points) SELECT MAX(Student_ID), '25' from Students
Take care,
Aleksandar
As I understand it, you don't really want the MAX(Student_ID), you want
the actual Student_ID of the last insert. It is important to note that
they are not necessarily the same. If you insert Student 24, then I
insert Student 25, then you check MAX(Student_ID), you will get 25, not
24.
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
Hello, my name's Marlon. I have a question about sql and I need some help!
How can I do something like it using mysql?
update registre set (name='NewName' where lastname='OldLastName'),
(name='OldName' where lastname='NewLastName');
I _believe_ you can do it this way. I'm sure someone
At 11:40 -0700 7/22/03, Cory Lamle wrote:
Contents are Direct Alliance Corporation CONFIDENTIAL
-
How do you type check in mysql. I have a column of type varchar(20) with
both floats and strings. Is there a way to check the type?
In this case, the type of the column as far as MySQL is concerned
Cory,
I'm not sure I understand what you're asking. MySQL casts the data to the
appropriate column type when that data is entered into the database. Data
in a varchar column is always stored as a string, just as data in an INT
field is always going to be of type INT.
-Rob
-Original
On Sat 2003-02-01 at 10:35:46 -, [EMAIL PROTECTED] wrote:
Hi Benjamin,
Wow, that sure sorted that problem out... I had to rejig it slightly to
get it to work,
Oops... too much copypaste by me :-)
but this is the final working version:
Glad it worked out.
Bye,
Benjamin.
That is one bloody complex query :).
As far as I know, MySQL does not support RIGHT JOIN leyword, so that's where
it's failing. Someone slap me if I'm wrong.
It may be possible to fetch the results you want without such a hairy query.
Just include a partial dump of involved tables and concise
Hi.
On Fri 2003-01-31 at 15:46:37 -, [EMAIL PROTECTED] wrote:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
On Fri, Jan 31, 2003 at 02:07:11PM -, Kevin Smith wrote:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
b.price, b.quantity,
work out why I couldn't do that so I can better
understand it.
Kevin
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Kevin Smith [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 4:32 AM
Subject: Re: SQL Syntax
Hi.
On Fri 2003-01-31 at 15:46
Also, this might help to solve the problem, this is a graphical schema of
the query from MS Access, to give you all a better idea of what I'm trying
to accomplish...
http://www.netsmith.ltd.uk/example.gif
- Original Message -
From: Kevin Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
You almost got it. Your syntax will be something like this:
UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column
like%#%
When I am trying to figure out the syntax for something, I always add a
LIMIT 1 at the end so that only one record gets changed.
On Saturday, October 5,
Scott,
Saturday, October 05, 2002, 7:45:16 AM, you wrote:
SJ I have a db with slightly over 614,000 records of names and addresses. In
SJ the address column, there are quite a few records like
SJ 123 any rd # 2
SJ 319 w. 1st st # B
SJ 4321 test blvd # 42
SJ etc
SJ I want to replace all the
Pada Sun, 25 Aug 2002 22:04:13 +0200
David Durham [EMAIL PROTECTED] menulis :
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
If I say:
select * from CompanyContacts
where Description like '%marve%'
What was the error message displayed on
David
[ mysql,query ]
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
Can you show us the output of:
describe CompanyContacts
...and also what is the exact error message?
Are you connected as a user who is allowed to update the
Hello!
David Durham wrote:
If this question is off topic, please let me know.
I have a description field with a set of keywords. I need to update
some data based on a keyword, which is randomly placed in the field.
Can someone please help with a SQL syntax to find the word within the
Use LIKE '%KEYWORD%'
At least this works for Oracle
-Original Message-
From: David Durham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 3:39 PM
To: [EMAIL PROTECTED]
Subject: SQL Syntax (May be OT)
If this question is off topic, please let me know.
I have a description
Graham,
Monday, May 13, 2002, 8:45:09 PM, you wrote:
GN I have a directory of professional magicians, consisting of a MySQL table
GN like
GN this:
GN +-++-+
GN | artist | area| magic |
GN
At 10:02 AM -0800 12/18/01, Steve Osborne wrote:
I would like to use an input form to add users to my database, however, if
the name is already in use, I do not want to add a duplicate record. I also
need this to be case insensitive (ie Santa Claus = santa Claus).
Make the (LastName,
]
- 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
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
Robert Martin wrote:
Hi,
I?m still learning sql so I hope this doesn?t sound to basic.
I would like to find out if there is a way to insert a record only when (X and Y) do
not exist.
I have the value to check against stored in a variable.
ALTER TABLE table ADD UNIQUE u_xy_idx ( x, y );
You probably want a unique index for those cols. Check out:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html (search for unique in page)
and
http://www.mysql.com/doc/C/R/CREATE_INDEX.html
-Joe
-Original Message-
From: Robert Martin [mailto:[EMAIL PROTECTED]]
Sent: Monday, October
Date |Tue, 28 Aug 2001 15:14:54 +0500
From |Alexander Barkov [EMAIL PROTECTED]
Hello!
AB Hello!
AB These query produces an SQL syntax error
AB in 3.23.29a-gamma:
AB GRANT ALL PRIVILEGES ON databases.*
AB TO 'foo'@'localhost' IDENTIFIED BY 'bar';
AB SHOW TABLES FROM databases;
AB
On 26-Apr-01 [EMAIL PROTECTED] wrote:
I have two table I need to join in a query. The second table needs to be
join twice (I think) to the first. Details as follows (tables pared
down)...
Table games
gameid
hometeamid
guestteamid
Table team
teamid
sponsor
I want a query to
Hi there,
I'm using mysql 3.22.27 and get error when trying to run this select
statement:
SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect,
FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl,
custmls.municname,custmls.state,custmls.zipcd,custmls.salesassoc,
At 10:09 PM +0200 2/2/01, Ciprian wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Anybody knows where I can find a list with all SQL syntax -es.
Eventually explained.
Thanks
If you mean the SQL statements supported by MySQL, the MySQL Reference
Manual is a
54 matches
Mail list logo