MySQL (Structured Query Language)

MySQL Documentation

display the mysql version
German v5.1 - MySQL 5.1 Referenzhandbuch

2.3. Installation von MySQL unter Windows

Damit MySQL unter Windows läuft, muss die Datei "libmysql.dll" von PHP in den Ordner
"C:\WINDOWS\system32" kopiert werden.

Default PHP extensions settings for MySQL in php.ini

Installation of extensions on Windows

• php_gd2.dll (GD library image functions)
• php_mbstring.dll (Multi-Byte String functions)
• php_mysql.dll (MySQL functions)

B.1.2. Common Errors When Using MySQL Programs

A.2.3. Client does not support authentication protocol

Data Types - 11. Data Types
Numeric Types - 11.2. Numeric Types
String Types - 11.4. String Types

create database - 13.1.3. CREATE DATABASE Syntax
drop database - 13.1.6. DROP DATABASE Syntax
create table - 13.1.5. CREATE TABLE Syntax
drop table - 13.1.8. DROP TABLE Syntax
alter table - 13.1.2. ALTER TABLE Syntax // to change the structure of an existing table
Example:

rename table - 13.1.9. RENAME TABLE Syntax

select - 7.2.1. EXPLAIN Syntax (Get Information About a SELECT)
insert - 13.2.4. INSERT Syntax
join - 13.2.7.1. JOIN Syntax
update - 13.2.10. UPDATE Syntax
delete - 13.2.1. DELETE Syntax

12.1. Operators
LIKE - 12.3.1. String Comparison Functions
Suchtext Abfrage - 12.7. Full-Text Search Functions
REGEXP - Appendix G. Regular Expressions

MySQL Date and Time Functions

5.3.3. Server System Variables
3.3.4.5. Date Calculations
generate a month list - 12.5. Date and Time Functions

MySQL Backup

8.11. mysqldump — A Database Backup Program
5.8.5. mysqldump, Tabellenstrukturen und -daten dumpen
Example for mysqldump

Links:
MySQL Backup - [phpBB.de]
bigdump - [phpBB.de]
MySQL-Front - [phpBB.de]

Delicious MySQL feed

Example from: jQuery Clone to Add Dynamic Data - JSON Files via Javascript / jQuery