r/SQL•
seanbennick

[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
Loading comments…