How to use the SQL key word EXISTS?# Database - 数据库
m*f
1 楼
I use mysql for a web application.
This application requires the customer to log in using his email address and a
password.
Now when I get the customer password, I want to check the customer table in my
database and see if that e-mail address exists. If it exists, I then check if
the password the customer has just entered matches the one in the customer
table associated with the e-mail address.
What SQL statement should I use to check if the customer-supplied e-mail
address exists in the custom
This application requires the customer to log in using his email address and a
password.
Now when I get the customer password, I want to check the customer table in my
database and see if that e-mail address exists. If it exists, I then check if
the password the customer has just entered matches the one in the customer
table associated with the e-mail address.
What SQL statement should I use to check if the customer-supplied e-mail
address exists in the custom