xdmy/doc/elec/tst.sql

-- SELECT
--     m.id,
--     DATE_FORMAT(m.endDate,  '%Y-%m-%d'),
--     m.endAmount,
--     m.Multiple 
--     -- INTO measureIdS,
--     -- measureDateS,
--     -- measureAmountS,
--     -- rates
-- FROM
--     measure m
--     left JOIN electricity w ON w.measureId = m.id
-- WHERE
--     m.meterNumber = '02.01'
--     AND m.meterType = '电表'
--     and m.meterName = '牛舍'
--     and m.pastureId = 52
--     AND m.isDel = '0';
-- 牧场,表名称,表编号,上次抄表日期,上次值,
-- 抄表日期,用量,本次值,单价,录入人,
-- 备注
-- (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
-- 塞一牧场	牛舍	02.01	2022-6-5	12891.8  	2022-7-1	3550.2	3550.2	0.33	周志国
-- 消毒室 02.14
--  call insert_electricity
-- (
-- '塞一牧场',
-- '消毒室',
-- '02.14',
-- '2022-06-05',
-- '12891.8',
-- '2022-07-01',
-- '185',
-- '3238.2',
-- '0.33',
-- '周志国',
-- '',
-- '');
-- call insert_electricity 
-- (
-- '塞一牧场',
-- '牛舍',
-- '02.01',
-- '2022-06-05',
-- '12891.8',
-- '2022-07-01',
-- '12891.8',
-- '12891.8',
-- '0.33',
-- '周志国',
-- '',
-- ''
-- );
-- SELECT * from electricity where date = '2022-07-01';
-- show create table electricity;
-- show index from electricity;
-- SELECT id from measure limit  10;
SELECT sqlstr from apisql where sqlname ='importDiesel';
show create PROCEDURE importDiesel;
-- SELECT measureid  from electricity 
-- where pastureId =52
-- order by date desc limit 10;
-- drop PROCEDURE if exists `eq`.`importDiesel`;