Hi Philip, On May 22, 2008, at 20:44 , Philip M. Gollucci 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...
Many thanks for feedback! Cool! I also think it's not a good idea to use characters reserved in SQL. :) So we will remove the ` and it will be available in 2.2.7 and higher. Any comments? -Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97505 Chairman: Burchard Steinbild Chief Executive Officer: André Mindermann