title: How to add a column to a mysql database using visual basic
body: <p>My Goal: Add a column to mysql database using visual basic!</p>
  
  <p>I have tried multiple ways, but here is the code I'm currently using: </p>
  
  <pre><code>Private Sub Button5_Click(sender As Object, e As EventArgs) Handles Button5.Click
      MysqlConn = New MySqlConnection
      MysqlConn.ConnectionString = "Server=xxx.xx.xxx.xxx;Port=3306;Database=test;Uid=tester;Pwd=***"
      Try
          MysqlConn.Open()
          Dim Query As String
          Query = "ALTER TABLE user ADD test INT NOT NULL"
          COMMAND = New MySqlCommand(Query, MysqlConn)
          MysqlConn.Close()
      Catch ex As Exception
      End Try
  End Sub
  </code></pre>
  
  <p>I think it's a problem with the query! Thanks for your help in advance!
  This is different from ms sql, it's visual basic.</p>