April 21, 2022 in MySql
A database is represented by a directory under the data directory (usually /var/lib/mysql), and the directory is intended for storage of table data. The DROP DATABASE statement will remove all table files and then remove the directory that represented the database. It will not, however, remove non-table files, whereby making it not possible to remove the directory. MySQL […]
April 21, 2022 in MySql, Tips and Tricks
1101 – BLOB, TEXT, GEOMETRY or JSON column ‘answer’ can’t have a default value Probably your development environment allows the defaults and the production environment doesn’t. You can either upgrade your production system or not use that feature. How to disable strict mode in MySQL 5 (Windows): Edit /my.ini and look for linesql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” Replace it […]
April 15, 2022 in MySql, Tips and Tricks
MySQL/MariaDB related: wait_timeout – Time in seconds that the server waits for a connection to become active before closing it. interactive_timeout – Time in seconds that the server waits for an interactive connection. max_allowed_packet – Maximum size in bytes of a packet or a generated/intermediate string. Set as large as the largest BLOB, in multiples of 1024. Example […]
February 24, 2022 in Laravel, MySql, Tips and Tricks
They do the SQL DATE() work for you, and manage the differences of SQLite. Your result can be achieved as so: Though the above method is convenient, as noted by Arth it is inefficient on large datasets, because the DATE() SQL function has to be applied on each record, thus discarding the possible index. Here are some ways to […]
November 3, 2021 in MySql, Technology
Digitalocean DigitalOcean is a values-driven organization. Here is what we believe in. Our community is bigger than just us We foster the global developer and entrepreneurial communities because they are the source of our ideas and innovation and essential to our sustained growth. Simplicity in all we DO We make decisions that eliminate complexity and […]
September 28, 2021 in MySql, Tips and Tricks
Without pluck With pluck
August 11, 2021 in Laravel, MySql, Php, Tips and Tricks
config/database.php
