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 ..... .....