MySQL introduction
Part of LAMP. One of the most powerful SQL servers out there is called MySQL and surprisingly enough, its free. Yes, free. I now use this instead of MS Access, Filemaker or FoxPro (lol). However, since Oracle is now the owner of MySQL, there is a fork of MySQL now gaining popularity called MariaDB which want to keep the project as open as possible.
Some of the features of MySQL Include: Handles large databases, in the area of 50,000,000+ records. No memory leaks. Tested with a commercial memory leakage detector (purify). A privilege and password system which is very flexible and secure, and which allows host-based verification.
Getting the last row of a query | 7 Sep 2023
peewe basic and join queries | 25 Aug 2023
peewee Python ORM to connect to MySQL | 23 Aug 2023
List table columns in MySQL database | 19 May 2023
Getting first row data without while loop | 19 Oct 2022
Incorrect integer value: '' for column 'id' SQL error | 10 Jan 2022
Python replace string to insert MySQL | 08 Jul 2021
Connect MySQL with pymysql | 27 May 2021
Start a django website using MySQL | updated 12 April 2023
Django settings.py | 23 April 2021
Install MySQLclient using pip | 06 April 2021
Create XML child and subchild from MySQL | 09 Feb 2021
Changing Mysql root password in Ubuntu Server 22.04 after install | updated 20 Jan 2023
SET @last_id = LAST_INSERT_ID(); | 7 Aug 2020
Displaying european chars and encoding JSON | 22 Oct 2018
LEFT JOIN and group | updated 21 Apr 2023
Changing your MySQL password validation level | 16 Aug 2018
Check if exist or not = mysqli_num_rows() empty and counting | updated on 5 Oct 2022
Basic DB connect, update and insert to MySQL. Updated for PHP7 | Updated 11 August 2020
LAMP finetuning | 24 March 2017
Exporting to excel | 22 Nov 2016
PHP libraries | 3 September 2014
Change MySQL root Password when you lost it | 31 March 2014
Basic Mysql commands | 4 March 2014
Install MySQL workbench on Ubuntu | 10 December 2012
Simplest way to add timestamp with PHP MYSQL | 10 October 2012
addslashes for input to mysql | 10 October 2012
Sample SQL query select and join | 23 August 2012
Copy Sync MySQL database with a single command | 07 July 2012
com.mysql.jdbc.driver missing Base | 27 June 2012
Install LAMP to Ubuntu | 10 March 2012
Make MySql data portable, adjusting AppArmor | 2 December 2010
Ubuntu allow Mysql connection access from outside | 25 June 2010
MySQL file locations and log | updated 29 July 2020
change MySQL root password | 13 October 2009
Apache MySQL restart stop in Ubuntu, Debian and Redhat | updated 11 August 2023
MySQL dump | 8 October 2009
mysql_query customizing | 08 June 2009
MySQL data types | 11 April 2009
Search a MySQL database and return paged results with PHP | 11 April 2009
