Auto increment with customize purchase order number?

[utf200]

My table name is purchase_order
the column is po_no but there is option of date_time_now with intial

example:
–“po”.datetime_now()-- it through o/p → po2023:11:00:20
then i need to customize the sequence of po_no
Like this “format - P0- 0023 (with auto increment)”

kindly anyone help me to customize the column
thanks to help

[nickzworld]

@utf200

u

You need to add another custom field on your list product

Next up is you have to do the query

After that you may try publish the project.
Also you can check this out if what is the LPAD means

MySQL LPAD() Function

Have a nice day ^_^.

[utf200]

very big help to me , Thank you very much , lot of thanks
perfect sir