Introduction of SQL - Suja-dot/Database GitHub Wiki

What is SQL?

  • SQL is Structured Query Language
  • SQL is used to access and manipulate a database
  • MySQL is a program that understands SQL

Primary Keys

  • unique value for each row
  • cannot contain NULL values
  • Tables are limited to ONE primary key each

SQL can

- insert, update, or delete records in a database.

- create new databases, table, stored procedures, views.

- retrieve data from database