数据库查询 --单表查询

查询所有字段值

SELECT * FROM member;

查询指定字段

SELECT  regName FROM member;

条件查询

SELECT  regName,mobilePhone FROM member WHERE regName='qq'AND pwd=123456;

将查询的数据字段从命名

SELECT  regName AS 注册名 FROM member WHERE regName='qq'AND pwd=123456;