I am new person in Mysql

I am new person in Mysql

am 17.08.2006 09:31:35 von uma_sarayu

I have a table with rowid and name as columns and I want to insert
multiple names in the same record. Can anyone help me??

Thanks,

Re: I am new person in Mysql

am 18.08.2006 01:44:02 von Jim Langston

wrote in message
news:1155799895.668384.162080@i42g2000cwa.googlegroups.com.. .
>I have a table with rowid and name as columns and I want to insert
> multiple names in the same record. Can anyone help me??
>
> Thanks,

In the same record? Your name field has so many characters. The db is most
likely designed for 1 name in each record.

If your purpose is to have many names with the same rowid, you could make
sure that rowid is not set as unique.

Please explain your purpose.

Re: I am new person in Mysql

am 18.08.2006 19:12:02 von Davie

uma_sarayu@rediffmail.com wrote:
> I have a table with rowid and name as columns and I want to insert
> multiple names in the same record. Can anyone help me??
>
> Thanks,

Unless you mean First name, Middle name, Surname etc in 1 record,what
you are suggesting is not good practice.
I suggest you have a look at
http://www.utexas.edu/its/windows/database/datamodeling/inde x.html