摘要:
SELECT licensePlate, SUM( CASE WHEN inOrOut = 'in' THEN 1 ELSE 0 END ) AS 'incount', SUM( CASE WHEN inOrOut = 'out' THEN 1 ELSE 0 END ) AS 'outcount' 阅读全文
摘要:
/*Navicat MySQL Data Transfer Source Server : localhost_3306Source Server Version : 50505Source Host : localhost:3306Source Database : kamanage Target 阅读全文
摘要:
mysql 的存储过程 一、准备工作 新建一个表 /*Navicat MySQL Data Transfer Source Server : localhost_3306Source Server Version : 50505Source Host : localhost:3306Source D 阅读全文