MySQL :: Re: Split Values by comma and Check in another Table?

New Topic

Re: Split Values by comma and Check in another Table?

Posted by: Peter Brawley
Date: January 29, 2009 08:57PM

>1 2318, 5236, 8541
>2 5236,8762
>3 8541, 2318, 5236, 8762

Violates a basic rule of database design: atomicity, ie one value only per cell. Read about normalisation, eg on pages listed at http://www.artfulsoftware.com/dbresources.html.

PB

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Split Values by comma and Check in another Table?

rasikow Gnaniyar

January 29, 2009 11:57AM

Re: Split Values by comma and Check in another Table?

Jay Alverson

January 29, 2009 12:17PM

Re: Split Values by comma and Check in another Table?

rasikow Gnaniyar

January 29, 2009 10:59PM

Re: Split Values by comma and Check in another Table?

Jay Alverson

January 30, 2009 08:34AM

Re: Split Values by comma and Check in another Table?

Peter Brawley

January 29, 2009 08:57PM

Re: Split Values by comma and Check in another Table?

rasikow Gnaniyar

January 29, 2009 11:08PM

Re: Split Values by comma and Check in another Table?

Peter Brawley

January 30, 2009 02:27AM

Re: Split Values by comma and Check in another Table?

Jay Alverson

January 29, 2009 10:16PM

Re: Split Values by comma and Check in another Table?

rasikow Gnaniyar

January 29, 2009 11:05PM

Re: Split Values by comma and Check in another Table?

rasikow Gnaniyar

March 27, 2009 01:03AM

Re: Split Values by comma and Check in another Table?

Jay Alverson

March 27, 2009 06:03PM

Re: Split Values by comma and Check in another Table?

Jay Alverson

March 28, 2009 02:24PM

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.