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

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -