SQL Commands SQL commandsare instructions that are used to communicate with the database. They are also used to perform specific tasks, functions, and queries on the data. SQL commands allow you to do things like create a table, add data to tables, drop the table, modify the table, and ...
3 types of Commands DDL DML DCL DDL CREATE ALTER DROP Date and Time Dates: 'YYYY MM DD' e.g. '1975 05 17' Times: ‘hh:mm:ss[.f] ' e.g. '15:00:00' Timestamp: ‘YYYY MM DD hh:mm:ss[.f] ' e.g. ‘1975 05 17 15:00:00' To add date DATE_ADD(date, INTERVAL expr ...