SQL commands are the fundamental building blocks for communicating with adatabase management system(DBMS). These commands perform various database operations, such as creating tables, inserting data, querying information, and controlling access and security. SQL commands can be categorized into different ...
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 ...