Using PHP-MySQL Persistent Connections to Run WordPress Blog
When connecting to MySQL database, WordPress weblog based on PHP scripting will use non-persistent connection by default. That [...]
Free Web Hosting with PHP Support
A web host or web server enables webmaster to publish his or her website and webpages to the [...]
How to Backup and Restore (Export and Import) MySQL Databases Tutorial
phpMyAdmin can be used to export or backup MySQL or MariaDB databases easily. However, if the database size [...]
MySQL Error 1170 (42000): BLOB/TEXT Column Used in Key Specification Without a Key Length
When creating a new table or altering an existing table with primary keys, unique constraints and indexes, or [...]
Remove or Trim First or Last Few Characters in MySQL Database with SQL
Another useful string function in MySQL database is TRIM() which will return a text string after removing the [...]
How to Find and Replace Text in MySQL Database using SQL
MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string [...]
Duplicate, Copy or Backup Tables in MySQL, MariaDB, Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL
In Oracle, PostgreSQL, DB2, MySQL, MariaDB and SQLite database system, there is a nice command feature called Create [...]
Change or Set MySQL Long Query Time Value for log-slow-queries
If you enable slow queries log of MySQL database server, you will notice that from the slow query [...]
Enable Logging of Slow Queries (Slow Query Log) in MySQL Database
One of the main requirements for a fast web server is to has efficient and effective SQL statements [...]
WordPress MySQL SQL Query Error in WPDB Class
WordPress plug-ins users or external scripts developers may encounter problems on when trying to perform query or manipulation [...]