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!
|
|
