| Recommend this page to a friend! |
| Classes of Carlo Tasca | > | My One Line SQL | > | Download .tar.gz .zip | > | > | > | |||||
|
| ||||||||||||||||||||||||||||||||||||||||||
| Detailed description | ||
| This package can be used to compose and execute common types of MySQL database queries. It can run several types of common queries within a single call using eventual parameters to define queries that take variable values. Currently it supports the following types of queries: - SELECT what FROM tablename - SELECT what FROM tablename WHERE where_expression - SELECT what FROM tablename ORDER BY order_expression ASC/DESC - SELECT what FROM tablename WHERE where_expression ORDER BY order_text ASC/DESC - SELECT what FROM tablename WHERE where_expression ORDER BY order_text ASC/DESC LIMIT query_limits - UPDATE tablename SET which_set WHERE where_expression - INSERT INTO tablename (fields) VALUES (which_VALUES) - CREATE TABLE table_structure - ALTER TABLE tablename ADD add_what AFTER after_what - SHOW TABLES - DROP TABLE tablename - DELETE FROM tablename WHERE where_expression - OPTIMIZE TABLE tablename |
| Groups | ||
| PHP 5 | Classes using PHP 5 specific features | View top rated classes | |
| Databases | Database management, accessing and searching | View top rated classes |
| Applications | ||||||
No application links were specified for this class.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||