diff options
author | Erich Eckner <git@eckner.net> | 2019-10-15 21:09:03 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2019-10-15 21:09:03 +0200 |
commit | cdf932b9f13923d5e0d7178bd0ca5022ad4d0fc0 (patch) | |
tree | 688f7765c3a8f08465cb7abf00c515a8acea1259 | |
parent | 93b24d6e64f5fe51ce9dd078fa0347b0855b7af7 (diff) | |
download | Schraubendatenbank-cdf932b9f13923d5e0d7178bd0ca5022ad4d0fc0.tar.xz |
Inventur: fix mysql query
-rwxr-xr-x | Inventur | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -161,7 +161,7 @@ fehlende_Barcodes=$( if [ -n "${fehlende_Barcodes}" ]; then >&2 printf 'Ich vermisse:\n' for Typ in "${!Spalten[@]}"; do - printf 'SELECT "%s",*' "${Typ}" + printf 'SELECT "%s",`%sn`.*' "${Typ}" "${Typ}" printf ' FROM `%sn`' "${Typ}" printf ' WHERE `%sn`.`Barcode` IN (' "${Typ}" printf 'FROM_BASE64("%s"),' ${fehlende_Barcodes} \ |