MySql
关注
分享
扫一扫
xueok
About
I am xuegang,Yin.I work in Cangzhou City,Hebei Province of China. A software engineer.After graduated to HeBei Engineering And Technical College in 2000,I have developed many database client-server application using delphi,c buider.Now I am using
展开
-
MySql 命令应用
BODY {FONT-SIZE: 12px; MARGIN: 1.2em 0px; LINE-HEIGHT: 1.5em;FONT-FAMILY: Arial;}TD { FONT-SIZE: 12px; MARGIN: 1.2em 0px; LINE-HEIGHT: 1.5em;FONT-FAMILY: Arial;}MySql 命令应用原创 2006-05-13 16:01:00 · 1173 阅读 · 0 评论 -
SQL 常用语句
1. 查找员工的编号、姓名、部门和出生日期，如果出生日期为空值，显示日期不详,并按部门排序输出,日期格式为yyyy-mm-dd。 select emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),’日期不详’) birthday from employee order b原创 2008-07-18 09:06:00 · 1016 阅读 · 0 评论 -
SQL多表查询与case when .. else .. end as ..,group by.. having
select * from A ,(select * from B) C where A.id=B.aidselect case when A is null then 0 else A end as BSELECT user_idFROM user_remain GROUP BY user_idHAVING count( user_id ) >1原创 2008-08-06 08:42:00 · 1355 阅读 · 0 评论