عنوان

MySQL Pocket Reference :

(Number (ISBN

0596516541

(Number (ISBN

059655169X

(Number (ISBN

9780596516543

(Number (ISBN

9780596551698

Number

b603951

Title Proper

MySQL Pocket Reference :

General Material Designation

[Book]

Other Title Information

SQL Functions and Utilities.

First Statement of Responsibility

George Reese

Place of Publication, Distribution, etc.

Sebastopol

Name of Publisher, Distributor, etc.

O'Reilly Media

Date of Publication, Distribution, etc.

2007

Specific Material Designation and Extent of Item

(134 pages).

Series Title

Pocket Reference (O'Reilly)

Text of Note

MySQL Pocket Reference; Introduction; MySQL 5; Views; Triggers; Stored Procedures; Cursors; New Storage Engines; Database Events; Setup; Downloading MySQL; Configuration; Startup; Mac OS X; Solaris; Other Unix; Set the Root Password; Replication; Master configuration; Slave configuration; Command-Line Tools; Data Types; Numerics; BIGINT; BIT; DEC; DECIMAL; DOUBLE; DOUBLE PRECISION; FLOAT; INT; INTEGER; MEDIUMINT; NUMERIC; REAL; SMALLINT; TINYINT; Strings; BINARY; BLOB; CHAR; CHARACTER; CHARACTER VARYING; LONGBLOB; LONGTEXT; MEDIUMBLOB; MEDIUMTEXT; NCHAR; NATIONAL CHAR. NATIONAL CHARACTERNATIONAL VARCHAR; TEXT; TINYBLOB; TINYTEXT; VARBINARY; VARCHAR; Dates; DATE; DATETIME; TIME; TIMESTAMP; YEAR; Complex Types; ENUM; SET; SQL; Case Sensitivity; Literals; Identifiers; Comments; Commands; ALTER DATABASE; ALTER EVENT; ALTER FUNCTION; ALTER PROCEDURE; ALTER TABLE; ALTER TABLESPACE; ALTER VIEW; ANALYZE TABLE; BEGIN; CALL; CHANGE MASTER; CLOSE; COMMIT; CREATE DATABASE; CREATE EVENT; CREATE FUNCTION; CREATE INDEX; CREATE PROCEDURE; CREATE TABLE; CREATE TABLESPACE; CREATE TRIGGER; CREATE USER; CREATE VIEW; DECLARE; DELIMITER; DELETE; DESCRIBE; DESC; DO; DROP DATABASE. DROP EVENTDROP FUNCTION; DROP INDEX; DROP PROCEDURE; DROP TABLE; DROP TABLESPACE; DROP TRIGGER; DROP USER; DROP VIEW; EXPLAIN; FETCH; FLUSH; GRANT; INSERT; KILL; LOAD; LOCK; OPEN; OPTIMIZE; RELEASE SAVEPOINT; RENAME DATABASE; RENAME USER; REPLACE; REVOKE; ROLLBACK; SAVEPOINT; SELECT; SET; SHOW; TRUNCATE; UNLOCK; UPDATE; USE; Transaction Rules; Operators; Rules of Precedence; Arithmetic Operators; Comparison Operators; Logical Operators; Functions; Aggregate Functions; General Functions; Storage Engines; Stored Procedures and Functions; Parameters; Logic; CASE; IF; LOOP; LEAVE; ITERATE; REPEAT. WHILECursors; Handlers and Conditions; Triggers; Index.

Text of Note

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 passwordMySQL data types, including numerics, strings, dates, and complex typesSQL syntax, commands, data types, operators, and functionsArithmetic, comparison and logical operatorsAggregate and general functionsStored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggersYou 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.

Database management.

MySQL (Electronic resource)

Relational databases.

George Reese

George Reese

Electronic name

[Book]

Y