SQL Common Commands

First, the SQL concept

SQL is the standard computer language for accessing and working with databases

Second, SQL common commands

1. SELECT-Extract data from the database
2. Update-Updates the data in the database
3. Delete-Deletes data from the database
4. INSERT INTO-inserts new data into the database
5. Create database-Creating new databases
6. ALTER DATABASE-Modify databases
7. CREATE table-Creates a new table
8. ALTER TABLE-Change (change) database table
9. drop table-Delete tables
10. Create index-Creating indexes (search key)
11. Drop INDEX-Delete indexes

SQL Common Commands