SQLBuilder
SQLBuilder copied to clipboard
A powerful, fast, cross-platform SQL Builder for PHP. Convert your structured data into SQL queries with a fluent style interface and targeting on all the mainstream database (MySQL, PostgreSQL, SQLit...
- http://stackoverflow.com/questions/20865747/geolocation-mysql-query - http://www.percona.com/blog/2013/10/21/using-the-new-spatial-functions-in-mysql-5-6-for-geo-enabled-applications/ - http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
e.g., ``` sql INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07'; ``` refs: - http://www.postgresql.org/docs/8.3/static/sql-insert.html
Listed in http://dev.mysql.com/doc/refman/5.0/en/information-functions.html