← All Shortcuts

SQL Keyboard Shortcuts & Commands (10)

10 SQL shortcuts and commands.

All Shortcuts

Queries

Shortcut	Action	Description
SELECT * FROM table	Select all	Query all data from a table.
WHERE condition	Filter	Filter data by condition.
JOIN table ON condition	Join	Join two tables.
GROUP BY column	Group	Group by column.
ORDER BY column DESC	Sort	Sort in descending order.
INSERT INTO table VALUES	Insert	Insert data.
UPDATE table SET	Update	Update data.
DELETE FROM table WHERE	Delete	Delete data.
CREATE TABLE	Create table	Create a new table.
ALTER TABLE ADD COLUMN	Add column	Add a column.