SELECT * from cb_shebei where sbxlh='NA220702341'

-- 查询有email的用户
SELECT * FROM cb_shebei_neicun WHERE shebei_id IS NOT NULL;

-- 查询email为空的用户
SELECT * FROM cb_shebei_neicun WHERE shebei_id IS NULL;
-- 查询表中所有记录的总条数
SELECT COUNT(*) AS total_rows FROM cb_shebei_neicun;

SELECT 
  shebei_id,  -- 要统计的目标字段
  COUNT(*) AS record_count  -- 统计每个shebei_id对应的记录数，起别名为record_count
FROM cb_shebei_neicun  -- 替换为实际表名
WHERE 【指定条件】  -- 可选，用于过滤原始数据（如时间范围、状态等）
GROUP BY shebei_id  -- 按shebei_id分组，统计每个设备的记录数
HAVING record_count > 32;  -- 筛选记录数大于32的shebei_id

SELECT * from cb_shebei_neicun where shebei_id=561
---插入数据初始化
INSERT INTO cb_shebei_neicun (zhupin, daxiao,shebei_id)
SELECT '2933', '64',561
FROM information_schema.tables
LIMIT 32;