SHOW:
|
|
- or go back to the newest paste.
| 1 | - | A) CREATE INDEX idx_1 ON user_info(register_date); |
| 1 | + | CREATE TABLE user(id INT PRIMARY KEY, name VARCHAR, reg_time DATETIME DEFAULT CURRENT_TIMESTAMP); |
| 2 | - | B) CREATE INDEX idx_2 ON user_info(name, register_date); |
| 2 | + | |
| 3 | - | C) CREATE INDEX idx_3 ON user_info(register_date, name); |
| 3 | + | SELECT * FROM user WHERE ... |
| 4 | - | D) CREATE INDEX idx_4 ON user_info(name); |
| 4 | + | |
| 5 | - | E) CREATE UNIQUE INDEX idx_5 ON user_info(id); |
| 5 | + | (reg_time >= DATE_SUB(..., INTERVAL ...)) |
| 6 | - | F) CREATE INDEX idx_6 ON user_info(id); |
| 6 | + | (reg_time >= NOW() - INTERVAL 24 HOUR) |
| 7 | - | G) CREATE INDEX idx_7 ON user_info(name, id); |
| 7 | + | (DATEDIFF(NOW(), reg_time) <= ...) |
| 8 | - | H) CREATE INDEX idx_8 ON user_info(id, name); |
| 8 | + | (TIMESTAMPDIFF(HOUR, NOW(), reg_time) ...) |
