Header Ads

Header ADS

SQL COMMAND, SOME SQL COMMAND.


Certainly! Here's a list of some common SQL commands along with brief descriptions:

1. **SELECT**: Retrieves data from one or more tables.
   - Example: `SELECT column1, column2 FROM table_name;`

2. **INSERT INTO**: Adds new records to a table.
   - Example: `INSERT INTO table_name (column1, column2) VALUES (value1, value2);`

3. **UPDATE**: Modifies existing records in a table.
   - Example: `UPDATE table_name SET column1 = value1 WHERE some_column = some_value;`

4. **DELETE**: Removes records from a table.
   - Example: `DELETE FROM table_name WHERE some_column = some_value;`

5. **CREATE TABLE**: Creates a new table with specified columns and data types.
   - Example: `CREATE TABLE table_name (column1 datatype, column2 datatype);`

6. **ALTER TABLE**: Modifies an existing table (e.g., adds or drops columns).
   - Example: `ALTER TABLE table_name ADD column_name datatype;`

7. **DROP TABLE**: Deletes an existing table and its data.
   - Example: `DROP TABLE table_name;`

8. **CREATE DATABASE**: Creates a new database.
   - Example: `CREATE DATABASE database_name;`

9. **USE**: Specifies the database to be used.
   - Example: `USE database_name;`

10. **ALTER DATABASE**: Modifies a database (e.g., changes its name).
    - Example: `ALTER DATABASE old_name MODIFY NAME = new_name;`

11. **DROP DATABASE**: Deletes an existing database.
    - Example: `DROP DATABASE database_name;`

12. **GRANT**: Provides specific privileges to a user or a group of users.
    - Example: `GRANT SELECT, INSERT ON table_name TO user_name;`

13. **REVOKE**: Removes specific privileges from a user or a group of users.
    - Example: `REVOKE SELECT ON table_name FROM user_name;`

14. **CREATE INDEX**: Creates an index on one or more columns of a table.
    - Example: `CREATE INDEX index_name ON table_name (column1, column2);`

15. **DROP INDEX**: Removes an existing index from a table.
    - Example: `DROP INDEX index_name;`

These are just some fundamental SQL commands; there are more advanced commands and variations depending on the specific relational database management system (RDBMS) you're using.

No comments

New post

Dubai

 Dubai, a mesmerizing metropolis nestled on the southeastern coast of the Arabian Peninsula, stands as a testament to human ambition and inn...

Theme images by enot-poloskun. Powered by Blogger.