Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Why additional condition in MySQL? #1

Open
GoogleCodeExporter opened this issue Mar 19, 2015 · 2 comments
Open

Why additional condition in MySQL? #1

GoogleCodeExporter opened this issue Mar 19, 2015 · 2 comments

Comments

@GoogleCodeExporter
Copy link

Login page, so i have the data in my database, successfully logged in, but 
bumulaga:
---------
Database Error Occured
Error Number: 1054

Unknown column 'type' in 'where clause'

SELECT FROM (`user`) WHERE `empnum` = '081000' AND `type` = 'superuser'

(bla bla bla)
--------------

Question: What is the need for "`type` = 'superuser'"? It seems na pwede na 
siyang wala dun sa SQL query di ba?

Original issue reported on code.google.com by abraham.darius.llave on 2 May 2011 at 8:17

@GoogleCodeExporter
Copy link
Author

May kulang ata...
dapat:
SELECT ____ from `user` where `empnum` = '081000' AND `type` = 'superuser'...

-> SELECT * from `user`

^parang ganito?

Original comment by [email protected] on 2 May 2011 at 8:22

@GoogleCodeExporter
Copy link
Author

hindi tin eh, wala namang bearing yung asterisk. anyway, it seems na 
'pang-segregate' ni kim eto. 

Original comment by abraham.darius.llave on 3 May 2011 at 7:56

  • Changed state: Started

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant