Coggle requires JavaScript to display documents.
ALTER TABLE table_name ADD new_colum data_type column_constraint [AFTER existing_column];
ALTER TABLE table_name MODIFY column_definition;
ALTER TABLE table_name DROP column_name;
CONSTRAINT pk_assgn PRIMARY KEY (project_id , employee_id)
ALTER TABLE project_milestones ADD PRIMARY KEY (milestone_id); ==> ou : ADD CONSTRAINT pk_milestone_id PRIMARY KEY (milestone_id);
ALTER TABLE table_name DROP CONSTRAINT primary_key_constraint;
SELECT column1, AGGREGATE_FUNCTION(column2) FROM table1 GROUP BY column1 HAVING group_condition; Exemple ==> GROUP BY department_id **HAVING MIN(salary) >= 10000** ; ==> GROUP BY department_id **HAVING SUM(salary) BETWEEN 20000 AND 30000**
SELECT salary FROM employees ORDER BY salary DESC;