MySQL in a nutshell
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 probab...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media
2005.
|
| Edición: | First edition |
| Colección: | In a nutshell (O'Reilly & Associates)
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627130806719 |
Tabla de Contenidos:
- 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()
