PHP+mysql查詢報錯:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'order_no' at row 1
PHP查詢mysql時,報錯SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'order_no' at row 1,
表示字段order_no寫入的數據長度太長,而字段order_no設置的長度不夠,檢查字段order_no;發現長度設置只有11,

解決方法:
修改字段長度為255,保存即可!

浙公網安備 33010602011771號