Database

Essential Knowledge of MySQL Database How is a query processed? Connector: Long connection, Short connection, Reset Connection, etc. Cache: Optional for the query. However, the cache is not useful because the data might be updated frequently. It is now not supported in MySQL8.0 Analyzer: lexical analysis. Syntax analysis. Including checking whether a querying column exists or not. Optimizer: Decide using which index. Start by reading which table while executing join....