Guest User

Untitled

a guest
Aug 7th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. MySQL : ERROR 1064 (42000) SQL Syntax
  2. #!/bin/bash
  3.  
  4. path=$(pwd)
  5. find $path/ -type f ( -iname *.jp2 ) -exec ./insertjp2.sh {} ;
  6.  
  7. echo "finished!!"
  8.  
  9. #!/bin/bash
  10.  
  11. user="crea"
  12. password="crea"
  13. database="crea"
  14. dbhost="localhost"
  15. creator="crea"
  16.  
  17. param=$@
  18. basenam=${param##*/}
  19. filenam=${basenam%.*}
  20.  
  21. MYSQL=`/usr/bin/mysql -u$user -p$password -D$database -e"INSERT INTO assets (name,description,assetType,local,temporary,data,id,create_time,access_time​,asset_flags,CreatorID) VALUES ('$filenam','$filenam',0,0,0,LOAD_FILE('$param'),'$filenam',UNIX_TIMESTAMP(),1325304546,0,'$creator' );"`
  22.  
  23. echo $param >> assetadd.log
  24. echo $MYSQL
  25.  
  26. access_time​,asset_flags
  27. ^
Add Comment
Please, Sign In to add comment