[Typo3-dev] t3lib_befunc::deleteClause

[Martin Kutschker]

"Michael Stucki" <michael at typo3.org> schrieb im Newsbeitrag 
news:mailman.1.1111528466.26219.typo3-dev at lists.netfielders.de...
> Ingmar Schlecht wrote:
>
>> Martin Kutschker wrote:
>>> Reason: my Mysql 4.0 doesn't like the real tablename when I uses 
>>> aliases.
>>
>> Just don't use aliases! ;-)
>>
>> Otherwise they should be implemented EVERYWHERE, for example in
>> tslib_cObj::enableFields() and many more places.
>> But I wouldn't got for that, because aliases might even become a problem
>> for DBAL.
>
> ACK! I never used aliases yet. Why not use variables in PHP instead?

Hm?!?

Aliases are just shorthands for SQL-Queries:

SELECT t1.somefield,t2.somefield FROM table_with_some_exteremely_long_name 
AS t1, another_table_with_a_long name AS t2 WHERE ...

It's just plain regular SQL. Why use a PHP workaround, if there's something 
already there in SQL? AFAIK this is ANSI-SQL not Mysql-SQL, so no DBAL 
issues here.

Masi