Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

Question

Data truncation: Data too long for column 'content' at row 1 Query

Posted March 28, 2021 310 views
Databases

database mysql8

How to set SQL MODE fix this error?

-
MySQL will truncate any insert value that exceeds the specified column width.
to make this without error try Switch your MySQL mode to not use STRICT.

意思大概是MySQL将截断超过指定列宽度的任何插入值。为了让这个不报错，你可以尝试切换你的MySQL模式不使用严格模式。

Add a comment
imagine10255
By:
imagine10255

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
Anadi May 3, 2021

Hi there,

You can set the SQL mode by finding the cluster on the Databases page -> click the cluster’s name -> Settings tab - > Global SQL mode -> Edit button -> from the drop-down menu select the SQL mode you want to modify

Save to persist the change or cancel to revert.

The link provides more information on how to set global SQL mode on MySQL clusters.

https://www.digitalocean.com/docs/databases/mysql/how-to/set-sql-mode/

Hope that this helps!
Regards,
Anadi

Reply Report

Related

Looking for something else?

Ask a new question Search for more help