Skip to main content

MySQL 5.6 Reference Manual

MySQL Database Tutorial - 1 - Introduction to Databases 
MySQL Database Tutorial - 2 - Getting a MySQL Server 
MySQL Database Tutorial - 5 - Basic Rules for SQL Statements 
MySQL Database Tutorial - 6 - Getting Multiple Columns 
MySQL Database Tutorial - 7 - DISTINCT and LIMIT 
MySQL Database Tutorial - 8 - Sorting Results 

MySQL Database Tutorial - 9 - Sort Direction 
MySQL Database Tutorial - 10 - Basic Data Filtering and WHERE 
MySQL Database Tutorial - 11 - Advanced Filtering Using AND and OR 
MySQL Database Tutorial - 12 - Are you IN or are you NOT IN? 
MySQL Database Tutorial - 13 - How Search Engines Work 
MySQL Database Tutorial - 14 - More on Wildcards 
MySQL Database Tutorial - 15 - Regular Expressions 
MySQL Database Tutorial - 16 - Creating Custom Columns 
MySQL Database Tutorial - 17 - Functions 
MySQL Database Tutorial - 18 - More on Aggregate Functions 
MySQL Database Tutorial - 19 - GROUP BY 
MySQL Database Tutorial - 20 - Subqueries 
MySQL Database Tutorial - 21 - Another Subquery Example 
MySQL Database Tutorial - 22 - How to Join Tables 
MySQL Database Tutorial - 23 - Outer Joins 
MySQL Database Tutorial - 24 - UNION 
MySQL Database Tutorial - 25 - Full-Text Searching 
MySQL Database Tutorial - 26 - INSERT INTO 
MySQL Database Tutorial - 27 - How to Insert Multiple Rows 
MySQL Database Tutorial - 28 - UPDATE & DELETE 
MySQL Database Tutorial - 29 - CREATE TABLE 
MySQL Database Tutorial - 30 - NOT NULL & AUTO INCREMENT 
MySQL Database Tutorial - 31 - ALTER / DROP / RENAME TABLE 
MySQL Database Tutorial - 32 - Views 
MySQL Database Tutorial - 33 - Final Video! 

Comments

Popular posts from this blog

Introduction to PHP PDO

Introduction to PHP PDO
(PHP Data Objects)


1. What is PDO
2. What Databases does PDO support
3. Where do I begin?
4. Connect to a Database
* Connect to PgSQL
* Connect to SQLite
* Connect to MySQL
* Connect to Firebird
* Connect to Informix
* Connect to Oracle
* Connect to ODBC
* Connect to DBLIB
* Connect to IBM
5. There is no five
6. Close a Database Connection
7. Query a Database
* INSERT
* SELECT
* UPDATE
8. Fetch Modes
* FETCH ASSOC
* FETCH NUM
* FETCH BOTH
* FETCH OBJECT
* FETCH LAZY
* FETCH CLASS
* FETCH INTO
9. Error Handling
10. Prepared Statements
11. Transactions
12. Get Last Insert ID
13. Global Instance
14. Conclusions

What is PDO.

PDO is a PHP extension to formalise PHP's database connections by creating a uniform interface. This allows developers to create code which is portable…

Securely Communicating with Remote Servers via PHP

PHP has an SSH2 library which provides access to resources (shell, remote exec, tunneling, file transfer) on a remote machine using a secure cryptographic transport. Objectively, it is a tedious and highly frustrating task for a developer to implement it due to its overwhelming configuration options and complex API with little documentation.
The phpseclib (PHPSecure Communications Library) package has a developer friendly API. It uses some optional PHP extensions if they’re available and falls back on an internal PHP implementation otherwise. To use this package, you don’t need any non-default PHP extensions installed. Installationcomposer require phpseclib/phpseclib This will in