By imagine10255
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模式不使用严格模式。
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.