Newer
Older
huludao / sql-script / 20240726.sql
ALTER TABLE huludao_main.led_info ADD status varchar(16) NULL COMMENT '状态(1:在线,0:离线)';
ALTER TABLE huludao_main.led_info CHANGE status status varchar(16) NULL COMMENT '状态(1:在线,0:离线)' AFTER y;
UPDATE huludao_main.led_info
SET led_no='1209040093,1209040076', led_name='海航路铁路立交桥内涝点', led_address='海航路铁路立交桥内涝点', x='120.865163526712', y='40.7505566730951', status='1', create_time='2021-01-06 19:33:19'
WHERE id=3;
UPDATE huludao_main.led_info
SET led_no='1209040083,1206030056', led_name='锦葫路铁路立交桥内涝点', led_address='锦葫路铁路立交桥内涝点', x='120.858389994382', y='40.7454162441688', status='1', create_time='2021-01-06 19:33:19'
WHERE id=6;
UPDATE huludao_main.led_info
SET led_no='1209040068,1209040069', led_name='海航路锦葫路公路立交桥内涝点', led_address='海航路锦葫路公路立交桥内涝点', x='120.869335515009', y='40.7405383491069', status='0', create_time='2021-01-06 19:33:19'
WHERE id=7;
UPDATE huludao_main.led_info
SET led_no='1209040086,1209040082', led_name='龙程北街铁路立交桥内涝点', led_address='龙程北街铁路立交桥内涝点', x='120.890518666613', y='40.7426411977708', status='1', create_time='2021-01-06 19:33:19'
WHERE id=9;