In SQL, you cannot use a column alias in the where clause that's been defined in the select clause, for example an alias created by a sub-select. Today i discovered a derived temporary table workaround, this creates a table with my select statement and this allows me to use the alias with a conditional statement. [...]
Posts Tagged ‘mysql’
Feb 27 2008
Code Generator
Code gen is a PHP / MySQL code generator. It uses a table structure to create the basic syntax for amending, updating and deleting database entries with a nice Gui, this can be adapted to fit in with your existing website. Version: 1.3 (Beta) Requirments: PHP & MySql Features: > Built on a template based [...]