Redian新闻
>
How to use the SQL key word EXISTS?
avatar
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
avatar
x*u
2
画蛇添足啊。
SELECT customer_password FROM customer WHERE customer_email = 'bill...';
or more simply
SELECT customer_password FROM customer WHERE customer_email = 'bill...'
AND customer_password = '...';

a
my
if

【在 m****f 的大作中提到】
: 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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。