Home Syntax error in MySQL INSERT statement with TIME datatypes
Reply: 0

Syntax error in MySQL INSERT statement with TIME datatypes

user527
1#
user527 Published in August 15, 2018, 9:01 am

I'm trying to add records to a MySQL table, but I keep getting a syntax error.

INSERT INTO `lwljhb_lwl_matches` (id, league_seasons_id, schedule_id, playoff_round, scheduled_week_number, date_played, winner_id, loser_id, forfeit, forfeit_reason, match_begin_time, match_end_time)

VALUES  (,14,,0,1,2018-04-15,52,87,0,,'14:55:00','17:41:00');

The id column is autoincrementing, the match_begin_time and match_end_time fields are TIMEs. Can anyone point out my stupid mistake?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.299712 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO