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.