03 2014 档案
摘要：public static Long getDaysBetween(long startDate, long endDate) { Calendar fromCalendar = Calendar.getInstance(); fromCalendar.setTimeInMillis(startDate); fromCalendar.set(Calendar.HOUR_OF_DAY, 0); fromCalendar.set(Calendar.MINUTE, 0); fromCalendar.se...
阅读全文
摘要：查看event是否开启: show variables like '%sche%'; 将事件计划开启: set global event_scheduler=1; 关闭事件任务: alter event e_test ON COMPLETION PRESERVE DISABLE; 开户事件任务: alter event e_test ON COMPLETION PRESERVE ENABLE; 简单实例. 创建表 CREATE TABLE test(endtime DATETIME); 创建存储过程test CREATE PROCEDURE test () BEGIN ...
阅读全文
摘要：排序select * from content order by 字段一 asc ,字段二 asc,字段三 desc想多少字段都行,样式如上！其中：asc或desc（即升级或降序)自动递增重置为1alter table **** AUTO_INCREMENT=1 插入一条记录，并使某个字段的值为自动递增值INSERT into userjjc(rank) VALUES (0);UPDATE userjjc SET rank = LAST_INSERT_ID() WHERE uid=LAST_INSERT_ID();多表关联查询select userjjc.* from userinfo,us.
阅读全文
摘要：需要的工具1.Eclipse2.JDK3.exe4j4.Eclipse附加插件windowsBuilder ：百度直接搜去eclipse官网下exe4j配置：http://xiejianglei163.blog.163.com/blog/static/124727620138931213864/对话...
阅读全文
