[MySQL] 1064 Error on INSERT Query
Trying to update a ton of 301 redirects and I keep getting a 1064 error in the first line. I'm not sure how to fix it. Any help would be appreciated.
INSERT INTO tbl_name "bob_psp_link_redirect" ("url","url_redirect")
VALUES("http://happyhappy.com/happyhappy/","http://happyhappy.com/happyhappy/"),
VALUES("http://happyhappy.com/happyhappy/","http://happyhappy.com/happyhappy/"),
VALUES("http://happyhappy.com/happyhappy/","http://happyhappy.com/happyhappy/");
Here's the Error I'm getting:
Error in query (1064): Syntax error near '"bob_psp_link_redirect" ("url","url_redirect") VALUES("http://happyhappy.com' at line 1
Pardon the double quotes, I changed those right before posting here thinking that might be causing an issue because of the oddball php manager I'm using. It wasn't the problem.
Posted Apr 15, 2016, 12:53 AM UTC
44