need to create a id having primary key with auto incrementation + a string has to be stored with that id using php like: my sql has to show-
- ID
- WFS001
- WFS002
- WFS003
- WFS005
- .
- .
- .
- .
need to create a id having primary key with auto incrementation + a string has to be stored with that id using php like: my sql has to show-
An option is to have an auto increment column, do the insert, get the last id with LAST_INSERT_ID and make an update using another column and the last insert id + string.