View Single Post
Old 01-10-2008, 04:55 PM   #4 (permalink)
SOCK
The Acquainted
 
Join Date: Nov 2007
Posts: 154
Thanks: 31
SOCK is on a distinguished road
Default

webtuto> An INSERT statement cannot use a WHERE clause. You either perform an INSERT and it inserts data (imagine that) or you perform an UPDATE where you can define columns to update WHERE some condition is met.

MySQL Manual : SQL Statement Syntax : INSERT syntax | UPDATE syntax

Also, please read the MySQL Tutorial.
SQLZoo is also a good reference.
__________________
I reject your reality, and substitute my own.
SOCK is offline  
Reply With Quote
The Following User Says Thank You to SOCK For This Useful Post:
webtuto (01-10-2008)