Packages of Carlo Tasca
| Recommend this page to a friend! |
| All class groups | > | All authors | > | Packages of Carlo Tasca (2) | > | Mission progress status | > | Reputation |
|
|||||||||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| ||||
| 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 |
| |||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
