Gambas Documentation - /comp/gb.mysql/_field/index

/comp/gb.mysql/_field/index

# _Field.Index (gb.mysql)

Sub Index ( Index As String, Field As String )

Stores the information for a index, later, that information will be used to create a table.

Index: Is the name of the index.
Field: Is the field to reference.

When the table is created all the index's information is cleaned.

### 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.Field.Index("idx_fk_country_id", "country_id")