Change detection in MySQL. Post: 302324871

4 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #...

2. Programming

Parallel Processing Detection and Program Return Value Detection

Hey, for the purpose of a research project I need to know if a specific type of parallel processing is being utilized by any user-run programs. Is there a way to detect whether a program either returns a value to another program at the end of execution, or just utilizes any form of parallel...

3. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

4. Shell Programming and Scripting

Help: Change date to datetime mysql using awk

#cat file1.log 10.51.61.38;Thu Nov 1 08:06:12 2012;Logout 10.51.62.21;Thu Nov 1 08:06:16 2012;Login output result: 10.51.61.38;2012-11-01 08:06:12;Logout 10.51.62.21;2012-11-01 08:06:16;Login how to write script using awk, need help

LEARN ABOUT PHP

db2_foreign_keys

DB2_FOREIGN_KEYS(3)							 1						       DB2_FOREIGN_KEYS(3)

db2_foreign_keys - Returns a result set listing the foreign keys for a table

SYNOPSIS

       resource db2_foreign_keys (resource  $connection, string  $qualifier, string  $schema, string  $table-name)

DESCRIPTION

	Returns a result set listing the foreign keys for a table.

PARAMETERS

	      o $connection
		- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

	      o $qualifier
		- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.

	      o $schema
		- The schema which contains the tables. If $schema is NULL, db2_foreign_keys(3) matches the schema for the current connection.

	      o $table-name
		- The name of the table.

RETURN VALUES

	Returns a statement resource with a result set containing rows describing the foreign keys for the specified table. The result set is com-
       posed of the following columns:

       +--------------+---------------------------------------------------+
       | Column name  | 						  |
       |	      | 						  |
       |	      | 		   Description			  |
       |	      | 						  |
       +--------------+---------------------------------------------------+
       | PKTABLE_CAT  | 						  |
       |	      | 						  |
       |	      |  Name of the catalog for the table containing the |
       |	      | primary key. The value is NULL if this table does |
       |	      | not have catalogs.				  |
       |	      | 						  |
       |PKTABLE_SCHEM | 						  |
       |	      | 						  |
       |	      |  Name of the schema for the table containing  the |
       |	      | primary key.					  |
       |	      | 						  |
       |PKTABLE_NAME  | 						  |
       |	      | 						  |
       |	      |   Name of the table containing the primary key.   |
       |	      | 						  |
       |PKCOLUMN_NAME | 						  |
       |	      | 						  |
       |	      |  Name of the column containing the primary key.   |
       |	      | 						  |
       | FKTABLE_CAT  | 						  |
       |	      | 						  |
       |	      |  Name of the catalog for the table containing the |
       |	      | foreign key. The value is NULL if this table does |
       |	      | not have catalogs.				  |
       |	      | 						  |
       |FKTABLE_SCHEM | 						  |
       |	      | 						  |
       |	      |  Name  of the schema for the table containing the |
       |	      | foreign key.					  |
       |	      | 						  |
       |FKTABLE_NAME  | 						  |
       |	      | 						  |
       |	      |   Name of the table containing the foreign key.   |
       |	      | 						  |
       |FKCOLUMN_NAME | 						  |
       |	      | 						  |
       |	      |  Name of the column containing the foreign key.   |
       |	      | 						  |
       |   KEY_SEQ    | 						  |
       |	      | 						  |
       |	      |   1-indexed position of the column in the key.	  |
       |	      | 						  |
       | UPDATE_RULE  | 						  |
       |	      | 						  |
       |	      |  Integer value representing the action applied to |
       |	      | the foreign key when the SQL operation is UPDATE. |
       |	      | 						  |
       | DELETE_RULE  | 						  |
       |	      | 						  |
       |	      |  Integer value representing the action applied to |
       |	      | the foreign key when the SQL operation is DELETE. |
       |	      | 						  |
       |   FK_NAME    | 						  |
       |	      | 						  |
       |	      | 	  The name of the foreign key.		  |
       |	      | 						  |
       |   PK_NAME    | 						  |
       |	      | 						  |
       |	      | 	  The name of the primary key.		  |
       |	      | 						  |
       |DEFERRABILITY | 						  |
       |	      | 						  |
       |	      |  An integer value representing whether	the  for- |
       |	      | eign key deferrability is SQL_INITIALLY_DEFERRED, |
       |	      | SQL_INITIALLY_IMMEDIATE, or SQL_NOT_DEFERRABLE.   |
       |	      | 						  |
       +--------------+---------------------------------------------------+
SEE ALSO

       db2_column_privileges(3),  db2_columns(3),  db2_primary_keys(3),   db2_procedure_columns(3),   db2_procedures(3),   db2_special_columns(3),
       db2_statistics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 												       DB2_FOREIGN_KEYS(3)