Shulou(Shulou.com)06/01 Report--

The following brings you about what is the mysql linked table query content, I believe you must have read a similar article. What's the difference between what we bring to everyone? Let's take a look at the body. I believe you will gain something after reading what is a mysql join table query.

The structure of the sh_ row table is as follows

The sh_ privilege table is structured as follows

Where the id stored in pri_id_list in the sh_ rose table is the id value in the sh_ privilege table, and multiple roles are stored separated by commas. Now you want to replace the pri_id_list in the sh_ rose table with the corresponding pri_name in the sh_ privilege table. The sql statement used is as follows:

For the above about what is the mysql join table query, do you think it is what you want? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.