Online Documentation for SQL Manager for MySQL
Import/Export Tools
Using SQL Manager for MySQL you are provided with powerful tools to import and export data to/from your MySQL database.
Exports data to various supported formats including MS Excel, MS Access, RTF, HTML, PDF, CSV, XML, MS Excel 2007 and more.
Imports data from any of supported formats: MS Excel, MS Access, DBF, TXT, CSV, XML, MS Excel 2007, MS Word 2007 and more.
Exports data to an SQL script as a number of INSERT statements.
Saves data to an external file with the SELECT ... INTO OUTFILE statement used.
Loads data from an external file with the LOAD DATA INFILE statement used.
Creates PHP script allowing connecting to a database, displaying data of the selected table, and providing forms and procedures for adding/editing/dropping data.
Facilitates using import/export/save/load wizards.
See also: |