MySQL讲解基础知识.pptVIP

SQL语句现实增、删、改、查实例 例8：学会用GROUP BY 和having： char_length()可以计算中文长度，而length()计算的是普通字符的长度 select SysUser.Personnel_ID ,Code ,Cname from SysUser ,SysUserRole where Code like x% and Password=123456 and SysUser.Personnel_ID=SysUserRole.Personnel_ID Group by SysUser.Personnel_ID ,Code ,Cname Having CHAR_LENGTH(Cname)3 order by SysUser.Personnel_ID desc SQL语句现实增、删、改、查实例 例9：查询表中密码最长的用户：： select SysUser.Personnel_ID ,Code ,Cname ,MAX(length(Code)) as length from SysUser ,SysUserRole where