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
> From: Richard Reina
>
> 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
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
S
>-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
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
hi there,
I am a casual database tinkerer that has to build a new database.
so please do not fall down laughing if I ask stupid questions ..
the problem at hand is that I want to create tables with the following
structure:
- suppliers
they produce/deal-with 0 to n products
- products
a prod
Greetings,
Buy 'Building Scalable Web Sites'
[http://www.oreillynet.com/pub/pr/1582], authored by the chief
architect of Flickr. Among other interesting topics, he describes the
system they use for full-text search. Its pretty simple, though this
is just one of the ways you can solve this problem
Ysgrifennodd Scott Haneda:
I have been looking at stock photo sites lately, started wondering how they
are doing their keyword searched. Given a potential for millions of images,
each with x keywords, I have come up with two approaches...
Is this the sort of thing you're looking for:
htt
I have been looking at stock photo sites lately, started wondering how they
are doing their keyword searched. Given a potential for millions of images,
each with x keywords, I have come up with two approaches...
Approach one
Images table, with a parent id
Keywords table, each keyword would be its
This isn't exactly what I was looking for, but it works like a charm for
both my needs and the sys admins.
Go figure everyone is happy now!
Many Thanks!
-Tyler
Kishore Jalleda wrote:
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehen
In the last episode (Jan 31), [EMAIL PROTECTED] said:
> I'm trying to wrap my head around a performance problem our
> institution is having on our Mysql Server which hosts all of our logs
> from around campus.
>
> Specifically our MailLogs tables.
>
> What I'm having a hard time with is we have m
into the table.
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 8:51 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Database Layout (Design) Question
The delete would definitely depend upon the size of the record set
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehended your situation correctly ,I would
suggest using the Merge storage engine for your needs , and keep every
single day of data in a seperate MyISAM table, and merge all those tables
togeth
I'm trying to wrap my head around a performance problem our institution is
having on our Mysql Server which hosts all of our logs from around campus.
Specifically our MailLogs tables.
What I'm having a hard time with is we have metadata such as:
CREATE TABLE mail00 (
host varchar(32) default
On 8/7/06, James Tu <[EMAIL PROTECTED]> wrote:
If I create a table for each user (I can potentially have hundreds of
thousands of users), will MySQL be able to handle this?
If I just have one table, I could potentially have millions of
records in one table. Will MySQL be able to handle this?
;James Tu" <[EMAIL PROTECTED]>
To:
Sent: Monday, August 07, 2006 4:11 PM
Subject: Re: Database design question
Thanks everyone.
Now I feel confident that one table will be fine (Tripp's stat of
30 million records put me at ease :) ).
Cheers,
-James
On Aug 7, 2006, at 4:08
n key referencing the destinating user as well.
-Original Message-
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 1:56 PM
To: mysql@lists.mysql.com
Subject: Database design question
I want to design a database for lots of users. Each user will be
managing
thei
: Database design question
I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user
after they've registered?
Or should I just create one MESSAGES table and store messages there keyed
off of their user_id?
I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user after
they've registered?
Or should I just create one MESSAGES table and store messages there keyed off
of their user_id?
If I create a table for e
I want to design a database for lots of users. Each user will be
managing their own messages. Does it make sense to create a table
for each user after they've registered?
Or should I just create one MESSAGES table and store messages there
keyed off of their user_id?
If I create a table fo
Scott Klarenbach wrote:
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances w
Scott,
>I'm sure this type of problem is run up against all the time, and I'm
>wondering what the best practice methodology is from experienced DBA's.
It looks like the kind of problem database schemas are meant to
_avoid_.
>From your description it seems you have ...
part (
partID PRIM
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances when the RFQ has an
invento
Hi,
A very simple question. I have two products at our
website and i would like to keep track of how many of
each softwares were downloaded daily.
I am planning to create the following table:
id - auto_incr
date_of_download - data
product_name - enum value containing the two products
Then I pla
Greetings list,
In an analysis I was sent, there is 1 table with a simple set of rules, e.g.
a_table (id, day, max_hours, min_hours, min_days, start_time, stop_time,
max_attendants, ...)
No biggie there.
The problem is the user has to be able to define exceptions to those rules.
These exceptio
Mark Sargent <[EMAIL PROTECTED]> wrote on 06/03/2005 03:04:23 AM:
> Hi All,
> I'm not sure the best design approach for a product table for a number
> of different hardware devices. Some devices have IP, Port, CPU, Memory
> specs, whilst some don't. Current desing is below.
> Products:
> product
Hi All,
I'm not sure the best design approach for a product table for a number
of different hardware devices. Some devices have IP, Port, CPU, Memory
specs, whilst some don't. Current desing is below.
Products:
product_id
product_name
maker_id
controller_id
product_type_id
product_model_numbe
Shawn,
I agree with you that the tables can have different info with regard to
the requirements.
But for storing only addresses for specific students, this 4 table design
seems weirdish to me... I think it makes more sense to keep a
student_id in the Addresses table...
With regards,
Martijn Ton
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 05/24/2005 02:32:05 PM:
>
>
>
> > Something like this would make more sense to me and provide greater
> flexibility;
>
> It doesn't to me...
>
> > student
> >
> > student_id
> > name
> > age
> >
> > address
> > ---
> >
nal Message-
From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 24, 2005 12:34 PM
To: mysql@lists.mysql.com
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have more
than one phone number
so the db would be:
stu
> Something like this would make more sense to me and provide greater
flexibility;
It doesn't to me...
> student
>
> student_id
> name
> age
>
> address
> ---
> address_id
> street_name
> city
> state
> zip
What addresses are these? Random addresses where a studen
From: Mike Johnson [mailto:[EMAIL PROTECTED]
> From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
>
> > the problems is, when I want to query both student, address
> > and phone num, the sql will be
> >
> > select * from student s, address a, phone_num n
> > where s.student_id = a.sudent_id
> > and
From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
> Hi, here is the case:
>
> one student may have more than one address, and one student
> may have more than one phone number
>
> so the db would be:
>
> student
>
> student_id
> name
> age
>
> address
> ---
> address_
PROTECTED]
Sent: Tuesday, May 24, 2005 1:34 PM
To: mysql@lists.mysql.com
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have
more than one phone number
so the db would be:
student
student_id
name
age
address
esday, May 24, 2005 1:34 PM
To: mysql@lists.mysql.com
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have more
than one phone number
so the db would be:
student
student_id
name
age
address
---
addre
Hi, here is the case:
one student may have more than one address, and one student may have more
than one phone number
so the db would be:
student
student_id
name
age
address
---
address_id
student_id
street_name
phone_num
--
student_id
num
extensio
I haven't created real project tables yet.
But here are the test ones that I'm experimenting with.
CREATE TABLE east (
id int(11) NOT NULL auto_increment,
keywords varchar(255) default NULL,
east_1 varchar(255) default NULL,
PRIMARY KEY (id)
) ;
CREATE TABLE north (
north_id int(11) NOT
If you posted your actual table structures (SHOW CREATE TABLE xx\G) I
think I could be more helpful. Right now I am just "shooting in the dark".
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
James <[EMAIL PROTECTED]> wrote on 04/26/2005 02:15:49 PM:
> I tried that and
I tried that and maybe I'm doing something wrong but...
-I have to select the same number of columns...for each UNION
-And each of the records from the union fall under the same column
headings as the first SELECT...
I even tried to define column aliases..
SELECT `running` as `running_blah`...
-J
james tu <[EMAIL PROTECTED]> wrote on 04/26/2005 12:06:34 PM:
> I have four different activities. Each has its own set of data that
> I want to save. So, I made four different tables to hold the saved
> data. Each record also has 'keywords' field (essentially this is the
> only field that all
I have four different activities. Each has its own set of data that
I want to save. So, I made four different tables to hold the saved
data. Each record also has 'keywords' field (essentially this is the
only field that all tables have in common.)
Later on, I want to search all the keywords i
Mahmoud,
>Are these values atomical?
>My other question is what are the repercussions of
>not putting a table in 2nd and 3rd Normal Form.
Your 'choice1-subchoice1' etc are combined values, so they aren't
atomic. From your three example dropdown values, it looks as if
'choice' and 'subchoice'
Hello,
I have two questions:
I would like to know whether I am violating the principle of atomicity in
doing the following:
I have a form which has a field with the following options: Choice1, choice2
and choice3.
Each of the above choices have two further subchoices : subChoice1,
subchoice2.
My answers interspersed below (and yes, I have read his follow up reply
that had additional information)
Giulio <[EMAIL PROTECTED]> wrote on 10/11/2004 05:44:43 AM:
> Hi all,
>
> I have some doubts about how to implement this kind of scenario:
>
> I have a table of elements in cronological ord
Il giorno 11/ott/04, alle 11:53, [EMAIL PROTECTED] ha scritto:
I think you need to explain what kind of SELECTs you want to do, and
what
results you expect.
you're right, I'll try to explain it better
I'm working on a system that must keep track of all the music
broadcasted by a tv,
so, let's c
I think you need to explain what kind of SELECTs you want to do, and what
results you expect. How do you expect to get results from a SELECT which
returns hits in both the B and C tables? If you expect to do this, then
the D table is probably your correct answer. Do you really need a rec_type
f
Hi all,
I have some doubts about how to implement this kind of scenario:
I have a table of elements in cronological order, let's call it table A:
for every A element, I have a number of elements ordered on a
progressive number.
This could be a simply one-to-many relation, where I can handle a list
I've got a history table that performs a similar function. except in my
case I can have more than 1 active row. I put in an "is_active" column
and defined the type as a bool. an enum is actually a String in mysql,
which i didn't want to deal with. This table has only a few thousand
rows, so per
I have some data that is stored by the year it is related to. So I have one
table that stores the Year the data is related to, among other things. At any
given time, 1 year is considered the 'active year', and the rest are
considered inactive.
The table is something like:
CREATE TABLE Data_Inf
>
> To follow your example, I would add these other fields to the
> listings_projects table you defined below, and restructure the query
> around that?
>
> Thanks for your insight!
>
> -Erich-
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL P
around that?
Thanks for your insight!
-Erich-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 11:51 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Design Question
As posted, your data structure supports two one-to-many rela
As posted, your data structure supports two one-to-many relationships, not
the one-to-one relationships as you described. You can have multiple
Listings per Category and multiple Categories per Group. What it sounds
like you have been asked to do is to support a many-to-many relationship.
You
You are right, a comma separated "list" won't work since you won't be
able to do joins on it. To create a one to many relation, you actually
need to create another table to hold the relation.
CREATE TABLE listCatLink (
ListingID bigint(20) unsigned NOT NULL,
CategoryID int(11) NOT NULL
)
On Aug
EB> My thought was to add a new field to the listings table that would
EB> contain a comma-separated list of CategoryIDs, but something doesn't
EB> feel right about this solution.
> This would break the first normalization form and is extremely bad
Okay - I thought something was off...
> First o
Hi all,
I need some advice on a project I have. Basically, I have some tables:
CREATE TABLE listings (
ListingID bigint(20) unsigned NOT NULL auto_increment,
CatalogNumber varchar(12) NOT NULL default '',
PDFLink varchar(100) default NULL,
PDFName varchar(80) default NULL,
Title varch
Justin French <[EMAIL PROTECTED]> wrote:
> Should I worry at 40,000? 100,000? Or will the indexing of the siteID
> keep everything extensible?
Indexing is designed to keep SELECT speed small with no matter how much data it
is. You should ensure that the siteID index is properly used (use EXPLAI
Hi all,
I'm in the planning phase of a hosted web application where all
instances of the app (a sort-of website CMS) will be running off a
single code source. I've got a clear picture about everything except
for the database design.
a) I could have a separate database & table structure for eac
On Thu, 2004-05-20 at 07:13, Lewick, Taylor wrote:
> Hi all, I am having a little trouble deciding how to relate some of my
> tables together.
>
>
>
> I was wondering about creating one big lookup table to relate 3 or 4
> tables together, but wasn't sure if that was a good id, or should I have
To simplify, is It better to have many smaller lookup tables or one big
one?
Traylor:
You can create three entity tables (organization,contact,event) + the relation
tables (org_contact, org_event, contact_event). Small lookup tables are usually
better, and also give you points for sticking to
Hi all, I am having a little trouble deciding how to relate some of my
tables together.
I was wondering about creating one big lookup table to relate 3 or 4
tables together, but wasn't sure if that was a good id, or should I have
a look up table
For each pair of tables.
Here is a simple ex
bject: Database design question
Hi,
I'm writing a database for an online candle store. Here's the situation.
This store sells all sorts of items including candles. Now the gist is that
some of the candles can be made in different types of waxes and some only
have one wax. My question is h
Everything I've read about creating online stores is that you are
selling inventory items, not the items that makeup the inventory item.
So if you sell a red candle made from wax X, candle is the product and
red wax X are two attributes of the product.
Ideally your structure would work for any p
"JOHN MEYER" <[EMAIL PROTECTED]> wrote on 07/04/2004 15:39:10:
> Hi,
> I'm writing a database for an online candle store. Here's the
> situation. This store sells all sorts of items including candles.
> Now the gist is that some of the candles can be made in different
> types of waxes and
Hi,
I'm writing a database for an online candle store. Here's the situation. This store
sells all sorts of items including candles. Now the gist is that some of the candles
can be made in different types of waxes and some only have one wax. My question is
how do I resolve this when I write u
izational point of view (as you say) and scalability pov too, to split
it up into multiple databases.
Thanks,
Matt
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of TO
Sent: 21 March 2004 15:14
To: [EMAIL PROTECTED]
Subject: multiple databases: design question
What
What are the advantages and disadvantages of using multiple databases, versus
placing all tables in one uber-database?
I understand and appreciate the organizational value of multiple databases,
but what other issues are involved?
I ask this because I'm considering moving from tables across mu
rmck wrote:
I have "ip_address" and "ports" that I want to use in my table. I was just going to make each one a varchar. But was wondering if anyone has a better suggestion?
Should I use int for "ports", which will have an index. Not sure how to store "ip_address".
Use a varchar for the IP add
Mark Matthews wrote:
Jochem van Dieten wrote:
rmck said:
I have "ip_address" and "ports" that I want to use in my table. I
was just going to make each one a varchar. But was wondering if
anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for storing IP addresses. That means th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jochem van Dieten wrote:
> rmck said:
>
>>I have "ip_address" and "ports" that I want to use in my table. I
>>was just going to make each one a varchar. But was wondering if
>>anyone has a better suggestion?
>
>
> PostgreSQL ;-)
>
> It has a native da
rmck said:
> I have "ip_address" and "ports" that I want to use in my table. I
> was just going to make each one a varchar. But was wondering if
> anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for storing IP addresses. That means that
things like sorting and subnet inclu
I have "ip_address" and "ports" that I want to use in my table. I was just going to
make each one a varchar. But was wondering if anyone has a better suggestion?
Should I use int for "ports", which will have an index. Not sure how to store
"ip_address".
This table has the possibility of having
I have a contract that has about 6 fields that need to be filled out each time it is
signed. My goal is to have a form that only asks for the missing information then
includes that into the contract which is then printed and then stored in a database
completed. There would be 3 unique things a
That worked like a charm, thanks so much! I don't know why I didn't try
that before!
Julian
At 02:46 PM 11/21/2003 -0600, Paul DuBois wrote:
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea of
creating a tale for each day. M
ql List
Subject: RE: DB design question - shell scripting...
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a pr
Wouldn't this also work?:
mysql -u root -p -e "CREATE TABLE t$date(...)" yourdatabase
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject: RE: DB design question -
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a problem: I wrote
the following:
#!/bin/sh
date=`date "+%m%
[EMAIL PROTECTED]>
To: "Andy Eastham" <[EMAIL PROTECTED]>; "Mysql List"
<[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 7:56 AM
Subject: RE: DB design question - shell scripting...
> Andy,
> Thanks for responding. I think that I am going to go with the ide
o check that you're not searching the earliest or
latest available table, and if so, modify the union so that you don't try to
search a non-existent table.
Hope this helps,
Andy
> -Original Message-
> From: Julian Zottl [mailto:[EMAIL PROTECTED]
> Sent: 21 November 200
12:03
> To: [EMAIL PROTECTED]
> Subject: DB design question
>
>
> Hello all,
> I am designing a database right now that will have between
> 300-400k inserts
> per day. I need to keep this information for approximately 3 months and
> will probably do 5-10 reads on the data s
Hello all,
I am designing a database right now that will have between 300-400k inserts
per day. I need to keep this information for approximately 3 months and
will probably do 5-10 reads on the data set per day. I've been storing it
in one table up to now (only col.), but the searches are beco
> Table app_buss_section (nms_apps.id,
> buss_section.id)
>
> -Jeremiah
>
> -Original Message-
> From: James Walters [mailto:[EMAIL PROTECTED]
>
> Sent: Tuesday, July 29, 2003 9:42 AM
> To: [EMAIL PROTECTED]
> Subject: Basic Database Design Question
>
July 29, 2003 9:42 AM
To: [EMAIL PROTECTED]
Subject: Basic Database Design Question
Hello,
DB novice checking in here with a basic design
question. I have a table called 'nms_apps' which
stores information about all of our applications which
we have developed/maintained for our clie
have the basic idea of
relational data.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
> -Original Message-
> From: James Walters [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 29, 2003 10:42 AM
> To: [EMAIL PROTECTED]
> Subject: Basic Database Design Qu
Hello,
DB novice checking in here with a basic design
question. I have a table called 'nms_apps' which
stores information about all of our applications which
we have developed/maintained for our client. One
column which I would like to use is called 'used_by',
which wou
This question came up at work today, would like to get some fellow developer's
opinions:
Scenario 1: 2 tables to track checks
in terms of HD space a separate table would have been smaller since the checks table
grows at 1000+ per week, but there would only be a handful of returned checks. In
t
On 18-Jun-2003 NIPP, SCOTT V (SBCSI) wrote:
> Hello... I am currently working on a User Account Management
> system. I am actually a Unix SA who is "moonlighting" at work as a MySQL
> DBA and web developer. I am learning a lot and enjoying the work, but I
> am
> severely lacking in databa
[snip]
> Let's say that I have users Mary, Joe, Frank, and Dan. I also have
> servers panther, cheetah, jaguar and lion. The data for each account that I
> want to maintain is UID, GID, home directory, and default shell.
> In designing a table or tables to handle this example what can I
> make
Hello... I am currently working on a User Account Management
system. I am actually a Unix SA who is "moonlighting" at work as a MySQL
DBA and web developer. I am learning a lot and enjoying the work, but I am
severely lacking in database design fundamentals. I have created a couple
very
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 9:55 AM
To: [EMAIL PROTECTED]
Subject: mysql design question ?
| user_id | Marks | Now I have an other table where I keep the name
etc.. from each user. You will all kill me for this, but in access you
| user_id | Marks | Now I have an other table where I keep the name
etc.. from each user. You will all kill me for this, but in access you
could the setup a relation between user_id and the id of the user in the
user table. Is something like that possible in mysql ?
So that if I select some data
Dear all,
I'm designing a database for a travel company but i'm puzzled.. Maybe you can shed a
light on this:
I've got an travelpackage that can exicts of more possible departure date's but it has
also have more than one accommodation.
So 3 tables:
(table one)
-Travelpackageid (Primary Key)
-
I am fairly new to this, so please bare with me on this.
I am designing a database that stores information about the computers I
manage, and am developing a PHP front end to add, view, and edit information
about the computers. One issue I ran into is designing the hard drive
information. Some com
Hello to all,
I would like to set up a MySql database that will
store trip information for a milage lookup
program. The user will enter the origin city/st and
the destination city/st for some predefined trips.
Then the query will need to return the milage broken
down by state. For example, for
I would like to set up a MySql database that will
store distance information for a milage lookup
program. The user will enter the origin city and the
destination city for some predefined trips. Then the
query will need to return the milage broken down by
state. For example, for an origin city i
1 - 100 of 142 matches
Mail list logo
