LogoLogo
Modified Version by KVOriginal Source CodeContact
Modified Version by KVOriginal Source CodeContact
KV.2020-02-01
KV.2019-12-01KV.2020-02-01
KV.2020-02-01
KV.2019-12-01KV.2020-02-01
  • Overviews
  • Download
  • Contact
  • User Guides
    • Chemical Inventory
      • Database
        • Database Backup and Restore
        • Best Practice for SQL Users Backup
      • Chemicals
        • Search Chemicals
        • Add a single chemical
        • Import a list of chemicals
        • Edit Chemicals
        • Edit Multiple Chemical Containers
        • Move multiple chemical containers
        • Borrow and Return Chemicals
        • Delete a chemical container
        • Delete multiple chemical containers
      • Users
        • Create a New User
        • Create a Guest Account
        • Create Multiple Users
        • Change User Password
        • Modify User Permission, Information
        • Delete a User
        • Inactivate a User
      • Storages/Locations
      • Terminal Mode
        • Set Up a Terminal User
        • Borrow and Return Chemicals
        • Change Chemical Location
        • Get Information on a Chemical
        • Dispose of Chemicals
      • TODO
    • Electronic Lab Notebook
      • Getting Started with ELN
    • Barcode Scanner Settings
      • Taotronic Wireless Barcode Scanner
      • Honeywell MS9520 Barcode Scanner
  • Installation
    • CentOS 7
    • Mac OSX
    • Windows
    • Raspbian on Raspberry pi 3B
  • Advanced Settings
    • OE Settings
      • Turn On Import and Edit function for Chemical Containers
    • Useful SQL commands
    • Hosting Server Related
    • Resources for Setting Up New Server
    • Other Supporting Programs for OE
      • Find Missing SDS
      • Find Missing Structure
    • Docker Build
  • Change Logs
    • Versions
Powered by GitBook
On this page
  • CHANGING INFO OF MULTIPLE CHEMICALS
  • To return all chemicals borrow by somebody (borrowed_by_person_id)
  • To change the owner info of a chemical (owner_person_id)
  • Find person_id using Console command line in PHPMyAdmin
  • Find storage ID using Console Command line in PHPMyAdmin
  • Show chemicals with multiple criteria
  • Change Responsible person for chemicals with multiple criteria
  • Show storage_name and storage_id using username
  • Update responsible person for chemicals in many location (storage)
  • Search for barcodes that are duplicated
  • Update/Get extra info for containers with duplicated barcode (continued from “Search for barcodes that are duplicated”)
  • REMOVE ALL CONTAINERS (BOTTLES) OF CHEMICALS
  • Find duplicated custom barcodes using SQL

Was this helpful?

Export as PDF
  1. Advanced Settings

Useful SQL commands

Below are some additional SQL commands that can give you some info that are not possible from inside Open Enventory

PreviousTurn On Import and Edit function for Chemical ContainersNextHosting Server Related

Last updated 3 years ago

Was this helpful?

This site uses cookies to deliver its service and to analyse traffic. By browsing this site, you accept the privacy policy.