转义字符\a的使用__2018.06.16

SET @sql = NULL; SELECT JSON_ARRAYAGG( CONCAT('MAX(CASE WHEN td.person_name = ''', person_name, ''' THEN td.work_time ELSE NULL END) AS ''', person_name, '''') ) INTO @sql FROM ( SELECT DISTINCT t2.person_name FROM task1 t1 INNER JOIN t_ps_person_work_time t2 ON t1.id = t2.task_id WHERE t2.work_day BETWEEN '2025-06-26' AND '2025-07-25' AND t2.status = 0 ) t; -- 更精确地移除JSON数组格式 SET @sql = TRIM(BOTH '[""]' FROM @sql); SET @sql = REPLACE(@sql, '","', '", "'); -- 可选，如果需要处理中间部分 -- 或者更简单的方式（如果只有两个元素）： SET @sql = REPLACE(REPLACE(@sql, '"', ''), ',', ', '); SET @sql = REPLACE(@sql, '[', ''); SET @sql = REPLACE(@sql, ']', ''); WITH task_data AS ( -- 获取任务和人员工时数据 SELECT t3.task_num , t3.project_name , (SELECT dict_label FROM `js_sys_dict_data` WHERE dict_type = 'sys_project_type' AND dict_value = t3.project_type) project_type, t1.duty_person person_name, ROUND(SUM(t2.work_time), 1) work_time, t2.work_day workDay FROM project t3 INNER JOIN task1 t1 ON t3.id = t1.project_id INNER JOIN ( SELECT person_name, task_id, work_time, DATE_FORMAT(work_day, '%Y-%m') work_day FROM t_ps_person_work_time WHERE work_day BETWEEN '2025-06-26' AND '2025-07-25' AND `status` = 0 ORDER BY work_day ) t2 ON t1.id = t2.task_id WHERE t3.status = 0 AND t1.status = 0 GROUP BY t3.id,t1.person_code ORDER BY t3.task_num ) -- 动态透视表查询 SET @sql = CONCAT('SELECT td.task_num AS "任务书号", td.project_name AS "项目名称", td.project_type AS "项目类型", ROUND(SUM(td.work_time), 1) AS "项目工时", ', @sql, ' FROM task_data td GROUP BY td.task_num ORDER BY td.task_num'); -- 现在，@sql中存储了动态生成的SQL字符串 -- 使用预处理语句执行 PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; 我这样修改，> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @sql = CONCAT('SELECT td.task_num AS "任务书号", td.project_name A' at line 29出现这个错误

C:\Users\ESD\AppData\Local\Programs\Python\Python311\python.exe C:/Users/ESD/Desktop/文件夹集合/大三作业集合/大三下学期/爬虫.py Traceback (most recent call last): File "C:\Users\ESD\Desktop\文件夹集合\大三作业集合\大三下学期\爬虫.py", line 25, in <module> data = json.loads(data_json) ^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\ESD\AppData\Local\Programs\Python\Python311\Lib\json\__init__.py", line 346, in loads return _default_decoder.decode(s) ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\ESD\AppData\Local\Programs\Python\Python311\Lib\json\decoder.py", line 337, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\ESD\AppData\Local\Programs\Python\Python311\Lib\json\decoder.py", line 353, in raw_decode obj, end = self.scan_once(s, idx) ^^^^^^^^^^^^^^^^^^^^^^ json.decoder.JSONDecodeError: Unterminated string starting at: line 42 column 20 (char 191774)import re import json import requests # 请求网址 url = 'https://www.1688.com/zw/page.html?hpageId=old-sem-pc-list&scene=2&keywords=%E5%B7%A5%E4%B8%9A%E5%88%B6%E5%93%81&cosite=bingjj&trackid=8852322103055964474091522&format=normal&location=landing_t4&m_k=82052398705830&m_a=1312819330609664&m_p=521766597&m_clk=f5e5475468561b1155b720b06b1e5722&m_c=82051440439213&m_q=%E5%B7%A5%E4%B8%9A%E5%88%B6%E5%93%81&m_mt=be&m_ep=e&m_o=82052398705830&m_site=o&d27=c&m_cext=&m_aud=kwd-82052398705830%3Aloc-39&msclkid=f5e5475468561b1155b720b06b1e5722&sortType=&descendOrder=&province=&city=&priceStart=&priceEnd=&dis=&provinceValue=%E6%89%80%E5%9C%A8%E5%9C%B0%E5%8C%BA&p_rs=true&exp=pcSemFumian%3AC%3BpcDacuIconExp%3AB%3Bqztf%3AE%3Bwysiwyg%3AB%3BpcSemWwClick%3AA%3Basst%3AD&ptid=hr189698f670f996&spm=a312h.2018_new_sem.dh_004.submit' # 伪造请求头 headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36' } # 发送请求 response = requests.get(url, headers=headers) # 检查请求是否成功 if response.status_code == 200: # 使用正则表达式查找 JavaScript 数据 data_pattern = r'var pageConfig = (.*?);' data_match = re.search(data_pattern, response.text, re.DOTALL) if data_match: # 提取并解析 JSON 数据 data_json = data_match.group(1) data = json.loads(data_json) # 检查是否存在 listOffer 字段 if 'listOffer' in data: # 遍历每个商品信息 for item in data['listOffer']: # 提取商品的关键信息 company = item.get('company', '') product_name = item.get('subject', '') price = item.get('price', '') sale_volume = item.get('saleVolume', '') product_url = item.get('odUrl', '') # 打印商品信息 print(f'公司: {company}') print(f'产品名称: {product_name}') print(f'价格: {price}') print(f'销量: {sale_volume}') print(f'产品链接: {product_url}') print('-' * 50) else: print("未找到商品信息") else: print("未找到页面配置数据") else: print(f"请求失败，状态码: {response.status_code}")