Most Used Categories

Databases , Learn MySQL

MySQL – and SQL Injection

MySQL – and SQL Injection, If you take user input through a webpage and insert it into a MySQL database, there’s a chance that you have left yourself wide open for a security issue known …Read More

Databases , Learn MySQL

MySQL – Database Export

MySQL – Database Export, The simplest way of exporting a table data into a text file is by using the SELECT…INTO OUTFILE statement that exports a query result directly into a file on …Read More

Databases , Learn MySQL

Using MySQL Sequences

Using MySQL Sequences, A sequence is a set of integers 1, 2, 3, … that are generated in order on a specific demand. Sequences are frequently used in the databases because many appli…Read More

Databases , Learn MySQL

MySQL – Handling Duplicates

MySQL – Handling Duplicates, Generally, tables or result sets sometimes contain duplicate records. Most of the times it is allowed but sometimes it is required to stop duplicate records. It…Read More

Databases , Learn MySQL

MySQL – Temporary Tables

MySQL – Temporary Tables, The temporary tables could be very useful in some cases to keep temporary data. The most important thing that should be known for temporary tables is that they …Read More