奇怪的错误您的SQL语法中有错误

Question

Im tring save a form data to a table, but it getting mysql error, i checked everywhwre data types and all other things are ok, here is my mysql query

 INSERT INTO personal_events
        VALUES (
        evt_date, evt_start, evt_end, evt_subject, evt_notes, evt_user
        )
        VALUES (
        '2013-03-29', '11', '12', 'test', 'test notess', 21
       )

error details

#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( '2013-03-29', '11', '12', 'test', 'test notess', 21)' at line 1 

can anyone help me to fix this

Answer 1

You have two VALUES. Use the following:

INSERT INTO personal_events
    (
    evt_date, evt_start, evt_end, evt_subject, evt_notes, evt_user
    )
    VALUES (
    '2013-03-29', '11', '12', 'test', 'test notess', 21
   )