Converting String to Text in mysql

am 06.04.2010 12:32:48 von Suryanarayanan

------=_NextPart_000_0001_01CAD5A2.9A42AE80
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0002_01CAD5A2.9A451F80"

------=_NextPart_001_0002_01CAD5A2.9A451F80
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_001_0002_01CAD5A2.9A451F80
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

charset=3Dus-ascii">

lang=3DEN-US
link=3Dblue vlink=3Dpurple =
style=3D'margin-left:18.75pt;margin-top:18.75pt'>
v:src=3D"cid:image001.gif@01CAD5A2.8FC87DE0" v:shapes=3D"_x0000_Mail" =
width=3D0
height=3D0 class=3Dshape style=3D'display:none;width:0;height:0'>

Style","serif";
color:windowtext'> I am new to mysql and am trying to develop a =
package in
php using mysql as backend database.

Style","serif";
color:windowtext'>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.

Style","serif";
color:windowtext'>Looking forth for early replies from friends all over =
the world.

Style","serif";
color:windowtext'>Suryanaryanan

Style","serif";
color:windowtext'>

------=_NextPart_001_0002_01CAD5A2.9A451F80--

------=_NextPart_000_0001_01CAD5A2.9A42AE80
Content-Type: text/plain; charset=iso-8859-1

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

------=_NextPart_000_0001_01CAD5A2.9A42AE80--

Re: Converting String to Text in mysql

am 06.04.2010 13:48:42 von Carsten Pedersen

You can do some trickery with auto increment fields and multiple-column

indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131

Beware that this is apparently a MyISAM-specific trick.

/ Carsten

On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan"

wrote:

> 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

>

>

>

>

>

> !DSPAM:451,4bbb1148499324901218737!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org