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...

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 – 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...

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...