Below are some additional SQL commands that can give you some info that are not possible from inside Open Enventory
LIKE 'FH-2206%' would mean find anything with storage name ending with FH-2206SELECT * FROM chemical_storage WHERE borrowed_by_person_id=8UPDATE chemical_storage SET borrowed_by_person_id=NULL WHERE borrowed_by_person_id=8SELECT * FROM chemical_storage WHERE owner_person_id=7UPDATE chemical_storage SET owner_person_id=NULL WHERE owner_person_id=7SELECT person_id FROM person WHERE username='julia'SELECT storage_id FROM storage WHERE storage_name LIKE 'FH-2206%'SELECT * FROM chemical_storage
WHERE owner_person_id=15 AND storage_id NOT LIKE 18UPDATE chemical_storage
SET owner_person_id='NULL'
WHERE owner_person_id=15 AND storage_id NOT LIKE 18SELECT storage_name,storage_id
FROM storage
WHERE storage_id IN
(SELECT storage_id
FROM chemical_storage
WHERE owner_person_id in
(SELECT person_id FROM person WHERE username='mingzhao')
)
GROUP BY storage_nameUPDATE chemical_storage
SET owner_person_id=null
WHERE owner_person_id=13 AND storage_id IN (19,7,5,4,12,8)SELECT chemical_storage_barcode
FROM chemical_storage
WHERE chemical_storage_disabled IS NULL AND chemical_storage_barcode != ""
GROUP BY chemical_storage_barcode
HAVING Count(*) > 1;SELECT molecule_id,
chemical_storage_id,
chemical_storage_created_when,
chemical_storage_created_by,
chemical_storage_barcode
FROM chemical_storage
WHERE chemical_storage_barcode IN
(SELECT chemical_storage_barcode
FROM chemical_storage
WHERE chemical_storage_disabled IS NULL AND chemical_storage_barcode != ""
GROUP BY chemical_storage_barcode
HAVING Count(*) > 1
) AND
chemical_storage_created_by = "user1" AND
chemical_storage_created_when > '2019-08-16 18:00:00'
ORDER BY chemical_storage_barcode;mysql –u root -pshow databases;
use test;truncate table chemical_storage;
truncate table cache;
truncate table change_notify;alter table chemical_storage auto_increment=1exitsystemctl restart httpd mariadbSELECT chemical_storage_id, chemical_storage_barcode, count(chemical_storage_barcode) as NumOccurrences
from `chemical_storage`
WHERE chemical_storage_disabled is NULL
GROUP BY chemical_storage_barcode
HAVING (COUNT(chemical_storage_barcode) > 1)