SQL实例

SQL UPDATE语句(更新表中已存在的记录)SQL UPDATE语法UPDATE table_name -- 要修改的表名称 SET column1value1, colunm2value2, -- 要修改的字段 WHERE condition -- 修改条件UPDATEdevice_recordSETbusiness_id1002850,codeD71002850--serialREPLACE(serial,D71002850,D71002849)wherebusiness_id1002849ANDcharge1SQL DELETE语法DELETE FROM device_record WHEREbusiness_id001AND crru_date2026-08-06 00:30:00AND crru_date2026-08-06 01:00:00SQL 记录插入语法INSERT IGNORE INTO device_record(business_id,crru_date,monitor_data)VALUES(001,2026-08-06 00:06:00,[{probeIndex:0,alarm:1,temperature:9.7,humiAlarm:0,humidity:96.2}])