Question

满足两个变量条件的SQL语句怎么写？

SELECT *
FROM Sheet1
WHERE 学号 = 'MMColParam',另一条件是满足密码是123456，是想实现密码控制登录，运行时只出现登录失败页面，登录匹配时则不能连接页面，提示错误是SQL语句错，不知怎么写了

Answer 1

SELECT [DISTINCT | ALL] { *
| { [schema.]{table | view | snapshot}.*
| expr } [ [AS] c_alias ]
[, { [schema.]{table | view | snapshot}.*
| expr } [ [AS] c_alias ] ] ... }
FROM [schema.]{table | view | snapshot}[@dblink] [t_alias]
[, [schema.]{table | view | snapshot}[@dblink] [t_alias] ] ...
[WHERE condition ]
[GROUP BY expr [, expr] ... [HAVING condition] ]
[{UNION | UNION ALL | INTERSECT | MINUS} SELECT command ]
[ORDER BY {expr|position} [ASC | DESC]
[ {expr|position} [ASC | DESC]] ...]

Answer 2

select * from tb_Users where Name='liu' and Password='123'
把你的程序报出的错误信息发出来晒晒。

Answer 3

select * from sheet1 where 学号='MMColParam' and 密码='123456'

Answer 4

where A条件 and B条件