INSERT
UPDATE
SELECT
id
", "ID
"TableName_id
", "_ID
"
TableNameId
"INT
type to use?
JOIN
s
PRIMARY KEY
NULL
INDEX
UNIQUE INDEX
NULL
FOREIGN KEY
AUTO_INCREMENT
ID
ID
will be auto generated
NULL
DEFAULT CHARSET
ALTER TABLE GridData ADD INDEX `TimeseriesData_Grid_IX`(`GridBox_ID`);
FOREIGN KEY
OPTIMIZE TABLE TableName;
INSERT
- code
CSV
, JSON
,...
Full Extraction | Partial Extraction | |
Implementation | Easier | Harder |
Speed | Slower | Faster |
Efficiency | Less | More |
Data set size | Large | Small |
Errors | Less | More |
s_
" for staging
f_
" if final table
SELECT * FROM {table_name};
SELECT * FROM users;
SELECT * FROM {users; SHOW TABLES;}