MySQL Useful Commands



Here are some useful MySQL commands:
  1. SELECT - used to select data from a database
  2. INSERT INTO - used to insert data into a table
  3. UPDATE - used to modify existing data in a table
  4. DELETE - used to delete data from a table
  5. CREATE DATABASE - used to create a new database
  6. DROP DATABASE - used to delete an existing database
  7. CREATE TABLE - used to create a new table
  8. ALTER TABLE - used to modify the structure of an existing table
  9. DROP TABLE - used to delete an existing table
  10. USE - used to select a database to work with
  11. SHOW DATABASES - used to display a list of all databases
  12. SHOW TABLES - used to display a list of all tables in a database
  13. DESCRIBE - used to show the structure of a table
  14. GRANT - used to grant privileges to users
REVOKE - used to revoke privileges from users.
It is important to note that these commands should be used with caution, as they can permanently modify or delete data. It's always a good idea to backup your data before making any changes.



Post a Comment (0)
Previous Post Next Post