Tips and tricks of MySQL

Tips and tricks of MySQL

JUST ABOUT MANAGEMENT

MYSQL TIPS AND TRICKS

1. Do not use MySQL as a queue

2. Fast reception of unique data

3. Follow the basic rules of indexing

  • Indexes allow the server to find groups of adjacent rows.
  • They allow the server to read the rows in the desired order without the server constantly wasting time sorting the rows.
  • In addition, they allow the server to satisfy all requests from the index, which means that the server does not need to access the full table.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Akademily

Akademily

We conduct reviews, guides and comparative tests of gaming laptops, monitors, graphics cards, keyboards, mouses, headsets and chairs to help you buy the best ga