What are the different types of MySQL commands elaborate
Answers
Hello!
Here is the answer for your question!
≫ ──── ≪•◦ ❈ ◦•≫ ──── ≪
Q) What are the different types of MySQL commands elaborate
≫ ──── ≪•◦ ❈ ◦•≫ ──── ≪
Answer:-
# SQL commands can be classified into the following:
Data Definition Language (DDL): They are used to create tables, databases, identify data items, provide unique names to the data items and to define the length and provide the range of values that each data item can assume. They are CREATE TABLE, ALTER TABLE and DROP TABLE command
Data manipulation language (DML) : handles operations such as entering rows into a table, changing data, deleting rows, and extracting data from rows and tables.
≫ ──── ≪•◦ ❈ ◦•≫ ──── ≪
Hope this clarified your doubt :)
Answer: the two types of commands are ddl and dml commands