CREATE TABLE, Create a table with columns and data types, ALTER TABLE, Modify an existing table, MODIFY, Change a column's data type or definition, DROP COLUMN, Remove a column from a table, DROP TABLE, Permanently remove a table, TRUNCATE TABLE, Remove all records while keeping the table structure, SELECT, Retrieve data from a table, WHERE, Filter individual records, DESC, Sort descending, INSERT, Add new records, INSERT INTO, Insert values into specific columns, DELETE, Remove selected records, INNER JOIN, Return matching records from both tables, FULL OUTER JOIN, Return records from both tables, matched or unmatched

SQL

par
Imprimer
Incorporer

Style visuel

Afficher tout
Paramètres d’activité Classement Affectations

Paramètres d’activité

Classement

Changer de modèle

Restauration auto-sauvegardé :  ?