diff options
author | Andrejs Kozlovs <andrejs.kozlovs@zabbix.com> | 2020-11-02 18:21:48 +0300 |
---|---|---|
committer | Andrejs Kozlovs <andrejs.kozlovs@zabbix.com> | 2021-01-13 18:04:33 +0300 |
commit | 91237050885d4da50fe516a96e9e4a4be43d4cd8 (patch) | |
tree | 1dff046139e183ca874d3c16b13ce3514fd171fe /misc | |
parent | db8ce4d9e0c055d290091c35ea4b4d716af0db0b (diff) |
....I..... [ZBXNEXT-6285] change to be compliant with current mysql images
Diffstat (limited to 'misc')
-rwxr-xr-x | misc/images/png_to_sql.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/misc/images/png_to_sql.sh b/misc/images/png_to_sql.sh index 4f3d594ffb4..08ca657cd2f 100755 --- a/misc/images/png_to_sql.sh +++ b/misc/images/png_to_sql.sh @@ -40,7 +40,7 @@ for imagefile in $pngdir/*.png; do rm -rf tmp_b64 # ----- MySQL - echo "INSERT INTO 'images' ('imageid','imagetype','name','image') VALUES ($imagesdone,1,'$imagename',0x$image_data);" >> "$imagefile_mysql" + echo "INSERT INTO \`images\` (\`imageid\`,\`imagetype\`,\`name\`,\`image\`) VALUES ($imagesdone,1,'$imagename',0x$image_data);" >> "$imagefile_mysql" # ----- PostgreSQL echo "INSERT INTO images (imageid,imagetype,name,image) VALUES ($imagesdone,1,'$imagename',decode('$image_data','hex'));" >> "$imagefile_pgsql" # ----- Oracle |