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
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
