[development] Is "SELECT * FROM ..." ok?

Nathaniel Catchpole catch56 at googlemail.com
Fri Feb 13 23:46:36 UTC 2009


One way of both specifying the columns, and accounting for dynamic schema,
is http://api.drupal.org/api/function/drupal_schema_fields_sql - which you
can then build your query from.

I'd imagine the hit to the schema is going to cost more than the MySQL
internals for SELECT *, but otherwise it lets you get the best of both
worlds in terms of correctness.

Nat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20090213/9e8d0e90/attachment.htm 


More information about the development mailing list