MySQL – Reset Auto-Increment Table of content Most of the tables in MySQL use sequential values to represent records, like serial numbers. Instead of manually inserting each value one by one, MySQL uses the “AUTO_INCREMENT” to handle this automatically. AUTO-INCREMENT in MySQL AUTO_INCREMENT in MySQL is used to generate unique numbers in ascending order automatically […]

MySQL – Show Processlist Table of content MySQL database provides a multi-user environment, that allows multiple clients to access the database at the same time. A process is defined as the operations performed by a user on the MySQL Server. Multiple processes can be run on a MySQL Server concurrently by multiple users. What is […]

MySQL – Select Random Records Table of content Have you ever taken online examinations? If yes, then did you ever wonder how is the order, in which these questions are displayed, random? These questions are usually stored in a database of the test application and are randomly displayed one by one. While using a database […]