Breaking News
Home / Development / App Dev / What are the basic SQL commands?

What are the basic SQL commands?

Answer

The following is the list of basic SQL commands for an database.

  •    CREATE  – Creates a new table.
  •    ALTER    – Modifies the definition (structure, data types, and so on) of an existing table.
  •    DROP     – Permanently removes objects such as tables and fields.
  •    INSERT   – Adds a record to a table.
  •    UPDATE  – Modifies data in an existing record.
  •    SELECT   – Performs a query on a table, fecthes data/rows based on matching citeria.
  •    DELETE   – Permanently removes entries from a table.

<!>

[pb_builder]
Advertisment ad adsense adlogger