MySQL in a nutshell / Russell J.T. Dyer.

Format:

Book

Author/Creator:

Dyer, Russell J. T.

Series:

In a nutshell (O'Reilly & Associates)

In a nutshell

Language:

English

Subjects (All):

MySQL (Electronic resource).

SQL (Computer program language).

Physical Description:

1 online resource (350 p.)

Edition:

First edition.

Place of Publication:

Sebastopol, California : O'Reilly Media, 2005.

Language Note:

English

System Details:

text file

Summary:

MySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MySQL's capabilities quickly and easily. MySQL in a Nutshell is the indispensable desktop

Contents:

Table of Contents; Preface; The Purpose of This Book; How This Book Is Organized; Conventions Used in This Book; Using Code Examples; Request for Comments; Safari Enabled; Acknowledgments; Introduction to MySQL; The Value of MySQL; The MySQL Package; Licensing; Mailing Lists; Books and Other Publications; Installing MySQL; Choosing a Distribution; Unix Source Distributions; Unix Binary Distributions; Linux RPM Distributions; Macintosh OS X Distributions; Novell NetWare Distributions; Windows Distributions; Postinstallation; MySQL Basics; The mysql Client; Creating a Database and Tables

Show MeInserting Data; Selecting Data; Ordering, Limiting, and Grouping; Analyzing and Manipulating Data; Changing Data; Deleting Data; Searching Data; Importing Data in Bulk; Command-Line Interface; Conclusion; SQL Statements; Statements Grouped by Type; Data Manipulation; Database and Table Schema; Database and Table Properties; Table Administration; User Administration; Server Administration; Replication; Statements and Clauses in Alphabetical Order; ALTER DATABASE; ALTER TABLE; ALTER VIEW; ANALYZE TABLE; BACKUP TABLE; CACHE INDEX; CHANGE MASTER TO; CHECK TABLE; CHECKSUM TABLE; COMMIT

CREATE DATABASECREATE INDEX; CREATE TABLE; CREATE VIEW; DELETE; DESCRIBE; DO; DROP DATABASE; DROP INDEX; DROP TABLE; DROP USER; DROP VIEW; EXPLAIN; FLUSH; GRANT; HANDLER; INSERT; JOIN; KILL; LOAD DATA FROM MASTER; LOAD DATA INFILE; LOAD INDEX INTO CACHE; LOAD TABLE...FROM MASTER; LOCK TABLES; OPTIMIZE TABLE; PURGE MASTER LOGS; RENAME TABLE; REPAIR TABLE; REPLACE; RESET; RESET MASTER; RESET SLAVE; RESTORE TABLE; REVOKE; ROLLBACK; ROLLBACK TO SAVEPOINT; SAVEPOINT; SELECT; SET; SET PASSWORD; SET SQL_LOG_BIN; SET TRANSACTION; SHOW BINLOG EVENTS; SHOW CHARACTER SET; SHOW COLLATION; SHOW COLUMNS

SHOW CREATE DATABASESHOW CREATE TABLE; SHOW CREATE VIEW; SHOW DATABASES; SHOW ENGINES; SHOW ERRORS; SHOW GRANTS; SHOW INDEX; SHOW INNODB STATUS; SHOW LOGS; SHOW MASTER LOGS; SHOW MASTER STATUS; SHOW PRIVILEGES; SHOW PROCESSLIST; SHOW SLAVE HOSTS; SHOW SLAVE STATUS; SHOW STATUS; SHOW TABLE STATUS; SHOW TABLES; SHOW VARIABLES; SHOW WARNINGS; START SLAVE; START TRANSACTION; STOP SLAVE; TRUNCATE TABLE; UNION; UNLOCK TABLES; USE; String Functions; String Functions Grouped by Type; Converting; Formatting; Expressions; Extracting; Manipulating; Security; String Functions in Alphabetical Order

AES_DECRYPT()AES_ENCRYPT(); ASCII(); BIN(); BINARY; BIT_LENGTH(); CHAR(); CHAR_LENGTH(); CHARACTER_LENGTH(); COMPRESS(); CONCAT(); CONCAT_WS(); CONV(); DECODE(); DES_DECRYPT(); DES_ENCRYPT(); ELT(); ENCODE(); ENCRYPT(); EXPORT_SET(); FIELD(); FIND_IN_SET(); HEX(); INET_ATON(); INET_NTOA(); INSERT(); INSTR(); LCASE(); LEFT(); LENGTH(); LOAD_FILE(); LOCATE(); LOWER(); LPAD(); LTRIM(); MAKE_SET(); MATCH () AGAINST(); MD5(); MID(); OCT(); OCTET_LENGTH(); OLD_PASSWORD(); ORD(); PASSWORD(); POSITION(); QUOTE(); REPEAT(); REPLACE(); REVERSE(); RIGHT(); RPAD(); RTRIM(); SHA(); SHA1(); SOUNDEX()

SPACE()

Notes:

"A desktop quick reference"--Cover.

Includes index.

Description based on print version record.

ISBN:

9781449379063

1449379060

9780596518288

0596518285

Publisher Number:

0596007892