Ok, based on the given syntax from the mysql manual..
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]
I've been trying to update some records in a test database I've been
playing with. I'm
I don't believe you need the second set
update Pictures set Date Posted = '2001-05-09', Notes = 'Test' where
ID ='1';
I think that should work
-Original Message-
From: Barry L. Jeung [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 3:56 PM
To: [EMAIL PROTECTED]
Subject: Update
You only need to specify SET once.
update Pictures set Date_Posted = '2001-05-09', Notes = 'Test' where ID
='1';
- Original Message -
From: Barry L. Jeung [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 12:55 PM
Subject: Update problem, or more likely and problem