一个复杂的mysql查询语句(case,when,then,left join )
select `a`.`id` AS `id`,`a`.`UserName` AS `UserName`,
(case when (`a`.`sRegDate` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`sRegDate`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `sRegDate`,(case when (`a`.`feeendtime` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`feeendtime`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `feeendtime`,
(case when (`a`.`iStatus` = _utf8'0') then _utf8'正常' when (`a`.`iStatus` = _utf8'1') then _utf8'锁定' when (`a`.`iStatus` = _utf8'2') then _utf8'欠费' when (`a`.`iStatus` = _utf8'') then _utf8'申请停机' else _utf8'' end) AS `iStatus`,
(case when (`a`.`PayType` = _utf8'0') then _utf8'免费' when (`a`.`PayType` = _utf8'2') then _utf8'小区网用户' when (`a`.`PayType` = _utf8'10') then _utf8'外部用户' else _utf8'' end) AS `PayType`,
`c`.`UserType` AS `sDh1`,`b`.`FeeName` AS `iFeeType`,
(case when (`a`.`PauseStartTime` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`PauseStartTime`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `PauseStartTime`,
(case when (`a`.`PauseStopTime` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`PauseStopTime`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `PauseStopTime`,
(case when (`a`.`AcctStartTime` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`AcctStartTime`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `AcctStartTime`,
(case when (`a`.`AcctStopTime` = _utf8'1990-01-01 00:00:00.0') then _utf8'' else cast(date_format(`a`.`AcctStopTime`,_utf8'%Y-%m-%d %H:%i:%S') as char charset utf8) end) AS `AcctStopTime`,
`a`.`speed` AS `speed`,
(case when (`a`.`idtype` = _utf8'7') then _utf8'身份证' when (`a`.`idtype` = _utf8'1') then _utf8'教职工' when (`a`.`idtype` = _utf8'2') then _utf8'本科生' when (`a`.`idtype` = _utf8'3') then _utf8'研究生' when (`a`.`idtype` = _utf8'4') then _utf8'离退生' when (`a`.`idtype` = _utf8'5') then _utf8'
相关文档：
1. 给root加密码：/usr/bin/mysqladmin -u root password 123456
2. 导出：mysqldump -u root -p dbname > file.sql
3. 导入：mysql -u root -p dbname < backup-file.sql
4. 授权：grant all on *.* to root@"%" identified by "密码";
5. 收回权限：revoke all privileges on *.* from root@"%";
6. 登录：mys ......
写入时，先做encode：
public static String encode(String src) {
String result = null;
try {
result = new String(src.getBytes("gbk"), "ISO-8859-1");
} catch (UnsupportedEncodingException uee) {
System.err.println(uee);
}
return result;
}
读出时，再做decode：
public static String deco ......
一直想写点东西，但却迟迟没有开始，今天无意中回到ERP100这个网站，发现有了QAD的专区，于是，一时热血沸腾，写了点东西，就借此机会将内容也发到这里吧，呵呵。
其实内容都是本人写的，不过为了图方便，在ERP100中写完了，然后直接Copy到这里，偷了点懒，呵呵。
以下是正文，在ERP100中的地址是
http://bbs.erp100.com ......
mysql的 find_in_set函数使用方法
很多时候我们在设计数据库时有这种情况,比如:
有个文章表里面有个type字段,他存储的是文章类型,有 1头条,2推荐,3热点,4图文 .....11,12,13等等
现在有篇文章他既是 头条,又是热点,还是图文,
type中以 1,3,4的格式存储.
那们我们如何用sql查找所有type中有4图文标准的文章呢 ......
关于MySql的导入导出问题
在终端中，进入mysql的路径下的bin中，在这个路径下可以执行mysql，mysqldump等命令。
或者添加环境变量 设置环境变量path "...(mysql的安装路径下的bin目录)"，这样就不必每次都进入上面所说的路径下操作。
导出一个库：
mysqldump ......
