Re: SQL How To

new topic     » goto parent     » topic index » view thread      » older message » newer message 

On 9/3/05, cklester <guest at rapideuphoria.com> wrote:
> Should I do away with the sequence field and create a new table like so:
>
> prefs table (3 records):
>    unique_id:1
>    person:1
>    fruit_pref:1
>
>    unique_id:2
>    person:1
>    fruit_pref:2
>
>    unique_id:3
>    person:1
>    fruit_pref:3

Yes, you should - that's a staple of relational databases.
--
MrTrick
----------

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu