I have 3 tables related to tabata data:
in tabata_module i have a column "exercice_ids" with array of the Ids from the two tables "tabata_exercice_serie" & "tabata_exercice_chunk" and because both of them have ID (int)I don't know from wich table it is.
how to create an auto-increment column with a prefix in adminer with MySQL??
For the moment i reached to create an AI ID. To fix my problem my current solution is to have a specific id for "tabata_exercice_serie" & "tabata_exercice_chunk. For exemple:
- "tabata_exercice_serie": E1,E2,E3,E4,E5,...etc
- "tabata_exercice_chunk: EC1,EC2,EC3,EC4,EC5,...etc
My problem is when i click on default value and i enter de prefix "E" i have these error log (img2).. I thought it could be that the column type and i also tried all the column types but is always the same error.
Do you how can i add a prefix value in a AI..?? ChatGPT is telling me to use
CONCAT("E",id) but i foung it useless because is not going to add Automatically the prefix and i will need to comme and use the function every time i have a new input in the table.
if you have another way around to solve these is issue i'm also intereseted. Thanks