as it turns out it was a MYSQL BUG
http://bugs.mysql.com/bug.php?id=11151&error=no
thanks anyway
regards Haseeb
- Original Message -
From: "°l||l° Jinxed °l||l°" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 08, 2005 3:32 AM
Subject: Re: LOAD DATA INFILE with IN
this is strange, when i do this..
===
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into tbltemp (tmp_crdd_no,tmp_serial_no,tmp_date)
values('100','100',NOW());
Query OK, 1 row affected (0.00 sec)
mysql> select * from tblt
hi,
yes you did it and i failed to do so. thats why i am here.
i am using MYSQL 5.0.3 beta-standard with RedHat 9 , the test involves only
innodb as i mentioned in the very first post,
i have read docs and it says that there are 3 ways i can start a transaction
and i tried all three i.e. begin wor
i used start transaction before using SET AUTOCOMMIT=0; also i dont see any
difference between the two. if there is please elaborate.
- Original Message - .
From: <[EMAIL PROTECTED]>
To: "°l||l° Jinxed °l||l°" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, June 07, 2005 3:17 AM
Subject: Re: LOAD