ls.
>
> PB
>
> Original Message
> From: "Richard Reina"
> Reply-To: "Richard Reina"
> Date: 07/29/15 10:19 AM
> To: "mysql@lists.mysql.com"
> Cc:
> Sub: table design question
> If I were to create a database table(s) to tract most
Hi Richard,
On 7/29/2015 10:19 AM, Richard Reina wrote:
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance or
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance or different repair tables for each appliance.
All the tables
Hello,
>Many thanks for your response. Can yo u offer any advice with regards
usage
>of country_codes eg gb and regions, cities etc ? I've been reading up on
>http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to use a
>Surrogate key for countries ? Or the country code like fr for
Many thanks for your response. Can yo u offer any advice with regards
usage of country_codes eg gb and regions, cities etc ? I've been reading
up on http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to
use a Surrogate key for countries ? Or the country code like fr for France
?
Sa
Neil,
Am 21.04.2013 08:47, schrieb Neil Tompkins:
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_id ? Or is it sufficient to access using a join ?
It depends. Adding a reference to
Hi
I'm creating the following basic tables
COUNTRIES
countries_id
name
REGIONS
region_id
countries_id
name
CITIES
cities_id
region_id
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_i
(and uncompressing) the JSON.
> -Original Message-
> From: Gaston Gloesener [mailto:gaston.gloese...@web.de]
> Sent: Sunday, August 12, 2012 10:58 PM
> To: mysql@lists.mysql.com
> Subject: RE: Best design for a table using variant data
>
> > You don't spe
rarely(almost never) changes and add happens only say twice a month.
So can I not have one big table like below?
Size is not the issue. A basic table design rule is atomicity--one value
per cell. Violating that rule screws up queries.
what disadvantage does it has? sorry I am not into RDBMS
thx in advance.
Rajeev
From: Peter Brawley
To: Rajeev Prasad ; "mysql@lists.mysql.com"
Sent: Wednesday, August 15, 2012 4:01 PM
Subject: Re: suggestion needed for table design and relationship
On 2012-08-15 1:54 PM, Rajeev Prasad wrote:
> I
,dev_m...
dev_z | 3934 |5634 |11.2.3.4 |79.8.7.6
|data_specific_to_z.|SVC_M|dev_n,dev_m...
...
pl advice. what would be the best design? data_specific_to_device could be more
than one column, as i get to explore the data a bit more.
and do i really need a
|11.2.3.4 |79.8.7.6
|data_specific_to_z.|SVC_M |dev_n,dev_m...
...
pl advice. what would be the best design? data_specific_to_device could be more
than one column, as i get to explore the data a bit more.
and do i really need a device_id field? which any SQL table normally has
inal Message-
From: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Sent: Friday, August 10, 2012 15:33
To: Gaston Gloesener
Cc: mysql@lists.mysql.com
Subject: Re: Best design for a table using variant data
You don't specify how many different types (including min/max values) you
expect to be using. I
Hello,
I am currently facing a design where a table (virtually) needs to store
attributes of a topic (related table). The attributes can be user defined,
i.e. not known at development type and depend on other factors. Each
attributes value can be one of different types (int, int64, double, string)
an
Hello,
I am currently facing a design where a table (virtually) needs to store
attributes of a topic (related table). The attributes can be user defined,
i.e. not known at development type and depend on other factors. Each
attributes value can be one of different types (int, int64, double
:01 AM, Tompkins Neil wrote:
>
>> Hi,
>>
>> I'm in the process of starting to design a hotel booking system that will
>> eventually consist of over 10,000 hotels all with different room types,
>> rates and availability for different dates. My question is does a
On 2/17/2012 4:01 AM, Tompkins Neil wrote:
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience
Hi
I am trying to get some background information with regards the design. I have
a fair idea but would like advice from anyone that has previously worked on
similar projects.
On 20 Feb 2012, at 17:22, Jan Steinman wrote:
> Where are your domain experts? You *are* consulting with t
Hi,
Nobody answers because this is a very wide question about software
engineering,
Trust me, It seems like a simple question but it is not.
The only advice I can give you is to try to imagine all possible
scenarios/use-cases before starting the design.
Cheers
Claudio
2012/2/20 Jan Steinman
Where are your domain experts? You *are* consulting with them, no?
If you don't know the answers, and don't have access to domain experts to help
you, I would design for the most general case, and factor out exceptions as
they prove to be so. "Pre-optimization" for exce
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience with regards the best way to store the daily rates
parate table for nick names.
I'd look carefully at cardinality, and any field in which you can say, "some
states may have more than one," put it in a separate table.
(One exception to cardinality-driven table design would be if a field is a
clearly defined, relatively unchanging se
Thank you very much for all the insightful advice. I will keep the
separated.
2011/9/19 Jerry Schwartz
> >-Original Message-
> >From: Richard Reina [mailto:gatorre...@gmail.com]
> >Sent: Monday, September 19, 2011 9:55 AM
> >To: mysql@lists.mysql.com
> >
I would design three tables:
Table1 (states):
ID, name, abbreviation
Table2 (state_item):
ID, state_id (from states), item_id (from item_type), item_value (varchar)
Table3 (item_type):
ID, item_name
Into the item_type table you can insert:
Nick Name
Motto
Name origin
Facts
SomeOtherDataPoint
>-Original Message-
>From: Richard Reina [mailto:gatorre...@gmail.com]
>Sent: Monday, September 19, 2011 9:55 AM
>To: mysql@lists.mysql.com
>Subject: table design question
>
>I want to create a US geography database. So far I have categories such as
>state nick name
I want to create a US geography database. So far I have categories such as
state nick names (some states have more than one), state mottos (text 25 to
150 characters), state name origins (100-300 characters), state "trivial
facts", entry into union. My question is; would it be better to keep at
le
i'm just looking for rough ideas here...
i've got a table that has 31 fields. most of them need to be there
(entry time, exit time, entry lat, etc). however, i've got 4 fields
that i query this db with that should generally be unique... well,
really 3 fields that should be unique, because the 'nam
I maintain a little open source project that deals with IDS alert
data. I want to add IP reputation to my event queries and I am stuck
on how I should implement it.
The user will have the option of bringing in lists from different
providers and the limit will not be fixed. These lists will be a
si
> From: gvim
>
> I have a typical contact database which caters for multiple email addresses
> with a distinct Email table keyed to a foreign key inside the Contact table,
> ie. a 1-to-many relationship. However, I want to prioritise these Email
> entries for a given Contact entry so all I can
>From: gvim [mailto:gvi...@gmail.com]
>Sent: Thursday, December 09, 2010 9:33 AM
>To: MySQL
>Subject: Design: how to prioritise 1-to-many fields
>
>I have a typical contact database which caters for multiple email addresses
>with a distinct Email table keyed to a foreign k
On Thu, Dec 9, 2010 at 3:33 PM, gvim wrote:
> I have a typical contact database which caters for multiple email addresses
> with a distinct Email table keyed to a foreign key inside the Contact table,
> ie. a 1-to-many relationship. However, I want to prioritise these Email
> entries for a given
I have a typical contact database which caters for multiple email addresses
with a distinct Email table keyed to a foreign key inside the Contact table,
ie. a 1-to-many relationship. However, I want to prioritise these Email entries
for a given Contact entry so all I can think of is to add a nu
On 10/8/2010 3:31 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your response. In your experience do you think I should still
retain the data used to generate the computed totals ? Or just compute
the totals and disregard the data used ?
In my experience, the details matter. Also in my experie
Hi Shawn
Thanks for your response. In your experience do you think I should
still retain the data used to generate the computed totals ? Or just
compute the totals and disregard the data used ?
Regards
Neil
On 8 Oct 2010, at 19:46, "Shawn Green (MySQL)"
wrote:
Hi Neil,
On 10/5/2010
Hi Neil,
On 10/5/2010 5:07 AM, Tompkins Neil wrote:
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my ap
Wonder if anyone can help me ?
-- Forwarded message --
From: Tompkins Neil
Date: Tue, Oct 5, 2010 at 10:07 AM
Subject: Design advice
To: "[MySQL]"
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
pl
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my application, the values in the rating field are
changed.
At 04:23 PM 9/9/2010, Tompkins Neil wrote:
Hi all,
Needing some advice on my tables design.
Basically I am designing a soccer application, and have a table which
contains player_bids (the values of which a player costs to be transferred
between clubs). Can someone please offer some input on
Hi all,
Needing some advice on my tables design.
Basically I am designing a soccer application, and have a table which
contains player_bids (the values of which a player costs to be transferred
between clubs). Can someone please offer some input on the best way in
which I should design the
fixtures and teams.
Cheers
Neil
On Wed, Sep 1, 2010 at 4:43 PM, Jerry Schwartz wrote:
I strongly suggest that you make a separate table for the manager <-> team
relationship, so you can keep a history. Put a date-stamp in there. This
might
come in handy as you get further into your desi
, Sep 1, 2010 at 4:43 PM, Jerry Schwartz wrote:
> I strongly suggest that you make a separate table for the manager <-> team
> relationship, so you can keep a history. Put a date-stamp in there. This
> might
> come in handy as you get further into your design.
>
> I ran into
I strongly suggest that you make a separate table for the manager <-> team
relationship, so you can keep a history. Put a date-stamp in there. This might
come in handy as you get further into your design.
I ran into this problem when one of our sales reps moved from one office to
anothe
ssage-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: 01 September 2010 12:52
To: [MySQL]
Subject: Fwd: Database design help
Looking for some help / comments if possible ?
Cheers
Neil
-- Forwarded message --
From: Neil Tompkins
Date: Tue, Aug 31, 2010 at 8:48 PM
Su
think this
few lines can trigger the best idea in you.
Claudio
2010/9/1 Tompkins Neil
> Looking for some help / comments if possible ?
>
> Cheers
> Neil
>
> -- Forwarded message --
> From: Neil Tompkins
> Date: Tue, Aug 31, 2010 at 8:48 PM
> Subject
Looking for some help / comments if possible ?
Cheers
Neil
-- Forwarded message --
From: Neil Tompkins
Date: Tue, Aug 31, 2010 at 8:48 PM
Subject: Database design help
To: mysql@lists.mysql.com
Hi
I've a soccer application consisting of managers, teams players and
fix
Hi
I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game
which will depend on the result.
What would be the best table design bearing in mind that a manager can
move to a different club.
My though
Hi,
I'm creating a application which hosts football matches and I want to record
the player appearances, goals etc. I was thinking of having a record for
each player as follows :
appearance_id
season_id
player_id
team_id
competition_id
appearance
goals
yellow_card
red_card
date_played
Is this t
s can update but if you propose to have several sets of columns
copies where each set belongs to a single group, that would be horrible.
Work up from a rational database design and build an application to
support it. Try very hard to not design a database that works with your
code. Databases op
? Is it recommended to design a master table
having more than 200 columns?
Have you ever read a book on database design & normalization?
PART II:
Secondly, I am using PHP, Mysql, ADODB, APACHE on windows 7 platform. This
is my typical DML command:
I am not using any rollback statement t
master table should have ? Is it recommended to design a master table
having more than 200 columns?
PART II:
Secondly, I am using PHP, Mysql, ADODB, APACHE on windows 7 platform. This is
my typical DML command:
$query="update users set
id='$id',password=\"$password
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
10-Mar-10
Extended Capabilities for Query Design and Data Management for MySQL
Devart announced the public availability of dbForge Query Builder 1.50, a tool
>-Original Message-
>From: Mikhail Berman [mailto:mikhail...@gmail.com]
>Sent: Wednesday, December 23, 2009 9:16 AM
>To: Eva
>Cc: mysql@lists.mysql.com
>Subject: Re: help design the table
>
>Hi Eva,
>
>It seems to me that you might want to have two tables th
Hi Eva,
It seems to me that you might want to have two tables that will describe
data in your database
* - DOMAINS
* - IPS
DOMAINS table should contain two fields:
* `domain_key` - auto-increment
* `domain_name` - varchar(20)
IPS table should contain three fields
domain_key - int(10) - being
Hello,
I have a table, which has a column named as "domain", each domain has
some IPs, each IP has two attributes: "disabled","noticed".
For example, the table:
domainIP
www.aol.com 64.12.245.203 64.12.244.203 64.12.190.33 64.12.190.1
But I don't know how to control the IP's att
Hello,
Currently, I have four tables (Items, UpdatePrice, UpdateStatus and
UpdateRelease). All the Update tables are linked to Items.ItemID via
Update(Price|Status|Release)ItemKey. Personally, I don't feel that
this is the best database design I could have, but I can't seem to
come u
donné que les email
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
> aucune responsabilité pour le contenu fourni.
>
>
>
>
>
>
> > Date: Sat, 3 Oct 2009 18:11:59 -0600
> > From: john.l.me...@gmail.com
> > To: m...@phillipsmarketi
Mark Phillips wrote:
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me> calls to HarvardMedicalSchoo
On Sat, Oct 3, 2009 at 4:02 PM, John Meyer wrote:
>
> John,
>> Thanks. The data is private to each user; there is no sharing of data. I
>> am not sure what you mean by "are the actions related" Each user is
>> reading/writing independently of each other. Would that argue for separate
>> database
t that user a cannot get to user b's
data.
Can't I achieve the same level of security if each row has a userID, and all
queries use a "where userID=xxx" clause?
Mark
>
>
> > Date: Sat, 3 Oct 2009 14:38:25 -0700
> > Subject: Questions on Database Design
&g
John,
Thanks. The data is private to each user; there is no sharing of data.
I am not sure what you mean by "are the actions related" Each user is
reading/writing independently of each other. Would that argue for
separate databases?
Mark
Are the actions of a similar nature (i.e. they're
On Sat, Oct 3, 2009 at 2:47 PM, John Meyer wrote:
> Mark Phillips wrote:
>
>> I am new at database design, and my question relates to the trade-offs
>> between putting all data in one database or several for mysql. For
>> example,
>> say I have an application
Mark Phillips wrote:
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly 10-15 tables in the
>-Original Message-
>From: AndrewJames [mailto:andrewhu...@gmail.com]
>Sent: Saturday, September 12, 2009 1:20 AM
>To: Kyong Kim; Arthur Fuller
>Cc: Claudio Nanni; mysql
>Subject: Re: database design
>
>thank you all, i think
>
>"You probably wouldn&
directly."
>
> is my answer.
>
>
> --
> From: "Kyong Kim"
> Sent: Saturday, September 12, 2009 8:22 AM
> To: "Arthur Fuller"
> Cc: "Claudio Nanni" ; "AndrewJames"
> ; "mysql"
> Subject: Re:
Storing it directly will cause problems when you want to add a new Article
Type. IMO it's better to have an ArticleTypes table (AutoIncrement) and
store its values in the ArticleTypeID column in the Articles table.
A.
On Sat, Sep 12, 2009 at 1:19 AM, AndrewJames wrote:
> thank you all, i think
>
epter aucune responsabilité pour
le contenu fourni.
> Date: Fri, 11 Sep 2009 15:22:57 -0700
> Subject: Re: database design
> From: kykim...@gmail.com
> To: fuller.art...@gmail.com
> CC: claudio.na...@gmail.com; andrewhu...@gmail.com; mysql@lists.mysql.com
> > A) You
;Arthur Fuller"
Cc: "Claudio Nanni" ; "AndrewJames"
; "mysql"
Subject: Re: database design
A) You would probably want to populate the Article.Article_Type column
with Article_Type.ID. You probably wouldn't need Article_Type table if
you're going
ll be searching the article table by uid, you
might want to cluster the data by uid so all related articles will be
stored next to each other.
Kyong
On Fri, Sep 11, 2009 at 5:44 AM, Arthur Fuller wrote:
> I agree with Claudio. You have your design correct. The only other thing you
> need
I agree with Claudio. You have your design correct. The only other thing you
need is the uid qualifier. Presumably you are using PHP or some other front
end to present your data. Your front end would request the user's name and
password, saving the uid in a variable and then issuing the s
t i really need some help and or directed
> to the best reading resources.
>
> as i begun building my database (as i went along), i now realise i have to
> stop coding and sit back and design the database properly before i can go
> on.
>
> However i am still unable to wrap my head
This is a bit of a long shot, but i really need some help and or directed to
the best reading resources.
as i begun building my database (as i went along), i now realise i have to
stop coding and sit back and design the database properly before i can go
on.
However i am still unable to wrap
john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
(key which points to URL.URL_ID)> CATEGORY_ID (key which
lworld.com ; mysql@lists.mysql.com
Cc: john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which
: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which points to URL.URL_ID)> CATEGORY_ID (key which points to
> CATEGORY.CATEGORY_ID)> SUBCATEGORY_ID> PK: (
n seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: bobsh...@ntlworld.com
> To: mysql@lists.mysql.com
&
helpful to me.
cheers
- Original Message -
From: "John Meyer"
To: "BobSharp"
Cc:
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching & Instructional websites, etc.
There
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers, Organistations,
(UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching &
Instructional websites, etc.
There will be some sub-
MySQL University: Scalability by design - coding for systems with large
CPU counts
This Thursday, we're continuing our series of sessions on MySQL
performance measuring and improvements with Richard Smith's presentation
titled Scalability by Design - Coding for Systems With Large
that you're thiking of setting up a system (ie, might
buy their product/services/solutions) but that you want to know more about
the underlying database/schema regarding your issues...
you'll be surprised at how much you can get from this kind of approach!!!
in your case, you aren'
t; >Sent: Tuesday, January 06, 2009 9:47 AM
>>> >To: mysql@lists.mysql.com
>>> >Subject: RE: how to design book db
>>> >
>>> >
>>> >Just theories here:
>>> >
>>> >
>>> >
>>> >The same book re-
My comments, questions & explanations inserted below
mos wrote:
> At 09:55 AM 1/6/2009, you wrote:
>
>> >-Original Message-
>> >From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>> >Sent: Tuesday, January 06, 2009 9:47 AM
>> >To: mysql@lists.my
At 09:55 AM 1/6/2009, you wrote:
>-Original Message-
>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>Sent: Tuesday, January 06, 2009 9:47 AM
>To: mysql@lists.mysql.com
>Subject: RE: how to design book db
>
>
>Just theories here:
>
>
>
>The same book
On Tue, January 6, 2009 07:55, Jerry Schwartz wrote:
>
>>-Original Message-
>>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>>Sent: Tuesday, January 06, 2009 9:47 AM
>>To: mysql@lists.mysql.com
>>Subject: RE: how to design book db
>>
>>
>
>-Original Message-
>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>Sent: Tuesday, January 06, 2009 9:47 AM
>To: mysql@lists.mysql.com
>Subject: RE: how to design book db
>
>
>Just theories here:
>
>
>
>The same book re-issued by another publisher mi
Just theories here:
The same book re-issued by another publisher might have a different ISBN.
A book with an insert (e.g., CDROM) may have a different ISBN, but be the
"same" for some purposes.
And mistakes can be made...
Ultimately, I suspect that the uniqueness of ISBN to what norma
& Apache 2.2.11.
>> I need figure out how to set up (design) a database of books which
>> gets rather complicated since I must implement searches of the
>> database based on key words including categories, ISBN numbers,
>> authors, dates, etc. etc.
>> The problem is how
right...
forgot about that!
-Original Message-
From: Paul Wilson [mailto:hoo...@staff.iinet.net.au]
Sent: Monday, January 05, 2009 5:59 PM
To: 'bruce'; 'PJ'; 'mos'
Cc: mysql@lists.mysql.com
Subject: RE: how to design book db
Recent books that I'v
orance is bliss, politicians should be orgasmic!"
-Original Message-
From: bruce [mailto:bedoug...@earthlink.net]
Sent: Tuesday, January 06, 2009 8:52 AM
To: 'PJ'; 'mos'
Cc: mysql@lists.mysql.com
Subject: RE: how to design book db
hey phil...
are you sure that a book can hav
/publishers...
thanks
-Original Message-
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Monday, January 05, 2009 3:06 PM
To: mos
Cc: mysql@lists.mysql.com
Subject: Re: how to design book db
mos wrote:
> At 08:17 AM 12/29/2008, you wrote:
>> I am rather fresh to MySQL and am trying t
mos wrote:
> At 08:17 AM 12/29/2008, you wrote:
>> I am rather fresh to MySQL and am trying to fix and update a website
>> - modifying from just plain html to css, php and MySQL. I'm working
>> on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11.
>> I need
At 08:17 AM 12/29/2008, you wrote:
I am rather fresh to MySQL and am trying to fix and update a website -
modifying from just plain html to css, php and MySQL. I'm working on
FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11.
I need figure out how to set up (design) a database of bo
I am rather fresh to MySQL and am trying to fix and update a website -
modifying from just plain html to css, php and MySQL. I'm working on
FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11.
I need figure out how to set up (design) a database of books which gets
rather complicated sin
HI,
I'm developing a cms, I need some suggessions regarding database design.
I'm creating role table in which role name will be unique, so my
question is that should I create roleid(int, autoincreament, primary
key )?
Same question for users table.
Note: I'll have user rol
If you want to choose the first one, then the flag' data type must be
enum.For int fill the disk with 4 byte and enum just 1 byte.
On Sat, Oct 4, 2008 at 2:15 AM, Alex K <[EMAIL PROTECTED]> wrote:
> That seems like a nice trick. I suppose the flag would just be an int
> and not an enum in this cas
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
>Alex K
>Sent: Friday, October 03, 2008 2:15 PM
>To: Mr. Shawn H. Corey
>Cc: Rob Wultsch; mysql@lists.mysql.com
>Subject: Re: simple design choice
>
>That seems like a nice tric
That seems like a nice trick. I suppose the flag would just be an int
and not an enum in this case.
2008/10/3 Mr. Shawn H. Corey <[EMAIL PROTECTED]>:
> On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
>> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
>> > Hello,
>> >
>> > I
On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > I have a table of a 1 million users. I want to add a flag called
> > delete if a user wants to delete his account. Note that this situation
> > does not happe
Hi,
Personally I would do #3 as well. Have an exact copy (structurally) of
your original table, when the record is deleted then move the account's
details to your deleted_users table so it doesn't appear in users but
you still have all the details.
Not sure if it's possible in MySQL but in
1 - 100 of 752 matches
Mail list logo