msmith29063
03-21-2010, 07:00 PM
I'm getting an error 1064 in phpMyAdmin when I use the following syntax to update a MySQL5 database table:
UPDATE trucks SET truckType='asd1', truckYear='ad1', make='asd1', model='sdf1', truckEngine='sdf1', transmission='sdf1', gvw='sdf1', axle='sdf1', mileage='sdf1', brakes='sdf1', tire='sdf1', wheel='sdf1', body='sdf1', bay='sdf1', aircond='sdf1', color='sdf1', decals='sdf1', wheelbase='sdf1', gear='sdf1', condition='sdf1', price='sdf1', units='sdf1' WHERE unit=1234
Any ideas? All the field exist in the database.
Thank you for any advice you can give.
UPDATE trucks SET truckType='asd1', truckYear='ad1', make='asd1', model='sdf1', truckEngine='sdf1', transmission='sdf1', gvw='sdf1', axle='sdf1', mileage='sdf1', brakes='sdf1', tire='sdf1', wheel='sdf1', body='sdf1', bay='sdf1', aircond='sdf1', color='sdf1', decals='sdf1', wheelbase='sdf1', gear='sdf1', condition='sdf1', price='sdf1', units='sdf1' WHERE unit=1234
Any ideas? All the field exist in the database.
Thank you for any advice you can give.