Advertisement
Guest User

Untitled

a guest
Nov 21st, 2014
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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, ''' FIELDS ENCLOSED BY ''"'' TERMINATED BY '','' LINES TERMINATED BY ''\n''');
  4. PREPARE mySt FROM @sql;
  5. EXECUTE mySt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement