- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 210字
- 2021-08-20 10:06:09
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
- Oracle從入門到精通(第3版)
- Raspberry Pi Networking Cookbook(Second Edition)
- JavaScript 網頁編程從入門到精通 (清華社"視頻大講堂"大系·網絡開發視頻大講堂)
- 算法訓練營:入門篇(全彩版)
- 匯編語言程序設計(第2版)
- 信息安全技術
- Bootstrap 4:Responsive Web Design
- Java Web程序設計任務教程
- 前端HTML+CSS修煉之道(視頻同步+直播)
- 移動互聯網軟件開發實驗指導
- SciPy Recipes
- OpenStack Networking Essentials
- Vue.js 3應用開發與核心源碼解析
- C語言程序設計與應用實驗指導書(第2版)
- Java并發實現原理:JDK源碼剖析