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