Category Archives

MySQL – INDEXES

A database index is a data structure that improves the speed of operations in a table. Indexes can be...

MySQL – INDEXES

A database index is a data structure that improves the speed of operations in a table. Indexes can be...

MySQL – Temporary Tables

The temporary tables could be very useful in some cases to keep temporary data. The most important thing that...

MySQL – Temporary Tables

The temporary tables could be very useful in some cases to keep temporary data. The most important thing that...

MySQL – Regexps

You have seen MySQL pattern matching with LIKE ...%. MySQL supports another type of pattern matching operation based on...

MySQL – Regexps

You have seen MySQL pattern matching with LIKE ...%. MySQL supports another type of pattern matching operation based on...

MySQL – Transactions

A transaction is a sequential group of database manipulation operations, which is performed as if it were one single...

MySQL – Transactions

A transaction is a sequential group of database manipulation operations, which is performed as if it were one single...

MySQL – Sorting Results

We have seen the SQL SELECT command to fetch data from a MySQL table. When you select rows, the...

MySQL – Sorting Results

We have seen the SQL SELECT command to fetch data from a MySQL table. When you select rows, the...

Using MySQl Joins

In the previous chapters, we were getting data from one table at a time. This is good enough for...

Using MySQl Joins

In the previous chapters, we were getting data from one table at a time. This is good enough for...

Handling MySQL NULL Values

We have seen the SQL SELECT command along with the WHERE clause to fetch data from a MySQL table,...

Handling MySQL NULL Values

We have seen the SQL SELECT command along with the WHERE clause to fetch data from a MySQL table,...

MySQL – DELETE Query

If you want to delete a record from any MySQL table, then you can use the SQL command DELETE...

MySQL – DELETE Query

If you want to delete a record from any MySQL table, then you can use the SQL command DELETE...

MySQL – LIKE Clause

We have seen the SQL SELECT command to fetch data from the MySQL table. We can also use a...

MySQL – LIKE Clause

We have seen the SQL SELECT command to fetch data from the MySQL table. We can also use a...

MySQL – Select Query

The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at...

MySQL – Select Query

The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at...