An Overview of using algorithm setting to modify MySQL table MySQL data definition language Operations
Category: Database
MYSQLI on PHPStorm Build In Web Server
PHPStorm has a build-in web server running at default port 63342. It works fine in general browser files such as
Laravel Factory and Seeder
Follow the steps below to seed a database with sample data: Make factory associated with a table: php artisan make:factory
MariaDB Abort Due To Failed to Initialize Multi Master Structures
I am running 10.4.11 MariaDB Recently, My XAMPP controller failed to start MySQL (MariaDB). I got the following error: Error:
How to use ediimport
Ediimport is a Foxpro program that automatically insert corrected ADX 850 (EDI order) export to SBT databases. Ediimport.prg and application
Unicode choice for MYSQL database
A very good post on stackoverflow. My’s sticking with utf8mb4_general_ci for general tables (better performance) : https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci Note: DOLIBARR uses utf8mb4_unicode_ci. Since
MYSQL Cheat Sheet
To dump all data in a database mysqldump –host=”hostname” –user=”username” –password=”password” databasename > backup_name.sql To reset auto-increment field in a
PSQL tips on Windows
To resolve charset conflict error between utf8 and WIN1252, do the following before any further command are issued in PSQL:
Postgresql Related Notes
If you’ve installed postgresql using the installer, it typically sets the service to start automatically when Windows is started. To
PHP with Postgresql
If PHP is installed as part of XAMPP, it will work with MySQL/MariaDB with no additional change. However, to work