How to use insert query statement in Mysql

By | 13th September 2017
0 Comment
Insert query is used to add/insert the data values into the database tables. By executing the query the data easily inserts into the database.
The below statement is how we actually insert the data values into the database.
 
cmd.CommandText = “insert into `databasename.tablename (field1,field2) values ('1','abc');
cmd.Connection = con;
cmd.ExecuteNonQuery();