MySQL Forums
Forum List  »  Knowledge Base

Displaying a column differently SOLVED
Posted by: Joseph Sutton
Date: June 02, 2009 04:17PM

Okay, I have no idea if this is the right forum for this, so I want to go ahead and apologize for it if it is.

Anywho, I've got a quick question..

You know when you make an ID a primary key and make it auto_increment, it goes 1, 2, 3, 4, etc. after every insert, correct?

Well, I want to make it display like 0001, 0002, 0003, 0004, etc. after every insert.

Thank you in advance.

---EDIT---
I fixed it. Thank you anyways.

[Fix is UNSIGNED ZEROFILL]



Edited 2 time(s). Last edit at 06/05/2009 10:24AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Displaying a column differently SOLVED
2439
June 02, 2009 04:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.