SHOW:
|
|
- or go back to the newest paste.
| 1 | SET @save_table := 'rescue.calls'; | |
| 2 | SET @save_location := CONCAT('R:/CUS400/Rescue Tool/BACKUP/', DATE_FORMAT( NOW(), '%Y.%m.%d.%H.%i'), '.csv');
| |
| 3 | - | SET @sql := CONCAT('SELECT * FROM `', @save_table, '` WHERE datetime < NOW() - INTERVAL 1 MONTH INTO OUTFILE ''',@save_location, ''' ENCLOSED BY ''"'' FIELDS TERMINATED BY '','' LINES TERMINATED BY ''\n''');
|
| 3 | + | SET @sql := CONCAT('SELECT * FROM `', @save_table, '` WHERE datetime < NOW() - INTERVAL 1 MONTH INTO OUTFILE ''',@save_location, ''' FIELDS ENCLOSED BY ''"'' TERMINATED BY '','' LINES TERMINATED BY ''\n''');
|
| 4 | PREPARE mySt FROM @sql; | |
| 5 | EXECUTE mySt; |
