Guest User

Untitled

a guest
Jun 18th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. exec("/csvexport.sh $table");
  2.  
  3. #!/bin/bash
  4. table=$1
  5.  
  6. mysql --database=db --user=user --password=pass -B -e "SELECT field1, field2, IF(field3 = '0000-00-00','0001-01-01',field3) AS field3 FROM mytable;" | sed "s/'/'/;s/t/","/g;s/^/"/;s/$/"/;s/n//g" > /home/backups/$table.csv
  7.  
  8. $query = "SELECT field1, field2, IF(field3 = '0000-00-00','0001-01-01',field3) AS field3 FROM mytable;";
  9. exec("/csvexport.sh $query $table");
  10.  
  11. #!/bin/bash
  12. query=$1
  13. table=$2
  14.  
  15. mysql --database=db --user=user --password=pass -B -e "$query" | sed "s/'/'/;s/t/","/g;s/^/"/;s/$/"/;s/n//g" > /home/backups/$table.csv
  16.  
  17. sh: -c: line 0: syntax error near unexpected token `('
Add Comment
Please, Sign In to add comment