MYSQL

Basic Notes

SQL subcategories

• DDL: Data definition language: create the table, alter and drop.
• DCL: Data Control Language: grant, revoke
• DML: Data Management Language. insert, update, delete, get

Recommended style: snake case, lowercase

Second most popular: camel case

select * from table_name

This will return all the entries in the given table_name.

MYSQL vs SQL

SQL is a structured query language to manage a relational database.

MYSQL is a relational database management system to store the data retreive modify using sql. MYSQL is a platform, software, providing an integrated tool environment designed to model databases. Also provides database drivers in .net .php, c++, Python ,Java to build a database applications.

Database Drivers: We pass a query string to connect with a language of the front end.

Primary Key: We identify the table using the primary key and the foreign key.

Has aliases to shorten names that are too long..

Has aggregate functions (min (), max(), count(), sum(), avg())

SQL syntax

-- This is how to make a comment
select * from customers
-- * grabs all the columns
-- 

You can comment out multiple lines of SQL in multiple ides with control k.

To grab a specific column in the table we can use the following syntax.

select name_of_column from table_name