php tutorial in hindi | how to make unique id for employee like EMP_1, EMP_2

In this video you will learn about how to make unique id for employee like EMP_1, EMP_2 in database table
Follow Tutorialswebsite:
/ tutorialswebsite
/ techwebsitetrix
www.tutorialswe...
#mysqliuniqueTableid #howToMakeUniqueID

[@bhattavi7877]

Thanks for this video sir

[@creativenetworks9137]

thank you sir ..solve ho gya,,,,, thanks again

[@Tutorialswebsite]

great

[@RahulKumar-pu2kc]

Thanks for video sir :)

[@Vasugi-ds6sg]

Can u help me how to echo unique_id in my html input field......thank you this has worked in database... But i couldnt echo it on my input field

[@saurabhtiwwari2546]

How to insert last inserted value in two or more table which has it's own auto increment column so value will change every time please help

[@mrsaeedahmad93]

Sir one video on
How to fetch data by calendar or date

[@pallavipatole8865]

how to get unique ID based on like Last Name : Bhuta (first 2 alphabets of last name)
and take last 3 digit of phone number

[@creativenetworks9137]

hello sir...its not working.. please can you send me email,so i can connect your and tell you what is problem occurring with me

[@Tutorialswebsite]

Hi
you can send me mail on [e-mail]

[@infomudrahome3794]

can you make it for laravel ?

[@yashvantgupta2405]

thank you so much sir..

[@chandanadhikari4637]

Sir, we can also do the same with the use of create trigger in SQL by run the following command in phpmyadmin console.
Eg: CREATE TRIGGER mytrigger
BEFORE INSERT
ON users (table name)
FOR EACH ROW
SET NEW.user_id(column name) =
CONCAT("EMP_",COALESCE((SELECT MAX(id)+1 from users),1))

[@adhiarunkumar]

Good!!!

[@RamuRamu-eu2sx]

Thank you sir

[@Tutorialswebsite]

Most Welcome Ramu