l*****k 发帖数: 6 | 1 don't laugh! I am just a beginner of MySQL!
I want to write a script that I can run to commit a serial of databases
queries (select, create table, etc.)
How can I do it with MySql? Right now, I am using Perl (ODBC) to do the job.
But just think there might be some ways to use transact sql in MySql.
Thanks for you help! | f**y 发帖数: 138 | 2 I have an impression that MySQL doesn't support transaction.
PostgreSQL is a better choice.
【在 l*****k 的大作中提到】 : don't laugh! I am just a beginner of MySQL! : I want to write a script that I can run to commit a serial of databases : queries (select, create table, etc.) : How can I do it with MySql? Right now, I am using Perl (ODBC) to do the job. : But just think there might be some ways to use transact sql in MySql. : Thanks for you help!
| n********a 发帖数: 68 | 3 As of MySQL4.0, InnoDB supports transaction.
job.
【在 f**y 的大作中提到】 : I have an impression that MySQL doesn't support transaction. : PostgreSQL is a better choice.
| s**********i 发帖数: 711 | 4 you use DBI/DBD modules. just read the document, they have
enough instructions and examples there.
【在 l*****k 的大作中提到】 : don't laugh! I am just a beginner of MySQL! : I want to write a script that I can run to commit a serial of databases : queries (select, create table, etc.) : How can I do it with MySql? Right now, I am using Perl (ODBC) to do the job. : But just think there might be some ways to use transact sql in MySql. : Thanks for you help!
|
|