Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
DML(Data Manipulation Language)
UPDATE
UPDATE TableNme SET col1 = Val1 WHERE .....
DELETE
DELETE FROM TableName WHERE .....
INSERT
INSERT INTO TableName VALUES (Val1,Val2,Val3...)
INSERT INTO TableName(Col1,Col2,Col3,..) SELECT Val1,Val2,Val3.. FROM TableName....
INSERT INTO TableName(Col1,Col2,Col3,...) VALUES (Val1,Val2,Val3)
Call
Explain call
Lock
DDL(Data Definition Language)
ALTER
ADD
ADD CONSTRAINT
DROP COLUMN
ALTER COLUMN
Truncate
TRUNCATE TABLE TableName
DROP
DROP TABLE TableName
DROP VIEW ViewName
DROP INDEX IndexName ON TableName
DROP DATABASE DatabaseName
CREATE
CREATE VIEW ViewName AS SELECT ....
CREATE INDEX IndexName ON TableName(Column1,Column2..)
CREATE TABLE TableName(ColumnName dataType, ...)
CREATE DATABASE DatabaseName
Primary Key
TCL(Trasaction Control Language)
Rollback
Set Trasaction
Savepoint
Set Constraint
Commit
Data Control Language)
GRANT
GRANT type of permissiion ON Database.tableName TO
UserName@HostName
Revoke
REVOKE type of permission ON DatabaseName.Database.tabelName FROM
userName@hostName
CREATE USER
CREATE USER 'UserName'
'HostName'
IDENTIFIED BY '密碼'
DROP USER
DROP USER
UserName@HostName
Other
Store Procedure
Function
DQL(Data Query Language)
Select
優化
Join
Union