Mysql Tutorial


What is MySQL Tutorial?

MySQL is the most popular Open source Relational square Database control device. MySQL is one of the best RDBMS getting used for developing various net-based software applications. MySQL is advanced, marketed and supported by MySQL AB, that is a Swedish organization. This tutorial will provide you with a quick begin to MySQL and make you secure with MySQL programming.

Audience

This tutorial is ready for the beginners to assist them recognize the basics-to-advanced concepts associated with MySQL languages.

Prerequisites

Before you begin doing exercise with various sorts of examples given on this tutorial, it is being assumed that you are already aware of what a database is, especially an RDBMS and what is a computer programming language.

Next Topics »
Bitkeeper
The Major Directories
The Flow
A Guided Tour Of The Mysql Source Code Bitkeeper The Major Directories The Flow The Open-source Directories The Internal And External Storage Engine Directories The "os Specific" Directories Odds And Ends A Chunk Of Code In /sql/sql_update.cc The Skeleton Of The Server Code Coding Guidelines C/c++ Configure Support For Plugins The Optimizer Code And Concepts Primary Optimizations Other Optimizations Important Algorithms And Structures The Item Class How Mysql Does Sorting (filesort) Bulk Insert How Mysql Does Caching How Mysql Uses The Join Buffer Cache How Mysql Handles Flush Tables Full-text Search Float And Double Data Types And Their Representation Threads Character/collation Sets Error Flags And Functions Functions In The Mysys Library File Formats Mysql .frm File Format How Mysql Performs Different Selects Steps Of Select Execution Select_result Class Simple Or Primary Select Structure Of Complex Select Non-subquery Union Execution Derived Table Execution Subqueries-item_subselect Single Select Engine Union Engine Special Engines Explain Execution How Mysql Transforms Subqueries Item_in_subselect::select_transformer Item_allany_subselect Item_singlerow_subselect Mysql Client/server Protocol Licensing Notice Logical Packets Elements The Packet Header Packet Types Handshake Initialization Packet Client Authentication Packet Password Functions Command Packet Types Of Result Packets Ok Packet Error Packet Result Set Header Packet Field Packet Eof Packet Row Data Packet Row Data Packet: Binary (tentative Description) Prepared Statement Initialization Packet (tentative Description) Ok For Prepared Statement Initialization Packet (tentative Description) Parameter Packet (tentative Description) Long Data Packet (tentative Description) Execute Packet (tentative Description) Compression Logical Packets Prepared Statements And Stored Routines Statement Re-execution Requirements Preparation Of A Prepared Statement Execution Of A Prepared Statement Execution Of A Stored Procedure Statement Replication Main Code Files The Binary Log Replication Threads How Replication Deals With... How A Slave Asks Its Master To Send Its Binary Log Network Packets In Detail Replication Event Format In Detail Plans Myisam Storage Engine Myisam Record Structure The .myi File Myisam Compressed Data File Layout Innodb Storage Engine Innodb Record Structure Innodb Page Structure Writing A Custom Storage Engine Mysql Introduction Mysql Overview Creating Storage Engine Source Files Creating The Handlerton Handling Handler Instantiation Defining Filename Extensions Creation Of A Table Opening A Table Implementing Basic Table Scanning Closing A Table Adding Support For Insert To A Storage Engine Adding Support For Update To A Storage Engine What Are The Methods Of Supporting Non-sequential Reading? Methods Of Non Sequential Reads Supporting Indexing Supporting Transactions Api Reference Error Messages Adding New Error Messages To Mysql Adding Storage Engine Error Messages Mysql Interview Questions Mysql Practice Tests