我真的不知道如何解释这一点,但我基本上想检查2具体的东西在表的属性。表格如下:
用户:
name => "simples"
age => "Monday"
我怎么检查这两个呢?我觉得应该是这样的:
$query = "SELECT *
FROM `data`.`user`
WHERE `user`.`name` = 'simples'
AND `user`.`age`='monday';";
写简单查询:
基本语法:select * from databasename.tablename where column_name1 = value1 and column_name2 = value2
例如:
SELECT * FROM data.user WHERE name = 'simples' AND age = 'Monday'
查询:
SELECT * FROM user where name='simples' AND age='Monday'