This is where you will find SQL code examples and snippets for MySQL 5.1, MySQL 5.0 and MySQL 4.1. Our examples are based upon our training manager database which you can download from here. You can also download the data to load into the database as well.

Course Registration Database

SQL DML	String Functions	Stored Procedures
Select Update Insert Delete	Substring function Upper and Lower functions LTRIM and RTRIM functions	Select stored procedure Update stored procedure Insert stored procedure Delete stored procedure
SQL VIEWS	SQL TABLE BASICS
SQL Views - Basics	Create SQL Table Foreign Key Constraint Data Types Add / Alter Column Drop Table

SQL Server Information and Resources Bookmark this page

SQLINFO.net is a Community Service from DataExpressions makers of dbOrchestra©

MySQL Code Examples

SQL Code Examples for MySQL

SQL DML

String Functions

Stored Procedures

SQL VIEWS

SQL TABLE BASICS