I need to change number ordering in table:
This is original:
SELECT MAX(`number`) FROM `'._DB_PREFIX_.'order_invoice`
It selects max number from column.
Now I need to change Invoice number to start from 1 again, now it is on 110.
Should I create new table and start from one or what would be the best solution to do it?
Is it possible if I manualy change last number to 1 then that it only checks last number in a column but not max number?