PHP MySQL Basic Example

MySQL

1. MySQL Connect
2. Create Database
3. Connect to Database
4. Delete Database
5. Create Table
6. Insert Record
7. Insert From Array
8. Insert From File
9. Update Record
10. Query Single Record
11. Query Multiple Records
12. Query Uses LIMIT
13. Query Uses ORDER BY
14. Delete Table

Query Multiple Tables

1. Create Two Tables for this section tutorial
2. Query Uses AND Operator
3. Query Uses OR Operator
4. Query Uses INNER JOIN
5. Query Uses LEFT OUTER JOIN
6. Query Uses RIGHT OUTER JOIN
7. Query with Subquery

Aggregate

1. PHP MySQL Aggregate COUNT
2. PHP MySQL Aggregate SUM
3. PHP MySQL Aggregate MAX
4. PHP MySQL Aggregate MIN
5. PHP MySQL Aggregate AVG
6. PHP MySQL Query Uses GROUP BY
7. PHP MySQL Query Uses Having

Date

1. PHP MySQL Create Date
2. PHP MySQL Insert Date
3. PHP MySQL Query Date

All Tutorial Lists

• Tutorial Home
• HTML
• HTML5
• JavaScript
• jQuery

• PHP
• Java
• Learning C
• C++

• MySQL
• PostgreSQL

• Linux Basic Security
• References
• Web Hosting Service

Reference

• EMC
• Linux
• Alfresco
• FTP
• DNS

• HTML Reference
• CSS Reference
• PHP Reference
• MySQL Reference
• PostgreSQL Reference