summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-10-15 21:09:03 +0200
committerErich Eckner <git@eckner.net>2019-10-15 21:09:03 +0200
commitcdf932b9f13923d5e0d7178bd0ca5022ad4d0fc0 (patch)
tree688f7765c3a8f08465cb7abf00c515a8acea1259
parent93b24d6e64f5fe51ce9dd078fa0347b0855b7af7 (diff)
downloadSchraubendatenbank-cdf932b9f13923d5e0d7178bd0ca5022ad4d0fc0.tar.xz
Inventur: fix mysql query
-rwxr-xr-xInventur2
1 files changed, 1 insertions, 1 deletions
diff --git a/Inventur b/Inventur
index 794efa1..2c99328 100755
--- a/Inventur
+++ b/Inventur
@@ -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} \