Data truncated for column 'PHOTO_URL_A' at row 1
时间: 2023-11-01 18:22:10 浏览: 103
在你的问题中,引用[1]和引用都提到了一个错误,即pymysql.err.DataError: (1406, "Data too long for column 'songlist_url' at row 1")。这个错误指示在插入数据时,'songlist_url'列的值超过了指定的列宽。而引用提到,MySQL会截断任何超过指定列宽的插入值。
因此,对于你的问题,如果在插入数据时,'PHOTO_URL_A'列的值超过了指定的列宽,MySQL会截断该值。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* *3* [mysql报错:1406, "Data too long for column](https://blog.csdn.net/weixin_42131798/article/details/114858532)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]
阅读全文