MySql HowTo

MySQL How To in online HTML version. Quite complete scratch tutorial on MySql, covers

• Creating a Database in MySQL
• Creating Tables
• A Special Feature in MySQL
• Viewing the Tables and Databases Created
• Inserting Values to the Tables
• Querying the Tables
• Comparison Operators
• Logical Operators
• Limiting the Search Area of the Table
• Pattern Matching
• User Defined Variables
• Summarizing Techniques
• Deleting and Updating the Rows
• How You Can Simplify the Connection Process
• Storing the Parameters in an Option File
• Repeating Parameters using History
• Ways of Avoiding Long Typing for the Statements
• Running in Batch Code
• MySQL Syntax
• Naming Conventions
• Case Sensitive SQL Statements
• The Mode of SQL
• Character sets Supported by SQL
• Handling Tables
• Creation of the Tables
• Merging Tables
• Federated Tables
• Dropping the Tables
• Retrieving Information about Databases and Tables
• Joins
• Trivial Join
• Cross Join
• Left Joins and Right Joins
• Usage of Sub Queries
• In and Not In
• Exists and Not Exists
• Multiple table Deletion and Updating
• Transactions in Mysql
• Transaction Save Points
• Transaction Isolation
• Relative Updates Instead of Absolute Updates
• Foreign Keys and Referential Integrity
• Fulltext Searches
• Natural Language Searching
• Boolean Mode Searching
• Query Expansion Searching
• Things to Consider for Boolean Mode Searches
• Query Expansion Fulltext Search
• New Features in Mysql
• Stored Procedures
• Triggers
• Data Value in Mysql
• Numerical Values
• String Values
• Binary and Non Binary Strings
• Date and Time Values
• Spatial Values
• Null Values
• Data Types in Mysql
• Data Types for Numerical Values
• Data Types for String Values
• Data Types for Date and Time Values
• Data Types for Spatial Values
• Numerical Data Types
• Integer Data Type
• Floating Point and Fixed Point Data Types
• Fixed Point Type –Decimal
• Bit Data Type
• Attributes of Numerical Data Types
• String Data Types
• Char and Varchar Data Types
• Binary and Varbinary Data Types
• The BLOB and TEXT Data Types
• The ENUM and SET Data Types
• String Data Type Attributes
• Date and Time Data Types
• Date, Time and Datetime data types
• Timestamp Data Type
• Year Data Type
• Handling Invalid Data Types
• Working with Sequences in Mysql
• Auto_increment
• Expression Evaluation and Type Conversion
• Arithmetic Operators
• Logical Operators
• Bit Operators
• Comparison Operators
• REGEXP
• Type Conversion
• Query Optimization
• Loading Data Efficiently and Scheduling and Locking Issues

I have similar tutorial in pdf file, but I wasn’t able to find it in my computer, consider it was downloaded before. So I can’t compare tutorial above with the one that has been missing.

Where to Read Free?

Read online: MySql HowTo