formula in mysql

[Heba]

hi

I was wondering if it is possible to add a formula in mysql?

like for example if i want to generate and automatic ID but this ID must contain lets say 1st 3 letters of the username and year he joined

[Xnuiem]

Yes it is possible. It can be a bit complex though.

[Heba]

:unsure: can you help me
I need to do it!

[Xnuiem]

Its a lot easier to allow the database use its own auto_increment function for the ID then just create a field or fields with the other data.

However, if you want to still go this route, you can use the substring() function to select the first three chars and then concat the year on it.

[barand]

The main property of an ID is that it should be unique. The formula you propose has little chance of ensuring that.