mysql - How do I fix this SQL syntax error, I cannot find it -
1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'insert ******_sports_teams (******_team_id, ******_content_type_id, ******' @ line 2
that error script;
the stars cover name of company work cannot release, same word know spelled correctly.
select * `******_sports_teams` 1 insert ******_sports_teams (******_team_id, ******_content_type_id, ******_content_type_desc, ******_sport_name, ******_sport_confernece, ******_sport_division, ******_sport_city, ******_sport_team) values (1,4,'sports','nba','eastern','atlantic','boston','celtics'), (2,4,'sports','nba','eastern','atlantic','brooklyn','nets'), (3,4,'sports','nba','eastern','atlantic','newy york','knicks'), (4,4,'sports','nba','eastern','atlantic','philedelphia','76ers'), (5,4,'sports','nba','eastern','atlantic','toronto','raptors'), (6,4,'sports','nba','eastern','central','chicago','bulls'), (7,4,'sports','nba','eastern','central','cleveland','cavaliers'), (8,4,'sports','nba','eastern','central','detriot','pistons'), (9,4,'sports','nba','eastern','central','indiana','pacers'), (10,4,'sports','nba','eastern','central','milwaukee','bucks'), (11,4,'sports','nba','eastern','southeast','atlanta','hawks'), (12,4,'sports','nba','eastern','southeast','charlotte','hornets'), (13,4,'sports','nba','eastern','southeast','miami','heat'), (14,4,'sports','nba','eastern','southeast','orlando','magic'), (15,4,'sports','nba','eastern','southeast','washington','wizards'), (16,4,'sports','nba','western','southwest','dallas','mavericks'), (17,4,'sports','nba','western','southwest','houston','rockets'), (18,4,'sports','nba','western','southwest','memphis','grizzlies'), (19,4,'sports','nba','western','southwest','new orleans','pelicans'), (20,4,'sports','nba','western','southwest','san antonio','spurs'), (21,4,'sports','nba','western','northwest','denver','nuggets'), (22,4,'sports','nba','western','northwest','minnesota','timber wolves'), (23,4,'sports','nba','western','northwest','oaklohoma city','thunder'), (24,4,'sports','nba','western','northwest','portland','trail blazers'), (25,4,'sports','nba','western','northwest','utah','jazz'), (26,4,'sports','nba','western','pacific','golden state','warriors'), (27,4,'sports','nba','western','pacific','los ageles','clippers'), (28,4,'sports','nba','western','pacific','los ageles','lakers'), (29,4,'sports','nba','western','pacific','pheonix','suns'), (30,4,'sports','nba','western','pacific','sacremento','kings'), (31,4,'sports','mlb','american','east','tampa bay','rays'), (32,4,'sports','mlb','american','east','new york','yankees'), (33,4,'sports','mlb','american','east','baltimore','orioles'), (34,4,'sports','mlb','american','east','toronto','blue jays'), (35,4,'sports','mlb','american','east','boston','red socks'), (36,4,'sports','mlb','american','central','kansas city','royals'), (37,4,'sports','mlb','american','central','minnesota','twins'), (38,4,'sports','mlb','american','central','detriot','tigers'), (39,4,'sports','mlb','american','central','cleveland','indians'), (40,4,'sports','mlb','american','central','chicago','white sox'), (41,4,'sports','mlb','american','west','houston','astros'), (42,4,'sports','mlb','american','west','texas','rangers'), (43,4,'sports','mlb','american','west','los ageles','angels'), (44,4,'sports','mlb','american','west','seattle','mariners'), (45,4,'sports','mlb','american','west','oakland','athletics'), (46,4,'sports','mlb','national','east','new york','mets'), (47,4,'sports','mlb','national','east','washington','nationals'). (48,4,'sports','mlb','national','east','atlanta','braves'), (49,4,'sports','mlb','national','east','philedelphia','phillies'), (50,4,'sports','mlb','national','east','miami','marlins'), (51,4,'sports','mlb','national','central','st. louis','cardinals'), (52,4,'sports','mlb','national','central','pittsburg','pirates'), (53,4,'sports','mlb','national','central','chicago','cubs'), (54,4,'sports','mlb','national','central','cincinnati','reds'), (55,4,'sports','mlb','national','central','milwaukee','brewers'), (56,4,'sports','mlb','national','west','los ageles','dodgers'), (57,4,'sports','mlb','national','west','san francisco','giants'), (58,4,'sports','mlb','national','west','arizona','diamondbacks'), (59,4,'sports','mlb','national','west','san diego','padres'), (60,4,'sports','mlb','national','west','colorado','rockies'), (61,4,'sports','nfl','nfc','east','dallas','cowboys'), (62,4,'sports','nfl','nfc','east','new york','giants'), (63,4,'sports','nfl','nfc','east','philedelphia','eagles'), (64,4,'sports','nfl','nfc','east','washington','redskins'), (65,4,'sports','nfl','nfc','west','arizona','cardinals'), (66,4,'sports','nfl','nfc','west','san francisco','49ers'), (67,4,'sports','nfl','nfc','west','seattle','seahawks'), (68,4,'sports','nfl','nfc','west','st. louis','rams'), (69,4,'sports','nfl','nfc','north','chicago','bears'), (70,4,'sports','nfl','nfc','north' ,'detriot','lions'), (71,4,'sports','nfl','nfc','north' ,'green bay','packers'), (72,4,'sports','nfl','nfc','north' ,'minnesota','vikings'), (73,4,'sports','nfl','nfc','south','atlanta','falcons'), (74,4,'sports','nfl','nfc','south', 'carolina','panthers'), (75,4,'sports','nfl','nfc','south','new orleans','saints'), (76,4,'sports','nfl','nfc','south','tampa bay','buccaneers'), (77,4,'sports','nfl','afc','east','buffalo','bills'), (78,4,'sports','nfl','afc','east','miami','dolphins'), (79,4,'sports','nfl','afc','east','new england','patriots'), (80,4,'sports','nfl','afc','east','new york','jets'), (81,4,'sports','nfl','afc','west','denver','broncos'), (82,4,'sports','nfl','afc','west','kansas city','chiefs'), (83,4,'sports','nfl','afc','west','oakland','raiders'), (84,4,'sports','nfl','afc','west','san diego','chargers'), (85,4,'sports','nfl','afc','north' ,'baltimore','ravens'), (86,4,'sports','nfl','afc','north' ,'cleveland','browns'), (87,4,'sports','nfl','afc','north','pittsburg','steelers'), (88,4,'sports','nfl','afc','north' ,'cincinnati','bengals'), (89,4,'sports','nfl','afc','south','houston','texans'), (90,4,'sports','nfl','afc','south','indianapolis','colts'), (91,4,'sports','nfl','afc','south','jacksonville','jaguars'), (92,4,'sports','nfl','afc','south','tennessee','titans'), (93,4,'sports','nhl','nhl','central','chicago','blackhawks'), (94,4,'sports','nhl','nhl','central','colorado','avalanche'), (95,4,'sports','nhl','nhl','central','dallas','stars'), (96,4,'sports','nhl','nhl','central','minnesota','wild'), (97,4,'sports','nhl','nhl','central','st. louis','blues'), (98,4,'sports','nhl','nhl','central','winnipeg','jets'), (99,4,'sports','nhl','nhl','central','nashville','predators'), (100,4,'sports','nhl','nhl','pacific','anaheim' ,'ducks'), (101,4,'sports','nhl','nhl','pacific','arizona','coyotes'), (102,4,'sports','nhl','nhl','pacific','clagary','flames'), (103,4,'sports','nhl','nhl','pacific','edmonton','oilers'), (104,4,'sports','nhl','nhl','pacific','los ageles','kings'), (105,4,'sports','nhl','nhl','pacific','san jose','sharks'), (106,4,'sports','nhl','nhl','pacific','vancouver','canucks'), (107,4,'sports','nhl','nhl','atlantic','boston','bruins'), (108,4,'sports','nhl','nhl','atlantic','buffalo','sabres'), (109,4,'sports','nhl','nhl','atlantic','detriot','red wings'), (110,4,'sports','nhl','nhl','atlantic','florida','panthers'), (111,4,'sports','nhl','nhl','atlantic','montreal','canadiens'), (112,4,'sports','nhl','nhl','atlantic','ottawa','senators'), (113,4,'sports','nhl','nhl','atlantic','tampa bay','lightning'), (114,4,'sports','nhl','nhl','atlantic','toronto','maple leafs'), (115,4,'sports','nhl','nhl','metropolitan','corolina','hurricanes'), (116,4,'sports','nhl','nhl','metropolitan','columbus','blue jackets'), (117,4,'sports','nhl','nhl','metropolitan','new jersey','devils'), (118,4,'sports','nhl','nhl','metropolitan','new york','islanders'), (119,4,'sports','nhl','nhl','metropolitan','new york','rangers'), (120,4,'sports','nhl','nhl','metropolitan','philedelphia','flyers'), (121,4,'sports','nhl','nhl','metropolitan','pittsburg','penguins'), (122,4,'sports','nhl','nhl','metropolitan','washington','capitals')
your error message show us, 2 queries not separated ;
just remove select query, or add ; after it.
then, double check syntax, or read next error message. have points instead of comma somewhere.
your first query retrieve data table. it's:
select * `******_sports_teams` 1 it should terminated semicolon before call next (insert) query
Comments
Post a Comment