完整代码: $sql = "select SUM(a.should_paid) AS totalPays,a.id,a.leader_id,b.userid,b.name,c.order_id,c.status from " . $db->table('orders'); switch ($CR_days) { case -1; $sql .= " AND TO_DAYS(curdate()) - TO_DAYS
public function getDevice() { global $db, $res; dbc(); $sql = "select COUNT(imei) AS total,COUNT(CASE state WHEN '1' THEN 1 END) AS highState,COUNT(CASE state WHEN '-1' THEN -1 END) AS lowState,COUNT(CASE state WHEN '0' THEN ...
CREATE TABLE `jk_data` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据ID主键', `jk_date` datetime NOT NULL COMMENT '时间日期格式', `jk_time` int(11) DEFAULT NULL COMMENT 'Unit格式的时间', `jk_sn` varchar(20) DEFAULT NULL COMMENT '设备序列号SN', `jk_counter` int
见:《MySQL实战基础知识入门(10):今天、昨天、近7天、近30天在一个筛选语句内实现的解决方案》上文是时间段的数据合计统计;见《MySQL实战基础知识入门(3):近7日销量合计php后端mysql语句如果当日为空则自动补0的解决方案》上文是最近七日每日的分别统计。如果只是为了7天,写那么字段也就算了。但是遇见了统计30天内每天的数据时,是不是哭了呢?新的MYSQL筛选语句: $sql = "select DATE_FORMAT(a.paid_at,'%Y-%m-%d') .
public function getData() { global $db, $res; dbc(); //分组序列号; $jk_sn = "6910001582"; //当日分区数据; $partName = get_param("partName"); if (empty($partName)) { //$partName = "jk_data" . date("Ymd"); $partName = "jk_data20201113"; } $sql.
public function getEveryDay() { global $db, $res; dbc(); $NowTimes = date("Y-m-d", time()); $sql = "select DATE_FORMAT(paid_at,'%Y-%m-%d') as dataKey,ifnull(COUNT(id),0) AS totalTrans,ifnull(SUM(should_paid),0) AS t...
//刷队列,取数据 while (true) { $msg = code(trim(rand(2, 60))); var_dump(trim($msg)); sleep(5); socket_write($msgsock, $msg, strlen($msg)); }Done!
mysql直接通过phpmyadmin导入csv文件excle编辑好文件,需要日期和时间类型,必须是两位数;保存csv后,需要用记事本打开,再次另存为"utf-8"编码,默认保存的是ANSI编码;phpmyadmin选择“CSV using LOAD DATA”格式;字段分隔符和CSV文件一致;Done!...
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号