Search for a command to run...
Articles tagged with #mysql
Originally published at recca0120.github.io JOIN two tables on a nullable column and the rows disappear. Insert two NULLs into a UNIQUE column and neither insert fails. Both problems share the same root: SQL defines NULL as unknown, and unknown is ne...
Originally published at recca0120.github.io DBngin lets you run multiple versions of MySQL, PostgreSQL, and Redis simultaneously. However, since it supports multiple versions, it doesn't automatically add the mysql executable to your PATH. Running my...
Originally published at recca0120.github.io When running artisan migration, you encounter the Unknown database type enum requested error. Cause Laravel's migration uses Doctrine DBAL under the hood, and Doctrine DBAL doesn't recognize MySQL's enum ty...
Originally published at recca0120.github.io MySQL and SQLite often use different function names for the same functionality -- for example, MySQL's IF() requires CASE WHEN in SQLite. Laravel 10's new Database Expression feature handles this elegantly....