标签：表查询

基本查询SQL笔记

查询一个表的所有字段SELECT * FROM user;查询了user表的所有字段。指定字段查询SELECT id,email FROM user;别名SELECT id,email AS emails FROM user;它会将email字段名改成emails展示。查询条件-包含查询email中含有@符号的数据：SELECT * FROM user WHERE email LIKE "%@%";查询email中含有@符号并且id大于2的数据：SELECT * FROM user WHERE email LIKE "%@%" AND id>...