Redian新闻
>
help: questions about MySql
avatar
help: questions about MySql# Database - 数据库
l*k
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!
avatar
f*y
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!

avatar
n*a
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.

avatar
s*i
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!

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。