Syntax MySql Pada Visual Basics 6

Perintah Insert

Conn.BeginTrans
MySqL = "INSERT INTO Nama_table (Filed1, Filed2, Filed3) Values ('" & String1 & "','" & String2 & "','" & String3 & "')"
Conn.Execute MySqL
Conn.CommitTrans

Perintah Update

Conn.BeginTrans
MySqL = "UPDATE Nama_table SET Filed1 = '" & String1 & "', Filed2 = '" & String2 & "', Filed3 = '" & String3 & "' Where Field4 ='" & String4 & "'"
Conn.Execute MySqL
Conn.CommitTrans

Perintah Delete

Conn.BeginTrans
MySqL = "DELETE from Nama_table where Field1 = '" & String1 & "' and Field2 = '" & String2 & "'"
Conn.Execute MySqL
Conn.CommitTrans

..........