Insert
| Hint |
put is often a better choice, as it prevents duplication of existing columns. |
|---|---|
| Command |
insert {column} … insert {column} … before {column} insert {column} … after {column} |
| Alternative |
ins … - alias for insert add … - add columns to the right of a table append … - alias for add |
Purpose |
Insert new columns into a table. The default target of the insert (and ins) command is before first, i.e. to the left of a table. The default target of the add and append commands is after last, i.e. to the right of a table. |
| Playground |
|