MySQL Database Import

There are two simple ways in MySQL to load data into MySQL database from a previously backed up file. Importing Data with LOAD DATA: MySQL provides a LOAD DATA statement that acts as a bulk data loader. Here's an example statement that reads a file dump.txt from your current directory and loads it into the table mytbl in the current database: mysql>...

Read More

MySQL Database Export

The simplest way of exporting a table data into a text file is using SELECT...INTO OUTFILE statement that exports a query result directly into a file on the server host. Exporting Data with the SELECT ... INTO OUTFILE Statement: The syntax for this statement combines a regular SELECT with INTO OUTFILE filename at the end. The default output format...

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 as SQL Injection. This lesson will teach you how to help prevent this from happening and help you secure your scripts and MySQL statements. Injection usually occurs when you ask a user...

Read More

MySQL Handling Duplicates

Tables or result sets sometimes contain duplicate records. Sometimes, it is allowed but sometimes it is required to stop duplicate records. Sometimes, it is required to identify duplicate records and remove them from the table. This chapter will describe how to prevent duplicate records occurring in a table and how to remove already existing duplicate...

Read More

MySQL Sequences

A sequence is a set of integers 1, 2, 3, ... that are generated in order on demand. Sequences are frequently used in databases because many applications require each row in a table to contain a unique value and sequences provide an easy way to generate them. This chapter describes how to use sequences in MySQL. Using AUTO_INCREMENT column: The...

Read More

MySQL Metadata

There are three informations, which you would like to have from MySQL. Information about the result of queries: This includes number of records affected by any SELECT, UPDATE or DELETE statement. Information about tables and databases: This includes information pertaining to the structure of tables and databases. Information about the MySQL server:...

Read More