Displaying a column differently SOLVED
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.
Subject
Views
Written By
Posted
Displaying a column differently SOLVED
2401
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.