Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @save_table := 'rescue.calls';
- SET @save_location := CONCAT('R:/CUS400/Rescue Tool/BACKUP/', DATE_FORMAT( NOW(), '%Y.%m.%d.%H.%i'), '.csv');
- 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''');
- PREPARE mySt FROM @sql;
- EXECUTE mySt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement