当前位置: 首页 > >

mysql中的语法,比如*星号

发布时间:

mysql中的语法,比如*星号

#语法正确,不报错
SELECT *, department_name FROM departments;
SELECT department_name, * FROM departments;
#语法正确,不报错
SELECT department_name, departments.* FROM departments;
#语法正确,不报错
SELECT department_name, dep.* FROM departments dep;
#语法正确,不报错
SELECT dep.department_name, dep.* FROM departments dep;
#语法正确,不报错
SELECT dep.`department_name`, dep.* FROM departments dep;



友情链接: