coolt18的专栏

SELECT * FROM (       SELECT ude.*,em.FirstName,em.StaffNo,em.LastName,1 AS isGroup FROM user_deny_emlpoyee AS ude       LEFT JOIN employee_master AS em ON(ude.EmpID=em.EmpID)       WHERE ude.UserI

SELECT * FROM miscellaneous WHERE 1=1 AND `MiscType`='EmpSiteBanReasons' AND `MiscStatus`='A' GROUP BY MiscBigType,MiscName  ORDER BY  `MiscBigType` ASC

xampp 第一次设置密码很方便，于是我随便设置了一个，哪知要改的时候就麻烦了，几经周折才找到如下方法 C:\xampp-portable\mysql\bin\mysqladmin -u root -p password 新密码

SQL 截取字符串 Select Left(@S1,4) 截取从字符串左边开始N个字符 Select right(@S1,11) 截取从字符串右边开始N个字符 http://www.jb51.net/article/19381.htm

DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(BirthDate)) ,'%Y') +0 AS Age SELECT a.*,DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(BirthDate)) ,'%Y') +0 AS Age,b.City,c.Name FROM  `employee_maste