-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martin Edenhofer wrote: | Many thanks for feedback. One question. Would it also work on your MySQL | 5.1 with | | my $SQL =ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; | $SQL .=$Param{Local}) REFERENCES "; | $SQL .=$Param{ForeignTableName} ($Param{Foreign})"; Of course, the 2 are equivalent. At any rate, I actually tested it too.... You only need the `` if you use characters reserved in SQL, table_names, column_names, etc... - -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip@ridecharge.com) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.8 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFINb8ddbiP+9ubjBwRArx/AJ492SgIOiUumVLbA6y4KGzuBtK1HQCfb0OK SLbcrQgrNNEGSZS4268uSV0= =Cu9f -----END PGP SIGNATURE-----