Notes on SQL

March 12, 2019

Kurze SQL-Notizen fuer Praxis.

Begriffe

Schema = Struktur der Daten

Datenbank anlegen (CLI)

code

mysqladmin create DBNAME
mysqladmin drop DBNAME

SELECT (nur benoetigte Spalten)

code

SELECT id, firstname, lastname
FROM Employee;

Quotes

code

SELECT id FROM Employee;     -- Spalten/Tabellen
SELECT 'id' FROM Employee;   -- String literal
SELECT "Id" FROM Employee;   -- ANSI Quotes (nicht ueberall gleich)
SELECT `Id` FROM Employee;   -- MySQL-Backticks

Aliase

code

SELECT p.productname AS title
FROM Product AS p;

Link

https://frontendmasters.com/courses/sql-fundamentals/