_DataBase.Delete (gb.mysql)
Sub Delete ( [ Database As String, IfExists As Boolean ] )
Drops a database.
Database: Is the name of the database. If isn't given, then the current database is used.
IfExists: If set to true, will drops the database only if exists, otherwise will raise an error.
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.Delete("Gambas", True)
MySQL statement: DROP DATABASE IF EXISTS `Gambas`
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.Delete("Gambas", False)
MySQL statement: DROP DATABASE `Gambas`