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.

mysql-where-simple

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 […]

Index-300x225

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 […]

show-database

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 […]

Datatypes

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 […]

Security-image

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 […]