SolveErrors
MYSQL

SQL error Not sure why

11 views

I' have the following statement

Code:
UPDATE address_book VALUES(entry_firstname='joe',entry_lastname='blow',entry_company='test',entry_street_address='test island',entry_suburb='none',entry_city='boothaby',entry_state='maine',entry_postcode='04537',can_pho  ne_1='2078889990',can_phone_2='2078889909') WHERE address_book.customer_id = '1'


Code:
Error

SQL query:

UPDATE address_book VALUES (
entry_firstname = 'joe', entry_lastname = 'blow', entry_company = 'test', entry_street_address = 'test island', entry_suburb = 'none', entry_city = 'boothaby', entry_state = 'maine', entry_postcode = '04537', can_phone_1 = '2078889990', can_phone_2 = '2078889909'
)
WHERE address_book.customer_id = '1'

MySQL said: Documentation
#1064 - 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 'VALUES(entry_firstname='joe',entry_lastname='blow',entry_company='test',entry_st' at line 1


Any idea?

More MYSQL fixes

Mysql DumpingNeed help understanding error messageSorting problemMySQL resourcesItalian Characters are stored as "?" in the database.Querying unrelated tables