Error in Insert Statement with Mysql

Question

I am getting the following error when I am executing the following statement

INSERT INTO upcoming_matches(
    Id, Date, me_date, Match, team1, team2, 
    Timing, Status, series_id, 
    match_place,series_mtch_type, match_live,match_result, MINI_LINK, 
    PHOTOS_URL, scorecard_ID) 
VALUES(
    764, '2012/03/11', '2012/03/11', 'Bangla vs Pak', '2', '6', 
    '08:00 GMT | 14:00 local 13:30 IST', 1, 171, 
    'Shere Bangla National Stadium, Mirpur', 'ODI', 1, '', '1483',  
    'http://www.cricandcric.com/photo-gallery/', 3258)
GO

[Error] Script lines: 1-5 --------------------------
 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 'Match, team1, team2, Timing, Status, series_id, match_place,
 series_mtch_type, ' at line 1 

 Warnings: ---> 
   W (1): 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 'Match, team1, team2, Timing, Status, series_id, match_place,
 series_mtch_type, ' at line 1
          <---

Can any one please help me with this

possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — Ian Ringrose
– Ian Ringrose, Commented May 6, 2014 at 9:56

zerkms · Accepted Answer · 2012-04-08 08:46:51Z

1

match is a reserved mysql keyword, you need to enclose it with backticks

`match`

answered Apr 8, 2012 at 8:46

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aleroot · Accepted Answer · 2012-04-08 08:47:16Z

1

You don't have to close the statement with the GO keyword in MySQL, you have to close it with the semicolon ;

You have also to put backtick around any field name that could contain reserved keywork or capitalized field.

answered Apr 8, 2012 at 8:47

aleroot

73k32 gold badges182 silver badges220 bronze badges

Collectives™ on Stack Overflow

Error in Insert Statement with Mysql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related