Structured Query Language, or SQL, is a widely used language the allows users to query and manage data in a database. Databases such as MySQL, MariaDB, SQLite, PostgreSQL, Oracle, and Microsoft SQL Server are all based on the SQL standard, with some slight variations. This resource uses the MySQL flavor of SQL.

I’ve created an overview resource to quickly be able to reference the appropriate syntax for the most popular SQL commands, and code to use the PDO class in PHP to securely connect to and work with a database.

To see PHP and MySQL in action, view the Creating a Simple Database Application from Scratch tutorial - Part One: Create and Read and Part Two: Update and Delete.

You can view the commands alone without explanations on GitHub through the below link.

View on GitHub
The logo in this article is of Sequel Pro, an awesome free MySQL GUI for Mac.

#php #database #sql #reference

SQL and PDO Operations Reference
1.50 GEEK