Google

MySQLMan Help


Tool bar     HOME

Import

Import data in a delimited file into a table. The file can be located on the server or on local drive. The link to the tool can be found in the tool bar once a table is selected.

Please note that import is just a frontend for mySQL's LOAD DATA INFILE command. For more details, please refer to mySQL online manual at http://www.mysql.com/Manual_chapter/manual_Reference.html#LOAD_DATA

  • Run as default
    Enter the the path to the import file in the text field after "File:" then press "Import".
  • Import selected fields
    If the fields in the file does not match the number or the order of the fields in the table, then you can select the fields that you want to import. First of all, check "Selected Fields". Fields in the current table are displayed in Fields in table table_name window. You then add the fields that you wish to import from that window to the window Fields selected one at a time by clicking on "Add >>" after each field is selected in Fields in table table_name window. Please note that the order in the window Fields selected should match the order of the fields in the file.
  • Local Import
    If local import is select, the file is read from the client host. If not, then the file must be located on the server. (Available in MySQL 3.22.6 or later.)
Tool bar     HOME
Related topics: Export