Question

i have a table in which i have started the auto increment id at 10000 so that i have 10000 values reserved for manual insertion of values from admins. However when doing an insert into MyTable(ID,Name,Value) VALUES(500,"Test","Test") i do a select and it ignored my ID i gave it and pushes in into the next 10,000 range. Any suggestions on fixing this or what may be wrong? The code above is of course pseudo but i can give a real code example if it doesnt make sense.

Answer 1

在你回答你的问题之前,我必须警告你:extremely你试图这样做的坏做法。不要让我错了,许多人试图做你重新做的事情,这根本不是应该做的事情。

页: 1 国际发展法是主要的关键。主要的钥匙用于在表格中独一无二地确定一行。这就是说。除此以外,它没有任何其他特别意义。

So what does that mean for you? It means that your idea that you will "reserve" 1 - 10k for admins is bad. Why is it bad? Because you re tampering with the primary key. You should never decide what the value of primary key should be, that s databases job for many reasons (consistency for example). The other thing why it s bad is that you have limited someone to only 10k possible entries. On the other hand, how will you calculate what the next entry for admins is? What if you have entered 1, 2, 3, 4 and then you delete entry with ID = 3? What happens then? What s your next in sequence value? 3 or 5?

尽管如此,你或许应当重新考虑你们的战略。为什么不增加一个“isAdmin”领域,告诉你一个行政机构是否张贴了东西?

友情链接