Hi,
Any one knows if MySQL implemented the feature which is equivalent to
Oracle's Connect by Prior
clause. This is needed for retrieving 'Tree' result set from a table like :
thanks
BG
- Original Message -
From: Juan Carlos Escobar Gzz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Anyone has any experience of trapping error using DBI-mySQL.
The following code is not trapping the error. it is producing system
generated error.
$memberId='2a';
my($memberId)=@_;
my($sql)= select member_id from members
where member_id != . $memberId;
my $sth =
Since mySQL at this time does not support sub query, Do I've to break this
into 2 SQLs and process:
select question_id from questions where abs_sort_order in (select
min(a.abs_sort_order) from questions a where a.abs_sort_order 1)
Ben
- Original Message -
From: DeNewbie [EMAIL
support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
- Original Message -
From: Ben Goswami [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, July 29, 2002 7:52 AM
Subject: how to set autocommit
Hi,
Where should I change
Hi,
Where should I change the autocommit setting to 0 (i.e no Autocommit). I'm
inserting row from perl script using DBI. I would like to bring up mySQL
server with autocommit false, so that I can explicitly commit from the front
end. But with lot of research in various docs I could not find