mysql - Simple SELECT SQL statement not working -
select user members admin=1; select user members id=1;
the first query not work because there's error in syntax. second works virtually identical. both 'admin' , 'id' int(11), 'id' primary key , set auto-increment. what's wrong here?
the error receive is:
you have error in sql syntax; check manual corresponds mysql server version right syntax use near 'admin=1' @ line 1
when use keywords or reserved words don't forget add quotes or brackets.
select [user] members [admin]=1; select [user] members id=1;
Comments
Post a Comment