MySQL Pocket Reference: SQL Statements, Functions and Utilities and more (Pocket Reference (O'Reilly))
Format: PDF / Kindle (mobi) / ePub
To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.
Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:
- How to configure MySQL, such as setting the root password
- MySQL data types, including numerics, strings, dates, and complex types
- SQL syntax, commands, data types, operators, and functions
- Arithmetic, comparison and logical operators
- Aggregate and general functions
- Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers
You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.
data or indexes within the table, only the table's name. If this statement is performed alone, without any other ALTER TABLE clauses, MySQL will not create a temporary table as with the other clauses, but simply perform a fast operating system-level rename of the table files. table_options Enables a redefinition of the tables options such as the table type. Multiple ALTER statements may be combined into one using commas, as in the following example: ALTER TABLE mytable DROP myoldcolumn,
0, which enables standard logging. SQL_LOW_PRIORITY_UPDATES=0 or 1 Tells MySQL to wait until no pending SELECT or LOCK TABLE READ is occurring on an affected table before executing a write statement. SQL_MAX_JOIN_SIZE=value or DEFAULT Prohibits MySQL from executing queries that will likely need more than the specified number of row combinations. If you set this value to anything other than the default, it will cause SQL_BIG_SELECTS to be reset. Resetting SQL_BIG_SELECTS will cause this
// Handlers and Conditions MySQL lets you know when a certain condition arises during the course of stored procedure processing through the use of handlers and conditions. The cursor example in the previous section included code that declared a handler to manage SQLSTATE '02000'—the end of the result set. When declaring a handler, you define a handler type, what the handler is for, and the SQL to execute when the handler situation arises. MySQL supports the following types of
commands supporting triggers include CREATE TRIGGER and DROP TRIGGER. Stored Procedures Stored procedures are the big feature most people have been waiting for. A stored procedure is much like creating a function that is written entirely in SQL and stored in the database. Stored procedures are useful for encapsulating a number of SQL statements that always get executed together under a single logical name for use by clients. MySQL includes a number of new commands to support stored
.idb file if you are using per-table tablespaces. Be sure to back up the old .idb file before issuing this command. DROP [COLUMN] column Deletes a column from a table. This statement will remove a column and all its data from a table permanently. There is no way to recover data destroyed in this manner other than from backups. All references to this column in indexes will be removed. Any indexes where this was the sole column will be destroyed as well. (The COLUMN keyword is optional and has