Member Avatar for newbie1234

I have s_no in my database's table. Which is increment automatically whenever new entry comes. But this is only int. I am using this as a ID of particular task. I want this in varchar. means id should be like "a45c725". How to achive this

  • 3 Contributors
  • 6 Replies
  • 102 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for Szabi Zsoldos

What is the purpose of what you want ?

Member Avatar for pritaeas

You may want to add an additional column for this, and create an insert trigger to automatically generate that id (based on your specifications).

Member Avatar for newbie1234

to use that as id . Jump to next page using this id and show detail according to that.

Member Avatar for pritaeas

Is this a new question? Can you please give an example of what you want?

Member Avatar for newbie1234

I have a one field in table says s_no (int) 20. I am using this as a user id. its automatic increment when new entry comes. This s_no is user to get other detail of user. But this is integer so i am getting only limited user. How to get varchar id which will be automatic increment.

Member Avatar for pritaeas

See my first post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.