<div>
very simple...........<br />
<br />
SELECT COUNT(*) AS OpenQuestions from EE;<br />
<br />
<br />
This should give you the answer for your question.... 
</div>


very simple...........

SELECT COUNT(*) AS OpenQuestions from EE;


This should give you the answer for your question....

<div>
MySQL does not have such equivalent.
</div>


<div>
Agree with Agelll, MySQL don't provide per connection stats such as &quot;number of active transactions for the current connection.&quot;.. but you get a count of running threads which are not sleeping...<br />
<br />
mysql&gt; show status like 'Threads_running';<br />
+-----------------+-------<wbr />+<br />
| Variable_name &nbsp; | Value |<br />
+-----------------+-------<wbr />+<br />
| Threads_running | 1 &nbsp; &nbsp; |<br />
+-----------------+-------<wbr />+<br />

</div>


Agree with Agelll, MySQL don't provide per connection stats such as "number of active transactions for the current connection.".. but you get a count of running threads which are not sleeping...

mysql> show status like 'Threads_running';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| Threads_running | 1     |
+-----------------+-------+


<div>
Hi ushastry,<br />
what is EE here??<br />
rfds,<br />
vijji
</div>


Hi ushastry,
what is EE here??
rfds,
vijji

<div>
<div class="content wysiwyg-content">
Hi,we are migrating iue db from mssql to mysql.<br />
i have a procedure where they have used <br />
@@TRANCOUNT ;<br />
please tell me the equivalent of @@TRANCOUNT in mysql<br />
rgds,<br />
vijji
</div>
</div>


Hi,we are migrating iue db from mssql to mysql.
i have a procedure where they have used 
@@TRANCOUNT ;
please tell me the equivalent of @@TRANCOUNT in mysql
rgds,
vijji

equivalent of @@TRANCOUNT mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.