MySQL Study Notes-mysqlparameter (Abstract)

When operating the database in. net.

You all like sqlparameter.

Parameter is pre-compiled, which can speed up or prevent injection.

Use sqlparameter when using MSSQL.

Use mysqlparameters when using MySQL.

When I use MySQL for the first time, I often make a mistake.

For example, when MSSQL is used, a query is written like this.

SelectName, IDFrom User WhereID=@ ID

When using MySQL, the query statement must be as follows:

SelectName, IDFrom User WhereID=? ID

@ Changed?

Similarly, when Parameter

MSSQL is like this

Sqlparameter Param= NewSqlparameter ("@ID", Sqldbtype. INT );

MySQL is like this.

Mysqlparameter Param= NewMysqlparameter ("? ID", Mysqldbtype. int32 );