Question

I have tried looking for an answer for my question but due to lack of proper knowledge in databases, I thought some genius here could help me out.

I m trying to add rows into a database table starting from the number 800 and onwards in a sequential order. The database currently has records from 1 up until 300.

表中的这一记录并非自动增加,而是人工分配。

I basically want to start another batch of numbers, but rather than incrementing them from where the program left off (i.e. from 300) I would like to start them from 800.

我尝试了不同的发言,但没有具体结果。 Im利用PHP进入这些网。

我感到,这 t太硬,但我 m一 , kill!

我认为也许会增加一个记录,从800起开始,然后执行类似声明。

SELECT LAST FROM A RANGE BETWEEN 800 AND 899

这将是前进的道路。

任何帮助、咨询?

Answer 1

You can obtain the highest numbered record with the MAX aggregate function. The following will find the next highest number that is between 800 and 899.

SELECT MAX(my_assigned_number) + 1 as next_number
FROM my_table
WHERE my_assigned_number > 800 AND my_assigned_number < 899;

友情链接