There are province tables in my database. Each province table has other related tables of the province. It is required to locate first, such as Guangdong, and then read data from other tables in Guangdong Province. I am currently using Baidu positioning to obtain identity information. However, if I have hard-coded province IDs in my database, can I only match strings?
From your description, the name of the province is unique and can be regarded as the primary key. I don’t know why you have to add an i to it. As you are now, you can only get the ID through the province name, and then get the association table through the ID.