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]>
Sen
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 = $dbh
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 PR
; Add a global MySQL my.cnf option autocommit_default=0.
> ...
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> InnoDB - transactions, hot backup, and foreign key support for MySQL
> See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
>
> -
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 wher
