Jerry Schwartz wrote:
> If all you want to do is to restrict a field to certain values, and aren't
> concerned with cascading operations, is a set more efficient than a foreign
> key?
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farming
Jujitsu Lizard wrote:
> On Sat, Nov 15, 2008 at 3:54 AM, metastable <[EMAIL PROTECTED]
>
>> wrote:
>>
>
>
>
>> I may just have had an insight over my morning coffee.
>> How about turning things around and adding a FK -to the customers tab
Martijn Tonies wrote:
>> >The notion of a "variant record" exists in many programming languages.
>> >Typically you have a selector to indicate which variant it is. There is
>> >nothing at all wrong with using the same sort of construct in a database
>> >table.
>> >http://en.wikipedia.org/wiki/
Jujitsu Lizard wrote:
> On Fri, Nov 14, 2008 at 1:39 PM, Martijn Tonies <[EMAIL PROTECTED]>wrote:
>
>
>>> >The notion of a "variant record" exists in many programming languages.
>>> >Typically you have a selector to indicate which variant it is. There is
>>> >nothing at all wrong with using t
Mr. Shawn H. Corey wrote:
> On Fri, 2008-11-14 at 14:30 +, Mark Goodge wrote:
>
>> I wouldn't try to arbitrarily normalise the database for SQL
>> efficiency.
>> In a real-life situation, it's more important that the database
>> design
>> reflects your actual workflow and business requirem
US Data Export wrote:
>> -Original Message-
>> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
>> Sent: Friday, November 14, 2008 10:44 AM
>> To: 'mysql'
>> Subject: Re: normalised designs: customer database
>>
>>
3) create the customer table with a FK for people and a FK for
most of my formal education years ? :)
Kind regards,
Stijn
-- metastable Stijn Verholen Camille Huysmanslaan 114, bus 2 B-2020
ANTWERPEN +32 (0)3 707 08 08 (phone) +32 (0)3 707 06 06 (fax) +32 (0)473
47 62 88 (mobile) [EMAIL PROTECTED] http://www.metastable.be BTW-BE
0873.645.643 bankrek.nr. ING
Dan O'Keefe wrote:
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
How about `` ?
hth,
Stijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ananda Kumar wrote:
I feel creating the third table would just be duplicating the data and
occupying space. Creating index on existing table and quering would be
better. But you got a good point of FOREIGN KEY CONSTRAINT. Can we use this
constraint on current "SETTINGS" table, rather than creatin
Waynn Lue wrote:
I have two tables, Applications and Settings. Here are the two schemas:
mysql> desc Applications;
+-+-+--+-+-++
| Field | Type| Null | Key | Default |
Extra |
+---
10 matches
Mail list logo
