Advertisement
Guest User

Untitled

a guest
Aug 15th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. #!/bin/sh
  2. datafile="/time.txt"
  3. SQLUSER="root"
  4. SQLPASS=""
  5. SQLHOST="mysql-server.localdomain"
  6. cat $datafile |while true
  7. do read LINE || break
  8. echo "INSERT INTO `OA`.`windspeed` (`id`, `time`, `windspd`) VALUES (NULL, CURRENT_TIMESTAMP, '$LINE');"\
  9. exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement