Gambas Documentation - /comp/gb.mysql/_table/loaddata

/comp/gb.mysql/_table/loaddata

# _Table.LoadData (gb.mysql)

Sub LoadData ( Table As String, File As String [ , Database As String ] )

Loads data into a table from the specified file.

Table: Is the table to use.
File: Is the path and file name.

See this page for more information.

### Examples

    Dim hCon As New Connection

    With hCon
      .Type = "mysql"
      .Port = "3306"
      .Host = "localhost"
      .User = "root"
      .Password = "mypass"
      .Name = "Gambas"
      .Open()
    End With

    hCon.MySQL.Table.LoadData("actor", User.Home &/ "actor.sql")

    MySQL statement: LOAD DATA LOCAL INFILE '/home/yourname/actor.sql' INTO TABLE `actor`