官术网_书友最值得收藏!

Overview of SQL

Structured Query Language (SQL) is used to manipulate, retrieve, insert, update, and delete data in relational database management system (RDBMS). To make it simpler, SQL tells the database what to do and exactly what it needs. SQL is a standard language that all RDBMS systems such as MySQL, MS Access, MS SQL, Oracle, Postgres, and others use.

Using SQL, the user can access, define and manipulate the data from MySQL. We can leverage SQL modules, libraries, and precompilers to embed with the other languages which help in creating/dropping databases and tables, manage view, stored procedures, function etc. in a database. Using SQL, we can also manage permissions on tables, procedures and different views.

The following are a few important SQL commands that we explain in detail later in the chapter:

  • SELECT: Extracts data from a database
  • UPDATE: Updates data from a database
  • DELETE: Removes existing records from a database
  • INSERT INTO: Add new information into a database
  • CREATE DATABASE: Creates a new database
  • ALTER DATABASE: Modifies or change characteristics of a database
  • DROP DATABASE: Delete a database
  • CREATE TABLE: Creates a new table
  • ALTER TABLE: Modifies or change characteristics of a table
  • DROP TABLE: Deletes a table
  • CREATE INDEX: Creates an index
  • DROP INDEX: Remove an index
主站蜘蛛池模板: 香港 | 神农架林区| 凌云县| 永德县| 万宁市| 永德县| 延津县| 新安县| 商城县| 含山县| 贡嘎县| 奎屯市| 谢通门县| 什邡市| 修水县| 永康市| 沂南县| 安图县| 西和县| 鄄城县| 峨边| 嘉鱼县| 南京市| 板桥市| 股票| 天祝| 沂水县| 毕节市| 东光县| 高密市| 社旗县| 团风县| 昌宁县| 汽车| 依安县| 邵东县| 罗江县| 海丰县| 永登县| 贵溪市| 黎城县|