Apache Presto – MySQL Connector
The MySQL connector is used to query an external MySQL database. Prerequisites MySQL server installation. Configuration Settings Hopefully you have installed mysql server on your machine. To enable mysql properties…
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. Importing Data with LOAD DATA MySQL provides a LOAD DATA…
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 the server host.…
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…
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 is required to identify…
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 applications…
MySQL – Database Info
Obtaining and Using MySQL Metadata There are three types of information, which you would like to have from MySQL. Information about the result of queries − This includes the number of…
MySQL – Clone Tables
There may be a situation when you need an exact copy of a table and CREATE TABLE ... SELECT doesn't suit your purposes because the copy must include the same indexes, default…
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 will be…
MySQL – INDEXES
A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for both…