Libraries
HTML Library
CSS Library
JavaScript Library
PHP Library
Videos
PHP and MySQL
JavaScript
HTML and CSS
Vector and 3D
Flash Actionscript
Android Dev
Miscellaneous
Resources
Website Hosting
MySQL Library
Table of Contents
Introduction to MySQL
Basics of MySQL Interaction
MySQL Query Examples
Introduction to MySQL
What is a MySQL Database? And why would I use it?
PHPMyAdmin: MySQL Database Management Software
Creating a MySQL Database In Your Hosting Control Panel
MySQL Data Types
Back Up or Manually Make Copy of MySQL Databases Just in Case
Basics of MySQL Interaction
Connecting to Your Database
Closing a MySQL Connection
Creating Tables Through Script
Insert Information into a MySQL Database
Output or Retrieve Database Information
Update Existing Database Information
Delete Database Information
Freeing Result Sets for Large Data Queries
MySQL Query Examples
Obtain a Table Row Count
Obtain a Table Row Count From a Query Result Set
Using LIMIT to Obtain a Specific Result Set
Using the WHERE Clause with SELECT to Target Data
Selecting Individual Fields for Optimized Queries
Show Alternate Field if Target Field is Empty
Select Random Entries From the MySQL Database
Perform Arithmetic On MySQL Numeric Values (hit counter example)
List the Newest or Oldest Items From a Database Table
Home
•
Terms of Use
•
Developer Forums
•
T-Shirts
•
RSS
•
Classroom Chalkboard
•
Donate
•
Top ↑
Popular In PHP / MySQL
E-Commerce Store Production
Social Network Website Building
Image Upload / Photo Processing
CMS Software Programming
Mass Email Systems
Magic XML Data
Search Programming
Popular In JavaScript
JSON Programming
Ajax Programming
Animating Elements
WYSIWYG Programming
Date/Time Programming
DOM Scripting
Object Reference
Popular In HTML
Canvas Element
New Form Elements
Audio Element
Video Element
Drag and Drop
Event Handling
Element Grouping
Popular In CSS
Custom Font Embedding
Dynamic Fit Backgrounds
Theatre Mode
Box Overlays
CSS Level 1 Properties
CSS Level 2 Properties
CSS Level 3 Properties
Introduction to MySQL Basics of MySQL Interaction MySQL Query Examples