comp • gb.mysql • _table • modify

_Table.Modify (gb.mysql)

Sub Modify ( Table As String [ , Database As String, Engine As String, Charset As String ] )

Alters the column definition from a table.

Table: Is the table to use.
Action: Is the action to execute. One of the following: DROP, ADD, MODIFY, CHANGE.
Symbol: Is the column to use.
Definition: Is the new field definition.

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.Modify("actor", "MODIFY", "first_name", "SMALLINT UNSIGNED")

MySQL statement: ALTER TABLE `actor` MODIFY `first_name` SMALLINT UNSIGNED