helloand helloand - 5 months ago 12
PHP Question

SQL Error #1064 help pls

I'm trying to follow a tutorial on this website, but when I try to insert the below statement I get this 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 '
INSERT INTO login_admin (user_name, user_pass)
VALUES
(
‘admin’, SHA(‘a
' at line 7


INSERT INTO login_admin (user_name, user_pass)
VALUES
(
‘swashata’, SHA(‘swashata’)
)

INSERT INTO login_admin (user_name, user_pass)
VALUES
(
‘admin’, SHA(‘admin’)
)

Answer

You're trying to run two queries at once, not one. Each INSERT statement is a separate query. You have to separate queries with a delimiter (;).

In fact, unless you have some bad settings on your server (allowing multiple queries at once), you can't even do that and need to run them as two separate queries, or combine them using multiple VALUES lists.

Also, please note that you cannot use tick marks () to indicate a string value. You need to use single quotes (') instead.

The best approach is to rewrite your queries as:

INSERT INTO login_admin (`user_name`, `user_pass`) VALUES
( 'swashata', SHA('swashata') ),
( 'admin', SHA('admin') )

Finally, I really hope you aren't using SHA to generate passwords. That's not secure. Use PHP's built-in password functionality.

Comments