The following error occurs after this. What is wrong ?
Error 1064 #42000You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'PROCEDURE add_emp(IN fname VARCHAR(20)) BEGIN SELECT * FROM KLANTEN; END'
at line 1
Dim conn As New MySql.Data.MySqlClient.MySqlConnection
Dim cmd As New MySql.Data.MySqlClient.MySqlCommand
conn.ConnectionString = myconnstring
Try
conn.Open()
cmd.Connection = conn
cmd.CommandText = "CREATE PROCEDURE add_emp(" _
& "IN fname VARCHAR(20)) " _
& "BEGIN SELECT * FROM KLANTEN; END"
cmd.ExecuteNonQuery()
Catch ex As MySql.Data.MySqlClient.MySqlException
Label1.Text = "Error " & ex.Number & " " & ex.Message
End Try
