MySQL DevZone RSS

Hi,

I am trying to build a application in which I can be able to flow data to MySQL and vice -versa.

I need to understand that how the update, any changes done in MySQL database will be known or immediately flown to other side?

What is the Change detection mechanism in MySQL?

What I am trying to understood is :
If I add some entry in Database it has immediately flown to other side.

Can you please shed some light on this?

In more details:

Is there any API, command for MySQL which will return the changes between given time period
Ex. suppose from 10.11 am to 14.00 pm

Or something like If given any range
From last change number 100 to onwords all changes.

Can you please tell me that If I want to use the latest version of MySQL with trigger facility then which will be better 5.0 or 6.0 or in between?

MySQL has support for triggers in all versions 5+. Please have a look at the MySQL documentation on triggers here MySQL :: MySQL 5.0 Reference Manual :: 18.3 Using Triggers and let us know if that works for you.

Hi,

I am trying to fire a query in MyLSQ 5.1.34 like

mysql> select table_schema from INFORMATION_SCHEMA.TABLES where table_name='table11';

Empty set (0.08 sec)

where table11 is not present in the INFORMATION_SCHEMA.TABLES.

I am expecting the error as table not found but as it is returning the empty set.

I tried to fire a query using mysql_real_query() API. How would I get the correct result as table not found?

Or any other ways to achieve same?

How can we get the table schema information in MYSQL 5.1.34?

Like we use in ORACLE to get it as:

OCIDescribeAny() // //get the describe handle for the table to be described.

OCIAttrGet() // to get parameter handle

OCIAttrGet() ////get the number of columns in the table

Depending on how you are actually set up, there is a default schema called information_schema and this database contains the information you are looking for. You may want to search the internet for the precise commands to use. YOu can also use "describe table_name" to find more information on the table in question.