松材-SQL

– 查询所有林班信息
SELECT * FROM wood_class WHERE class_depth = “1”
select class_id,class_fence from wood_class WHERE class_depth = 1 LIMIT 1

– 根据区域id
SELECT * FROM wood_class WHERE class_area_id = “1693549418305208321”

– 根据班级名称
SELECT * FROM wood_class WHERE class_name = “027” AND class_depth = “1”

– 根据班级id
SELECT * FROM wood_class WHERE class_id LIKE ‘%14206040%’ AND class_depth = “3”
SELECT * FROM wood_class WHERE class_id LIKE ‘%350782101212111%’
SELECT * FROM wood_class WHERE class_id = “350782003002068”

– 查询没有围栏信息的小班
SELECT * FROM wood_class WHERE class_fence is NULL AND class_depth = “3”
SELECT * FROM wood_class WHERE class_fence like “%null%”
SELECT * FROM wood_class WHERE class_fence is NULL AND class_depth = 1

– 查询没有中心点的林班
SELECT * FROM wood_class WHERE class_lng is NULL AND class_depth = 1
SELECT * FROM wood_class WHERE class_depth = “1” AND class_id LIKE ‘%350782204209%’

SELECT * FROM wood_class WHERE class_depth = “1” AND class_id LIKE ‘%350782101212111%’

SELECT * FROM wood_class WHERE class_depth = “1” AND class_id = ‘350782689001619’
SELECT * FROM wood_class WHERE class_depth = “1” AND class_id = ‘350782101214619’

SELECT * FROM wood_class WHERE class_depth = “1” AND class_id LIKE ‘%111’
SELECT * FROM wood_class WHERE class_depth = “1” AND class_id LIKE ‘%674’

SELECT * FROM wood_class WHERE class_lng is NULL AND class_depth = 1 AND class_area_id = ‘1696455466234040322’

– 查询没有中心点的小班
SELECT * FROM wood_class WHERE class_lng is NULL AND class_depth = “3”

– 更新林班中心点
UPDATE wood_class SET class_lng = 2,class_lat = 2 WHERE class_id = ‘350723101204121’

– 查询二维码
SELECT * FROM wood_card WHERE card_qrcode = ‘01-0106’

– 更新二维码
UPDATE wood_card SET card_status = 0 WHERE card_status is NULL

UPDATE wood_card SET card_status = 0 WHERE card_qrcode = ‘01-0104’

– INSERT INTO ktt-scxc.wood_class (
– class_id,
– class_smallid,
– class_name,
– class_depth,
– class_pid,
– class_pmask,
– class_street_id,
– class_hamlet_id,
– class_fence,
– class_area_id,
– class_lng,
– class_lat,
– create_by,
– create_time,
– update_by,
– update_time
– )
– VALUES
– (
– ‘35078200300299911666’,
– ‘99911666’,
– ‘666’,
– ‘3’,
– ‘35078200300299911’,
– ‘350782003002999-35078200300299911-‘,
– NULL,
– NULL,
– ‘[]’,
– NULL,
– ‘117.971663266946’,
– ‘27.6367134139929’,
– ‘admin23091301’,
– NOW(),
– ‘admin23091301’,
– NOW()
– );