Please enable JavaScript.
Coggle requires JavaScript to display documents.
OPERATIONS - Coggle Diagram
OPERATIONS
INSERT
Single
Insert
Into
Tbl
Optional
(col1, col2)
Values
(vals, ...)
Default
Null
Multiple
Values
Separated
Comma
(vals, ...),
Hierarchical
Related
Table
Different
Depends
LAST_INSERT_ID()
Copy
Subquery
Create
Table
tbl
As
Select
From
Insert
Into
tbl
Select
From
UPDATE
Single
Update
Set
col1 = val1, col2 = val2
Where
Condition
Tbl
Values
Default
Null
Calculate
SET
col1 = col2 * 3
Multiple
Where
Condition
General
id IN (1,2,3,4)
All
Remove
Where
Workbench
Disable
Safe
Updates
Subquery
Where
id
=
(Select ...)
IN
(Select ...)
DELETE
Truncate
Tbl
All
Delete
From
Tbl
Specific
Delete ...
Where
Condition
COLUMN
Attributes
PK
NotNull
Auto-Increment
Default/Expression
Datatype
Int
Varchar
Char
Date