i have a problem in my SQL syntax : error message:-
check the manual that corresponds to your MySQL server
version for the right syntax to use near 'example' at line 1
here is my syntax:-
Dim conn As New MySqlConnection
Dim comm As New MySqlCommand


conn.ConnectionString = "Server=localhost; user id = root; password= 505664555; database = Eng"
comm.Connection = conn
conn.Open()


comm.CommandText = "Insert into `Eng`.`Eng.info` ('Attendance','Leave','Date') values('" & TextBox1.Text & "', '" & TextBox2.Text & "','" & TextBox3.Text & "')"
comm.ExecuteNonQuery()
If MsgBox("Information Successfully saved! / Account Generation Succeed!", MsgBoxStyle.Information, "Information Generation") Then
MessageBox.Show("Saved", "successful")
TextBox1.Clear()
TextBox2.Clear()
TextBox3.Clear()

-my problem is in "comm.ExecuteNonQuery()