Friday, 15 February 2013

sqlite3 - Execute multiple queries in one shot in SQLite C#? -


I know how to execute a statement, but one of the easiest ways to execute blocks of statements The way. I just want to delete a column from the table.

  BEGIN transfer; Temporary table T1_backup (A, B); In T1_backup, select Insert a, b fROM t1; Drop table t1; Create Table T1 (A, B); Select T1 A, B to T1_back; Drop Table T1_backup; COMMIT;  

The only way to execute each line as a separate query and transaction. I want to have some APIs to execute a group of questions once.


No comments:

Post a Comment