I am new to mysql and am trying to develop a package in php using mysql as backend database.
I have a table in mysql which has a customer code which is alpha numeric. Eg: J0001 and name and address of the customer. The alphabet signifies the first letter of the name of the customer viz. James. I want to increment this code to J0002 when another customer (Jones) details is entered into the system i.e J0003 and so on. Can any enlightened members help me with this code in mysql. This will be used while coding in php to update the database with the entries made online. Looking forth for early replies from friends all over the world. Suryanaryanan
Disclaimer: The information contained in the message is legally privileged and confidential information tended only for the use of addressed individual or entity indicated in the message (or responsible for delivery of the message to such person). It must not be read,copied, disclosed,distributed or used by any person other than the addressee. Unauthorised use,disclosure or copying is strictly prohibited and may be unlawful. Opinions, conclusions and other information on this message that do not relate to the official business of AURO MIRA ENERGY COMPANY PRIVATE LIMITED, shall be understood as neither given nor endorsed by the company.If you have received the message in error, you should destroy this message and kindly notify the sender by e-mail
