MySQL Forge

Resources for the MySQL Community

MySQL User Guide Part II Using MySQL

Back to MySQL User Guide

Contents 1 Part II. Using MySQL 1.1 Introduction to Using MySQL 1.2 Variations Between Operating Systems 1.3 Working From the Command Line 1.4 Using Query Browser 1.5 Sample Schema 1.6 Populating a Schema 1.7 Populating a Schema with a SQL File 1.8 Querying Data 1.9 Using SELECT 1.9.1 The SELECT Clause 1.10 Functions in Queries 1.11 Aggregate Functions in Queries 1.12 Using User Variables 1.13 Subqueries 1.14 Data Types 1.15 Data Type> 1.16 Operators 1.17 Operator Type> 1.18 Functions 1.19 Function Type> 1.20 Modifying Data 1.21 Adding Data with the INSERT Statement

[edit] Part II. Using MySQL

[edit] Introduction to Using MySQL

[edit] Variations Between Operating Systems

MySQL functions slightly differently on different operating systems. For the most part these differences can be ignored but you should be aware of the following items:

• sockets
• auto-completion
• file separators
• etc

[edit] Working From the Command Line

[edit] Using Query Browser

[edit] Sample Schema

[edit] Populating a Schema

[edit] Populating a Schema with a SQL File

[edit] Querying Data

[edit] Using SELECT

[edit] The SELECT Clause

[edit] Functions in Queries

[edit] Aggregate Functions in Queries

[edit] Using User Variables

[edit] Subqueries

[edit] Data Types

[edit] Data Type>

[edit] Operators

[edit] Operator Type>

[edit] Functions

[edit] Function Type>

[edit] Modifying Data

[edit] Adding Data with the INSERT Statement