_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.
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`