Street N.

Key Skills

Freelancer Overview

SQL cheat sheet Comprehensive Data Manipulation Language DML Commands Command Description Syntax Example SELECT TheSELECTcommandretrieves SELECT column1, column2 FROM SELECT first_name, last_name datafromadatabase. table_name; FROM customers; INSERT TheINSERTcommandaddsnew INSERT INTO table_name INSERT INTO customers recordstoatable. (column1, column2) VALUES (first_name, last_name) (value1, value2); VALUES ('Mary', 'Doe'); UPDATE TheUPDATEcommandisused UPDATE table_name SET column1 UPDATE employees SET tomodifyexistingrecordsina = value1, column2 = value2 employee_name = ‘John Doe’, table. WHERE condition; department = ‘Marketing’; DELETE TheDELETEcommandremoves DELETE FROM table_name WHERE DELETE FROM employees WHERE recordsfromatable. condition; employee_name = ‘John Doe’; Data Definition Language DDL Commands Command Description Syntax Example CREATE TheCREATEcommandcreatesa CREATE TABLE table_name CREATE TABLE employees ( newdatabaseandobjects,such (column1 datatype1, employee_id INT asatable,index,view,orstored column2 datatype2, ); PRIMARY KEY, procedure. first_name VARCHAR(50), last_name VARCHAR(50), age INT ); ALTER TheALTERcommandadds, ALTER TABLE table_name ALTER TABLE customers ADD deletes,ormodifiescolumnsin ADD column_name datatype; email VARCHAR(100); anexistingtable. DROP TheDROPcommandisusedto DROP TABLE table_name; DROP TABLE customers; dropanexistingtableina database. TRUNCATE TheTRUNCATEcommandis TRUNCATE TABLE TRUNCATE TABLE customers; usedtodelete