Login Register






Thread Rating:
  • 0 Vote(s) - 0 Average


sql insert where statment need help 0.o??? filter_list
Author
Message
RE: sql insert where statment need help 0.o??? #2
With your SQL INSERT INTO Statement, you've enclosed the id column In single quotes and you haven't ended your SQL query In a semicolon, hence the syntax error  near "WHERE".

The value of '100' Is fine (single quotes), but given the id column Is only one word (not separated) you can either enclose It In "Back Ticks", or leave It as Is, but NOT single quotes.

Example:
Column In Back Ticks
Code:
 WHERE (`id`) = ('100') ;

No Back Ticks
Code:
WHERE (id) = ('100') ;

Either of the two will work. Don't forget to use the semicolon at the end of the statement.
[Image: AD83g1A.png]

[+] 2 users Like mothered's post
Reply





Messages In This Thread
RE: sql insert where statment need help 0.o??? - by mothered - 06-02-2017, 06:58 AM



Users browsing this thread: 1 Guest(s)