Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- exec("/csvexport.sh $table");
- #!/bin/bash
- table=$1
- 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
- $query = "SELECT field1, field2, IF(field3 = '0000-00-00','0001-01-01',field3) AS field3 FROM mytable;";
- exec("/csvexport.sh $query $table");
- #!/bin/bash
- query=$1
- table=$2
- mysql --database=db --user=user --password=pass -B -e "$query" | sed "s/'/'/;s/t/","/g;s/^/"/;s/$/"/;s/n//g" > /home/backups/$table.csv
- sh: -c: line 0: syntax error near unexpected token `('
Add Comment
Please, Sign In to add comment