MySQL in a Nutshell (ebook)(audiobook)(audiobook)

Spis treści

• MySQL in a Nutshell
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • 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
  • 1. Introduction to MySQL
    • 1.1. The Value of MySQL
    • 1.2. The MySQL Package
    • 1.3. Licensing
    • 1.4. Mailing Lists
    • 1.5. Books and Other Publications
  • 2. Installing MySQL
    • 2.1. Choosing a Distribution
    • 2.2. Unix Source Distributions
    • 2.3. Unix Binary Distributions
    • 2.4. Linux RPM Distributions
    • 2.5. Macintosh OS X Distributions
    • 2.6. Novell NetWare Distributions
    • 2.7. Windows Distributions
    • 2.8. Postinstallation
  • 3. MySQL Basics
    • 3.1. The mysql Client
    • 3.2. Creating a Database and Tables
    • 3.3. Show Me
    • 3.4. Inserting Data
    • 3.5. Selecting Data
    • 3.6. Ordering, Limiting, and Grouping
    • 3.7. Analyzing and Manipulating Data
    • 3.8. Changing Data
    • 3.9. Deleting Data
    • 3.10. Searching Data
    • 3.11. Importing Data in Bulk
    • 3.12. Command-Line Interface
    • 3.13. Conclusion
  • 4. SQL Statements
    • 4.1. Statements Grouped by Type
      • 4.1.1. Data Manipulation
      • 4.1.2. Database and Table Schema
      • 4.1.3. Database and Table Properties
      • 4.1.4. Table Administration
      • 4.1.5. User Administration
      • 4.1.6. Server Administration
      • 4.1.7. Replication
    • 4.2. 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 DATABASE
      • CREATE 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 DATABASE
      • SHOW 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
  • 5. String Functions
    • 5.1. String Functions Grouped by Type
      • 5.1.1. Converting
      • 5.1.2. Formatting
      • 5.1.3. Expressions
      • 5.1.4. Extracting
      • 5.1.5. Manipulating
      • 5.1.6. Security
    • 5.2. 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( )
      • STRCMP( )
      • SUBSTRING( )
      • SUBSTRING_INDEX( )
      • TRIM( )
      • UCASE( )
      • UNCOMPRESS( )
      • UNCOMPRESSED_LENGTH( )
      • UNHEX( )
      • UPPER( )
  • 6. Date and Time Functions
    • 6.1. Date and Time Functions Grouped by Type
      • Determining the Date and Time
      • Extracting and Formatting the Date and Time
      • Calculating and Modifying the Date and Time
    • 6.2. Date and Time Functions in Alphabetical Order
      • ADDDATE( )
      • ADDTIME( )
      • CONVERT_TZ( )
      • CURDATE( )
      • CURRENT_DATE( )
      • CURRENT_TIME( )
      • CURRENT_TIMESTAMP( )
      • CURTIME( )
      • DATE( )
      • DATE_ADD( )
      • DATE_FORMAT( )
      • DATE_SUB( )
      • DATEDIFF( )
      • DAY( )
      • DAYNAME( )
      • DAYOFMONTH( )
      • DAYOFWEEK( )
      • DAYOFYEAR( )
      • EXTRACT( )
      • FROM_DAYS( )
      • FROM_UNIXTIME( )
      • GET_FORMAT( )
      • HOUR( )
      • LAST_DAY( )
      • LOCALTIME( )
      • LOCALTIMESTAMP( )
      • MAKEDATE( )
      • MAKETIME( )
      • MICROSECOND( )
      • MINUTE( )
      • MONTH( )
      • MONTHNAME( )
      • NOW( )
      • PERIOD_ADD( )
      • PERIOD_DIFF( )
      • QUARTER( )
      • SEC_TO_TIME( )
      • SECOND( )
      • STR_TO_DATE( )
      • SUBDATE( )
      • SUBTIME( )
      • SYSDATE( )
      • TIME( )
      • TIMEDIFF( )
      • TIMESTAMP( )
      • TIMESTAMPDIFF( )
      • TIMESTAMPADD( )
      • TIME_FORMAT( )
      • TIME_TO_SEC( )
      • TO_DAYS( )
      • UNIX_TIMESTAMP( )
      • UTC_DATE( )
      • UTC_TIME( )
      • UTC_TIMESTAMP( )
      • WEEK( )
      • WEEKDAY( )
      • WEEKOFYEAR( )
      • YEAR( )
      • YEARWEEK( )
  • 7. Mathematical and Aggregate Functions
    • 7.1. Functions in Alphabetical Order
      • ABS( )
      • ACOS( )
      • ASIN( )
      • ATAN( )
      • ATAN2( )
      • AVG( )
      • BIT_AND( )
      • BIT_OR( )
      • BIT_XOR( )
      • CEIL( )
      • CEILING( )
      • COS( )
      • COT( )
      • COUNT( )
      • CRC32( )
      • DEGREES( )
      • EXP( )
      • FLOOR( )
      • FORMAT( )
      • GREATEST( )
      • GROUP_CONCAT( )
      • LEAST( )
      • LN( )
      • LOG( )
      • LOG2( )
      • LOG10( )
      • MAX( )
      • MIN( )
      • MOD( )
      • PI( )
      • POW( )
      • POWER( )
      • RADIANS( )
      • RAND( )
      • ROUND( )
      • SIGN( )
      • SIN( )
      • SQRT( )
      • STD( )
      • STDDEV( )
      • SUM( )
      • TAN( )
      • TRUNCATE( )
      • VARIANCE( )
  • 8. Flow Control Functions
    • 8.1. Functions in Alphabetical Order
      • CASE( )
      • IF( )
      • IFNULL( )
      • NULLIF( )
  • 9. Miscellaneous Functions
    • 9.1. Functions in Alphabetical Order
      • ANALYSE( )
      • BENCHMARK( )
      • BIT_COUNT( )
      • CAST( )
      • CHARSET( )
      • COALESCE( )
      • COERCIBILITY( )
      • COLLATION( )
      • CONNECTION_ID( )
      • CONVERT( )
      • CURRENT_USER( )
      • DATABASE( )
      • FOUND_ROWS( )
      • GET_LOCK( )
      • INTERVAL( )
      • IS_FREE_LOCK( )
      • IS_USED_LOCK( )
      • ISNULL( )
      • LAST_INSERT_ID( )
      • MASTER_POS_WAIT( )
      • RELEASE_LOCK( )
      • SESSION_USER( )
      • SYSTEM_USER( )
      • USER( )
      • UUID ( )
      • VERSION( )
  • 10. MySQL Server and Client
    • mysql
    • mysqld
    • mysqld_multi
    • mysqld_safe
  • 11. Command-Line Utilities
    • comp_err
    • isamchk
    • make_binary_distribution
    • msql2mysql
    • my_print_defaults
    • myisamchk
    • myisamlog
    • myisampack
    • mysqlaccess
    • mysqladmin
    • mysqlbinlog
    • mysqlbug
    • mysqlcheck
    • mysqldump
    • mysqldumpslow
    • mysqlhotcopy
    • mysqlimport
    • mysqlshow
    • perror
  • 12. Perl API
    • 12.1. Using Perl DBI with MySQL
      • 12.1.1. Connecting to MySQL
      • 12.1.2. Executing an SQL Statement
      • 12.1.3. Capturing Data
      • 12.1.4. Disconnecting from MySQL
      • 12.1.5. Temporarily Storing Results
    • 12.2. Perl DBI Method and Function Reference
      • available_drivers( )
      • begin_work( )
      • bind_col( )
      • bind_columns( )
      • bind_param( )
      • bind_param_array( )
      • bind_param_inout( )
      • can( )
      • clone( )
      • column_info( )
      • commit( )
      • connect( )
      • connect_cached( )
      • data_sources( )
      • disconnect( )
      • do( )
      • dump_results( )
      • err( )
      • errstr( )
      • execute( )
      • execute_array( )
      • execute_for_fetch( )
      • fetch( )
      • fetchall_arrayref( )
      • fetchall_hashref( )
      • fetchrow_array( )
      • fetchrow_arrayref( )
      • fetchrow_hashref( )
      • finish( )
      • foreign_key_info( )
      • func( )
      • get_info( )
      • installed_versions( )
      • last_insert_id( )
      • looks_like_number( )
      • neat( )
      • neat_list( )
      • parse_dsn( )
      • parse_trace_flag( )
      • parse_trace_flags( )
      • ping( )
      • prepare( )
      • prepare_cached( )
      • primary_key( )
      • primary_key_info( )
      • quote( )
      • quote_identifier( )
      • rollback( )
      • rows( )
      • selectall_arrayref( )
      • selectall_hashref( )
      • selectcol_arrayref( )
      • selectrow_array( )
      • selectrow_arrayref( )
      • selectrow_hashref( )
      • set_err( )
      • state( )
      • table_info( )
      • table_info_all( )
      • tables( )
      • trace( )
      • trace_msg( )
      • type_info( )
      • type_info_all( )
    • 12.3. Attributes for Handles
      • 12.3.1. Attributes for All Handles
      • 12.3.2. Attributes Only for Database Handles
      • 12.3.3. Attributes Only for Statement Handles
      • 12.3.4. DBI Dynamic Attributes
  • 13. PHP API
    • 13.1. Using PHP with MySQL
      • 13.1.1. Connecting to MySQL
      • 13.1.2. Querying MySQL
    • 13.2. PHP MySQL Functions in Alphabetical Order
      • mysql_affected_rows( )
      • mysql_change_user( )
      • mysql_client_encoding( )
      • mysql_close( )
      • mysql_connect( )
      • mysql_create_db( )
      • mysql_data_seek( )
      • mysql_db_name( )
      • mysql_db_query( )
      • mysql_drop_db( )
      • mysql_errno( )
      • mysql_error( )
      • mysql_escape_string( )
      • mysql_fetch_array( )
      • mysql_fetch_assoc( )
      • mysql_fetch_field( )
      • mysql_fetch_lengths( )
      • mysql_fetch_object( )
      • mysql_fetch_row( )
      • mysql_field_flags( )
      • mysql_field_len( )
      • mysql_field_name( )
      • mysql_field_seek( )
      • mysql_field_table( )
      • mysql_field_type( )
      • mysql_free_result( )
      • mysql_get_client_info( )
      • mysql_get_host_info( )
      • mysql_get_proto_info( )
      • mysql_get_server_info( )
      • mysql_info( )
      • mysql_insert_id( )
      • mysql_list_dbs( )
      • mysql_list_fields( )
      • mysql_list_processes( )
      • mysql_list_tables( )
      • mysql_num_fields( )
      • mysql_num_rows( )
      • mysql_pconnect( )
      • mysql_ping( )
      • mysql_query( )
      • mysql_real_escape_string( )
      • mysql_result( )
      • mysql_select_db( )
      • mysql_stat( )
      • mysql_tablename( )
      • mysql_thread_id( )
      • mysql_unbuffered_query( )
  • 14. C API
    • 14.1. Using C with MySQL
      • 14.1.1. Connecting to MySQL
      • 14.1.2. Querying MySQL
    • 14.2. Functions in Alphabetical Order
      • mysql_affected_rows( )
      • mysql_autocommit( )
      • mysql_change_user( )
      • mysql_character_set_name( )
      • mysql_close( )
      • mysql_commit( )
      • mysql_connect( )
      • mysql_create_db( )
      • mysql_data_seek( )
      • mysql_debug( )
      • mysql_drop_db( )
      • mysql_dump_debug_info( )
      • mysql_eof( )
      • mysql_errno( )
      • mysql_error( )
      • mysql_escape_string( )
      • mysql_fetch_field( )
      • mysql_fetch_field_direct( )
      • mysql_fetch_fields( )
      • mysql_fetch_lengths( )
      • mysql_fetch_row( )
      • mysql_field_count( )
      • mysql_field_seek( )
      • mysql_field_tell( )
      • mysql_free_result( )
      • mysql_get_client_info( )
      • mysql_get_client_version( )
      • mysql_get_host_info( )
      • mysql_get_proto_info( )
      • mysql_get_server_info( )
      • mysql_get_server_version( )
      • mysql_info( )
      • mysql_init( )
      • mysql_insert_id( )
      • mysql_kill( )
      • mysql_list_dbs( )
      • mysql_list_fields( )
      • mysql_list_processes( )
      • mysql_list_tables( )
      • mysql_more_results( )
      • mysql_next_result( )
      • mysql_num_fields( )
      • mysql_num_rows( )
      • mysql_options( )
      • mysql_ping( )
      • mysql_query( )
      • mysql_real_connect( )
      • mysql_real_escape_string( )
      • mysql_real_query( )
      • mysql_reload( )
      • mysql_rollback( )
      • mysql_row_seek( )
      • mysql_row_tell( )
      • mysql_select_db( )
      • mysql_set_server_option( )
      • mysql_shutdown( )
      • mysql_sqlstate( )
      • mysql_stat( )
      • mysql_store_result( )
      • mysql_thread_id( )
      • mysql_thread_safe( )
      • mysql_use_result( )
      • mysql_warning_count( )
    • 14.3. C API Datatypes
  • A. Datatypes
    • A.1. Numeric Datatypes
    • A.2. Accurate Numeric Types
    • A.3. Approximate Numeric Datatypes
    • A.4. Date and Time Datatypes
    • A.5. String Datatypes
  • B. Operators
    • B.1. Arithmetic Operators
    • B.2. Relational Operators
    • B.3. Logical Operators
    • B.4. Bitwise Operators
  • C. Environment Variables
  • Index
  • About the Author
  • Colophon
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje