JavaEE.sql.Select查询语句

SELECT语句

语法格式

//选择字段

SELECT column1, column2, ...

FROM table_name;

//全表

 

SELECT * FROM table_name;

S1.全表查询

SELECT

     *

FROM

     test_master

S2.选择查询

SELECT

     id,

     userName,

     bindNo

FROM

     test_master

S3.连表查询

SELECT

     m.id,

     m.userName,

     m.bindNo,

     s.registerDate

FROM

     test_master m,

     test_slave s

WHERE

     m.bindNo = s.bindNo

ref

https://www.w3schools.com/sql/sql_select.asp

http://www.runoob.com/mysql/mysql-select-query.html