MySQL
Rietta's MySQL posts cover resetting a root password, choosing the decimal data type, and storing currency correctly.
Subscribe to MySQL posts via RSS
10/24/2019
MySQL Decimal Data Type
by Alex Piechowski
The MySQL decimal (A.K.A. numeric) data type stores exact values with a fixed point decimal. The syntax of MySQL's decimal is "DECIMAL(precision, scale)".
06/04/2019
Best Data Type to store Money in MySQL?
by Alex Piechowski
MySQL has no MONEY type. Use DECIMAL(13,2) for most currency, or DECIMAL(13,4) when GAAP compliance needs four places, and see the max value each can hold.
02/11/2014
Reset MySQL Root Password with One Command
by Frank Rietta
One simple command to reset your MySQL root password on Debian/Ubuntu Linux. Don't overthink this one.