2020
10-09
10-09
MySQL查询语法汇总
前言：本篇文章主要简介下MySQL中where,groupby,orderby,limit,join,union,unionall,子表等查询语法。测试数据准备createtableemp(empnonumeric(4)notnull,enamevarchar(10),jobvarchar(9),mgrnumeric(4),hiredatedatetime,salnumeric(7,2),commnumeric(7,2),deptnonumeric(2));createtabledept(deptnonumeric(2),dnamevarchar(14),locvarchar(13));createtablesalgrade(gr...
继续阅读 >