_DataBase.Add (gb.mysql)
Sub Add ( Database As String [ , Charset As String, Collation As String ] )
Creates a database
Database: Is the database name.
Charset: Is the charset to use.
Collation: Is the collation to use.
If Charset and Collation are not provided, then the default ones are used.
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.DataBase.Add("Gambas", hCon.MySQL.Charset, hCon.MySQL.Collation)
MySQL statement: CREATE DATABASE `Gambas` DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE utf8_general_ci