![]() |
VOOZH | about |
By Morgan Tocker and Sharon Campbell
Thanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases.
Current fan and former Editorial Manager at DigitalOcean. Hi! Expertise in areas including Ubuntu, Docker, Rails, and more.
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!
Another one - missing default values on int
CREATE TABLE test (
id int,
weight int NOT NULL
);
Previous behavior:
INSERT INTO test (id) VALUES (1);
Query OK, 1 row affected, 1 warning (0.00 sec)
MySQL 5.7:
INSERT INTO test (id) VALUES (1);
Error Code: 1364. Field 'weight' doesn't have a default value
Re: β5) Using GROUP BY and selecting an ambiguous columnβ
Please update the example to include the correct Group By syntax in 5.7
Or just add to config:
[mysqld]
sql_mode = ""
and forget all this βDegradationβ
There are issues in diagnostic SQL queries in article: Please correct to β>β instead of
>
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.