Tag Archives: MySQL

MySQL is (as of 2008) the world’s most widely used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It is named after co-founder Michael Widenius’ daughter, My. The SQL phrase stands for Structured Query Language.


Tutorials – Filter Rows Using MySQL WHERE

Summary: you will learn how to use MySQL WHERE clause to filter rows that return from the SELECT statement. If you use the SELECT statement without the WHERE clause, you will get all the rows in a database table, which is a lot more information than you need. The WHERE clause allows you to specify […]


Tutorials – Managing Database Index

Summary: in this tutorial, you will learn how to work with MySQL index and how to take advantages of  MySQL index to speed up the data retrieval. We will introduce several SQL statements to allow you to manage MySQL index. Database index, or just index, helps speed up the retrieval of data from tables. When you […]


Tutorials – Manage Database in MySQL

Summary: in this tutorial, you will learn how to manage databases in MySQL. You will learn how to create a new databases, remove databases from database catalog and display all databases in the MySQL database server. Let’s start creating a new database in MySQL. Creating Database Before doing anything else with the data, you need to […]


Tutorials – MySQL Data Types

Summary: In this tutorial, you will learn various MySQL data types to use them effectively in database table design. Database table contains multiple columns with specific data types such as numeric or string. MySQL provides you many more specific data types than just “numeric” or “string”. Each data type in MySQL can be determined by the […]


How To – Quickly and Easily Increase WordPress Security

Sometimes you encounter a tip which is so simple you can’t believe you didn’t know about it before. If you’re running WordPress, you’ll have defined a wp-config.php file which contains essential settings such as the MySQL database host, name, user and password. It normally sits in the location where WordPress was installed — in most […]


WordPress Database Functions

The WordPress database class is quite extensive and provides a range of methods to work effectively with the database and thereby use the WordPress standard. You can find the class in /wp-includes/wp-db.php where the individual methods are documented. I show the most important ones and give some small examples. It is important to work with […]


Delete all Feed Cache via SQL in WordPress

The Feed-Cache of WordPress is in the database, it’s in the table options and sometimes you like to delete it. With a little SQL this is done quite quickly – but be careful, there is no way back! Within WordPress I do it with the help of the Plugin Adminer, which allows a complete mySQL […]