Introduction Importing and exporting databases is a common task
MySQL – Numeric Functions and Operators, Arithmetic operators are used in mathematical expressions in the same way that they are used in algebra. The following table lists the MySQL arithmetic operator…Read More
MySQL – Statements Reference, Here is the list of all important MySQL statements. Each statement has been explained along with suitable example.…Read More
MySQL – Database Import – Recovery Methods, There are two simple ways in MySQL to load data into the MySQL database from a previously backed up file.…Read More
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
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
MySQL – Database Info, There are three types of information, which you would like to have from MySQL.…Read More
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
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
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