MYSQL

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 commentselect * 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

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

SQL Injection

Ruby on Rails for FinTech Products: Why you should use for Startups

Discord Bot Basics: Generating an Invite Link for your Bot

How to Find Bugs Before the Customer Does

Scrum Artifacts | What Are They & How to Incorporate Them in Agile Framework?

Work with date command

BURN THEM ALL — Sprint slayer🗡️

Free ways to start learning computer programming

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Scott

Scott

More from Medium

UpGrad Clone

forGood App

Introduction to GIT and Version Controlling

CS 373 Spring 2022: Alejandro Cantu