How to use ASP and MySql to addnew a new data?

I know ASP and MsSql to use addnew.

My question:
How to use addnew on Mysql +ASP classic?


Thanks

 

You'd set up your SQL string the same way, then execute the string:

strSQL="INSERT INTO MyTableName (Field1,Field2,Field3) VALUES ('String1',55,'String2')"
objConn.Open
objConn.Execute strSQL
objConn.Close

 

Thanks to all.

I finally found out mysql and mssql can use all same SQL scripts.

Now I can use mySQL DB as extra DBs