c# 向mysql插入数据_c#向数据库插入数据的各种方法

展开全部

1、一条一条插入

INSERT INTO Product(Id,Name,Price) VALUES(newid(),'牛栏1段62616964757a686964616fe78988e69d8331333366306436',160);

INSERT INTO Product(Id,Name,Price) VALUES(newid(),'牛栏2段',260);

......

2、insert bulk

BULK INSERT [ [ 'database_name'.][ 'owner' ].]{ 'table_name' FROM 'data_file' }

WITH  (

[ BATCHSIZE [ = batch_size ] ],

[ CHECK_CONSTRAINTS ],

[ CODEPAGE [ = 'ACP' | 'OEM' | 'RAW' | 'code_page' ] ],

[ DATAFILETYPE [ = 'char' | 'native'| 'widechar' | 'widenative' ] ],

[ FIELDTERMINATOR [ = 'field_terminator' ] ],

[ FIRSTROW [ = first_row ] ],

[ FIRE_TRIGGERS ],

[ FORMATFILE = 'format_file_path' ],

[ KEEPIDENTITY ],

[ KEEPNULLS ],

[ KILOBYT