SQL Syntax Error 1064

[jsquarepants]

I am getting an irritating error:  #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 '' at line 55

 

Works

INSERT INTO `test` (`UserName`, `LastName`, `FirstName`, `Title`, `TitleOfCourtesy`, `BirthDate`) VALUES ('JChen','Chen','Jimmy','Admin','Mr.','1985/01/07 00:00:00');

 

Does not work

INSERT INTO `test` (`UserName`, `LastName`, `FirstName`, `Title`, `TitleOfCourtesy`, `BirthDate`) VALUES ('JChen','Chen','Jimmy','Admin','Mr.','1985/01/07 00:00:00'),

('WClifford','Clifford','William','Lead','Mr.','1975/12/09 00:00:00'),

('PDawson','Dawson','Paul','Inspector','Mr.','1951/02/07 00:00:00'),

('JDevey','Devey','James','OBG SMR','Mr.','1971/10/05 00:00:00'),

('SDhanasingh','Dhanasingh','Sukanthan','Inspector','Mr.','1977/10/27 00:00:00',

('CDsouza','Dsouza','Christopher','Inspector','Mr.','1986/03/06 00:00:00'),

('RGade','Gade','Ramesh','Inspector','Mr.','1976/10/31 00:00:00'),

('SGaikwad','Gaikwad','Shailesh','Inspector','Mr.','1980/06/02 00:00:00'),

('UGaikwad','Gaikwad','Umesh','Inspector','Mr.','1983/01/10 00:00:00'),

('SGanguly','Ganguly','Soumendra Nath','Surveyor','Mr.','1977/04/05 00:00:00'),

('GGoulet','Goulet','George','Inspector','Mr.','1946/11/02 00:00:00'),

('BGovindarajan','Govindarajan','Baskar','Inspector','Mr.','1970/05/23 00:00:00'),

('SHall','Hall','Steven','Inspector','Mr.','1965/07/19 00:00:00'),

('CHasler','Hasler','Charles Michael','Inspector','Mr.','1948/04/02 00:00:00'),

('DHernandez','Hernandez','Daniel','Inspector','Mr.','1975/02/13 00:00:00'),

('RHernandez','Hernandez','Rene','Inspector','Mr.','1968/03/23 00:00:00'),

('THo','Ho','Thomas','ASMR','Mr.','1958/10/11 00:00:00'),

('LJi','Ji','Laura','Admin','Miss','1986/03/06 00:00:00'),

('AJuvekar','Juvekar','Amit','Inspector','Mr.','1982/10/06 00:00:00'),

('JKinsey','Kinsey','John','Level III','Mr.','1963/01/19 00:00:00'),

('MLindenmuth','Lindenmuth','Mahlon','Task Leader','Mr.','1969/12/04 00:00:00'),

('JLumley','Lumley','James','Paint Inspector','Mr.','1959/06/16 00:00:00'),

('JMarsau','Marsau','John','Surveyor','Mr.','1961/06/28 00:00:00'),

('LMartinez','Martinez','Leonardo','Surveyor','Mr.','1982/03/23 00:00:00'),

('SMath','Math','Shivputtrayya','Inspector','Mr.','1978/02/22 00:00:00'),

('TMcClendon','McClendon','Timothy','Inspector','Mr.','1966/02/01 00:00:00'),

('MMiller','Miller','Mark','Inspector','Mr.','1953/02/24 00:00:00'),

('MMurugan','Murugan','Manikandan','Inspector','Mr.','1982/06/06 00:00:00'),

('SNaddi','Naddi','Sandeep Kumar','Inspector','Mr.','1983/07/27 00:00:00'),

('MNg','Ng','Michael','ASMR','Mr.','1981/11/30 00:00:00'),

('HPatel','Patel','Hiranch','Inspector','Mr.','1981/05/14 00:00:00'),

('RPatterson','Patterson','Rodney','Inspector','Mr.','1980/07/23 00:00:00'),

('WPau','Pau','Wai','Inspector','Mr.','1957/10/20 00:00:00'),

('APeterson','Peterson','Arthur','Inspector','Mr.','1961/11/29 00:00:00'),

('NPillai','Pillai','Nagalingam','Inspector','Mr.','1971/07/26 00:00:00'),

('SPillai','Pillai','Santhosh','Inspector','Mr.','1982/07/19 00:00:00'),

('SPrabhu','Prabhu','Surendra','Inspector','Mr.','1980/04/26 00:00:00'),

('MPrabhune','Prabhune','Manoj Sudhakar','Inspector','Mr.','1975/09/19 00:00:00'),

('KRiley','Riley','Kenneth','Inspector','Mr.','1966/12/20 00:00:00'),

('VSelvanayaham','Selvanayaham','Vibin Kumar','Inspector','Mr.','1981/05/24 00:00:00'),

('RSharma','Sharma','Robin','Inspector','Mr.','1987/05/05 00:00:00'),

('DShin','Shin','Dong Jun','Inspector','Mr.','1953/03/03 00:00:00'),

('JSimonis','Simonis','Jim','ASMR','Mr.','1985/04/24 00:00:00'),

('VSingh','Singh','Vikram','Inspector','Mr.','1987/07/21 00:00:00'),

('JSquier','Squier','James','Admin','Mr.','1967/05/07 00:00:00'),

('CSudalaimuthu','Sudalaimuthu','Chandra Kumar','Inspector','Mr.','1981/05/19 00:00:00'),

('RTharikoppada','Tharikoppada','Raghavendrareddy','Inspector','Mr.','1982/07/01 00:00:00'),

('ETsang','Tsang','Eric','OBG SMR','Mr.','1981/04/21 00:00:00'),

('AUpadhye','Upadhye','Anand','Inspector','Mr.','1974/07/08 00:00:00'),

('SUtekar','Utekar','Shrikant','Inspector','Mr.','1985/03/11 00:00:00'),

('LViars','Viars','Larry','Inspector','Mr.','1969/07/05 00:00:00'),

('SWadkar','Wadkar','Shailesh Vasant','Inspector','Mr.','1981/02/24 00:00:00'),

('AWahbeh','Wahbeh','Ahmed M.','Asia Task Lead','Mr.',''),

('VWang','Wang','Victor','Admin','Mr.','1983/08/13 00:00:00'),

('YZhao','Zhao','Yanna','Admin','Miss','1989/11/07 00:00:00');

 

Help

[PFMaBiSmAd]

The following line is missing the closing ) -

 

('SDhanasingh','Dhanasingh','Sukanthan','Inspector','Mr.','1977/10/27 00:00:00',