I am at the planning stage of building a database that will have a fairly
large amount of different information. It is a DB for law firms, so it will
have all of their contact information including a county. Also an individual
lawyer will be listed. Add to that 2 description areas (one for
: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 3:45 PM
To: mysql@lists.mysql.com
Subject: Re: database structure
On Mon, July 2, 2007 21:10, Hiep Nguyen wrote:
take your advice, i looked in to JOIN and i got the idea. but i noticed
that in order to use JOIN, don't you
for all your helps
T. Hiep
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 3:45 PM
To: mysql@lists.mysql.com
Subject: Re: database structure
On Mon, July 2, 2007 21:10, Hiep Nguyen wrote:
take your advice, i looked in to JOIN and i got
Hi all,
i'm seeking for help/suggestion on how to create relationship for this
scenario:
I have one table (tag) with the following fields:
tagid, location, weight, grade, heat, shape, diameter, length, width,
height, ... (and many other fields)
what i want to do is move the shape field
is this list working? my last post failed? re-try.
T. Hiep
-- Forwarded message --
Date: Mon, 2 Jul 2007 05:53:17 -0700 (PDT)
From: Hiep Nguyen [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create
-4100, x105
[EMAIL PROTECTED]
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 8:53 AM
To: mysql@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create relationship for this
scenario:
I have one table
:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 8:53 AM
To: mysql@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create relationship for this
scenario:
I have one table (tag) with the following fields:
tagid, location, weight, grade, heat, shape
- Experts in Healthcare Learning
(516) 478-4100, x105
[EMAIL PROTECTED]
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 8:53 AM
To: mysql@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create
]
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 8:53
AM
To: mysql@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create relationship for this
scenario:
I have one table (tag) with the following fields:
tagid
of the times,
regardless of the shape.
Sincerely,
Raj Mehrotra
hccs - Experts in Healthcare Learning
(516) 478-4100, x105
[EMAIL PROTECTED]
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Monday, July 02,
2007 8:53 AM
To: mysql@lists.mysql.com
Subject: database structure
Hi
@lists.mysql.com
Subject: database structure
Hi all,
i'm seeking for help/suggestion on how to create relationship for this
scenario:
I have one table (tag) with the following fields:
tagid, location, weight, grade, heat, shape, diameter, length, width,
height, ... (and many other fields)
what i
On Mon, July 2, 2007 21:10, Hiep Nguyen wrote:
take your advice, i looked in to JOIN and i got the idea. but i noticed
that in order to use JOIN, don't you need to have the same column name in
both tables? i just don't see it in your example here. is there
something that i'm missing?
of
permissions can be specified and translate directly into SQL queries?
For example, what if, for a software release, one says, to view this
software release, a user must be in Group X or Group Y, but not in Group Z
and not user Q? Is there a database structure and a corresponding
O(log N
? Is there a database structure and a corresponding
O(log N)
query that will quickly find for a given user what software releases
may be
viewed?
Thanks.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving
and translate directly into SQL queries?
For example, what if, for a software release, one says, to view this
software release, a user must be in Group X or Group Y, but not in Group Z
and not user Q? Is there a database structure and a corresponding O(log N)
query that will quickly find for a given user
Hello all,
I am currently working on redesigning a database structure for online
translation utility called Entrans [1].
Entrans is quite nice piece of software, but unfortunately it has one
major design flaw: it only supports languages which have only two plural
forms and to fix this issue
bruce wrote:
hi...
i'm considering an app where i'm going to parse a lot of colleges (~1000)
faculty information. would it be better to have all the faculty information
in one large table or would it be better/faster to essentially place each
college in it's own separate table, and reference
You may want to look into normalization to keep
everything organized. However if you want pure query
speed, you will have to de-normalize some of your
tables to get optimum speed.
Have a look here for info on normalization:
http://databases.about.com/od/specificproducts/a/normalization.htm
HTH
hi...
i'm considering an app where i'm going to parse a lot of colleges (~1000)
faculty information. would it be better to have all the faculty information
in one large table or would it be better/faster to essentially place each
college in it's own separate table, and reference each table by a
bruce wrote:
hi...
i'm considering an app where i'm going to parse a lot of colleges (~1000)
faculty information. would it be better to have all the faculty information
in one large table or would it be better/faster to essentially place each
college in it's own separate table, and reference
@lists.mysql.com
Subject: Re: database structure question...
bruce wrote:
hi...
i'm considering an app where i'm going to parse a lot of colleges (~1000)
faculty information. would it be better to have all the faculty information
in one large table or would it be better/faster to essentially place each
I would strongly recommend creating one table, with a column that stores
the college_ID for each faculty member, and a separate table to
correlate college name and college_id. For example...
Create table faculty (
last_name varchar(50),
first_name varchar(50),
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 6:07 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: database structure question...
I would strongly recommend creating one table, with a column that stores
the college_ID for each faculty member, and a separate table
bruce wrote:
even though this might mean i get a table with 5 million records??? as
opposed to say a 1000 different tables, each with 50,000 records?
-bruce
That's right.
Databases are made for this sort of thing.
If you have a separate table for each location, constructing queries to
pull
You have not said what type of information you will be storing in this
database. Is it going to be just faculty information? Even if it is
just faculty information, you do realize that each school treats
departments a bit dfferently. The faculyt maybe under different
school, may specialize in
Hi,
I´m working in a project of a database that should be grow
to more than 25,000,000 of clients.
For all I´ve read in MySQL manual pages it´s too much records
to place in only one table.
So, my main doubt is how to divide it.
I divide the client table in few tables according with the
Where did you read that 25 million records would be a problem? I've
heard of people with billions of records in one table. The only
question would be performance, but indexes would largely take care of
that. You may run into issues with the physical size of the table and
the underlying OS not
PROTECTED]
Subject: Re: Database structure
Where did you read that 25 million records would be a problem? I've
heard of people with billions of records in one table. The only
question would be performance, but indexes would largely take care of
that. You may run into issues with the physical
Hi List,
Do changes in database structure replicate to the slaves from the master? Is
there a document somewhere in the manual (I have not found one) that explains
what gets replicated and what does not? Specifically, does an ALTER TABLE
get replicated? There is some mention
In the last episode (May 04), Jim said:
Do changes in database structure replicate to the slaves from the
master? Is there a document somewhere in the manual (I have not
found one) that explains what gets replicated and what does not?
Specifically, does an ALTER TABLE get replicated
Hello,
I would like an advise on the following problem :
I have a table of patients.
Each patient can make different biological assessments.
Each assessment is always decomposed into different laboratory tests.
A laboratory test is made of a test number and two values coming from analysers.
I used to program for a medical tester.
I used method 2:
2 - a table with 60 rows for one assessment :
results(#assessment_nr, labtest_nr, p, d) where p and d are my two
results.
The BIG advantage was changes to the tests, adding new ones, or deleting
fields. Made it much more flexible.
The schema is :
Patients(#patient_nr,name,etc...)
Assessment(#assessment_nr, #patient_nr, assessment_type, other usefull
values).
Assessment_types(assessment_type, labtest_nr)
An assessment is composed of different tests, let's say assessment type 1
is
composed of lab test 1,2,3,5 and
Hi, all,
I'm still very much a newbie at MySQL, and thought a good starter project
would be a simple places database of every populated place-name in the world
along with its latitude and longitude. I already have the data, and
originally planned to have only 4 tables with 2-4 fields each:
I didn't key the placename because they're not guaranteed to be
unique, but that means that a search for Artesia takes many (~30)
seconds to complete, which is really not very useful.
You should not use the placename as a PRIMARY KEY, but it can still have
an index. You really should add a
Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David
David Perron wrote:
Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David
mysqldump -d
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77
, at 5:05 PM, Daniel Kasak wrote:
David Perron wrote:
Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David
mysqldump -d
--
Daniel Kasak
IT Developer
NUS
I have moved our database from Access to MySQL, but I did leave same structure.
Problem is that in our business we deal with companies that have multiple
branches so having it like we have now with sub queries and subforms that have
to look up info from 3 tables to give me one record of contact
Read up on database normalization. (do a search on
your favorite search engine) It will give you an
appreciation of storing related pieces of info in
different tables. Though you shouldn't need a series
of forms to access the data (most of the time) - this
has more to do with your programming
It might also help to at least try to understand why you normalize. Don't
just try to follow the rules, there is some art to it as well.
My favorite book on this is Database Design for Mere Mortals
Thanks,
Eric
At 09:11 PM 10/22/03 -0700, olinux wrote:
Read up on database normalization. (do
Does anyone know if there's a way in MySQL have the same functionality
without installing the whole program on a users machine? I'm using a Java
program along with Connector/J and a MySQL DB. We are trying to make it so
the user doesn't have to install MySQL everytime they want to install the
Stephanie,
Does anyone know if there's a way in MySQL have the same functionality
without installing the whole program on a users machine? I'm using a Java
program along with Connector/J and a MySQL DB. We are trying to make it so
the user doesn't have to install MySQL everytime they want
Stephanie,
Connector/J takes advantage of client/server architecture over TCP. This
means that the MySQL server could exist on one machine (a server), and
the client application(s) can connect to it via TCP and Connector/J from
anywhere that has a TCP route to the MySQL server.
If Connector/J
Stephanie,
Without knowing the architecture of your program I cannot give a precise
answer. But I'll make a few stabs at it...
First, MySQL, being an application in its own right, can be installed
separately from your application. Alternately, your application's
installation program could
How are you connecting to MySQL?, through MySQL ODBC I
am assuming. I might happen that the ODBC driver for
MySQL does not implement ADOX functionality.
Have you tried to take a look to the MySQL++ API? You
might have to create your own dll (or COM component)
to modify the database structure
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Yes. You want to use mysqldump.
http://www.mysql.com/doc/m/y/mysqldump.html
On Sun, 24 Feb 2002 22:24:39 -0500, Pax wrote:
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
Yes.. Use the DUMP command
-Original Message-
From: Pax [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 9:25 PM
To: 'MySQL'
Subject: database structure script
Is there an easy way to create SQL script from existing database and use
it to create a new database?
Tks
Pax
I should have been more clear...
http://www.mysql.com/doc/m/y/mysqldump.html
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 24, 2002 10:03 PM
To: 'Pax'; 'MySQL'
Subject: RE: database structure script
Yes.. Use the DUMP command
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]On Behalf Of Bret Ewin
Sent: Monday, January 21, 2002 12:03 PM
To: 'Russell King'
Subject: RE: Help with Database structure..
You may also want to break the URL into pieces (protocol, domain, path,
file) and index each piece
Noah,
Sunday, January 20, 2002, 1:55:00 AM, you wrote:
NS The problem is that 20,000 tables can be a bit unwieldy for mysql to
NS handle.
I don't think it will be a sore work for MySQL to support more than 20,000
tables, but it's up to a inode limit on the filesystem on your OS.
As Russel
I need some help with a database design question:
To summarize our design (I'll spare you a lot of the details.)
We collect text files from 20,000 different sources every day. The actual
file is stored as a text file. Each source has its own table which contains
a list of the text files,
We thought about having one massive file for all this data, BUT, we
archive
something like 100,000 articles a day. We store articles for 6 months, so
this table would very quickly have 18,000,000 rows. Now, we need to
select
a group of articles based on source and date. We also need to
Hi,
I am looking for an easy way to synchronize two mysql-databases (only
the sql-structure). I want to compare two structure dumps, find out the
differences and get alter table statements as result.
CU
Dorthe
-
Before
Perhaps this is a common problem:
I would like to have a database field that contains multiple code numbers
and later search for the presence of one of the codes. What I have come up
with so far is using a delimter between the code numbers to end up with
a field like:
12534
When searching I'm
Create another table with an id column and a code column, and for each code
insert a column with the id of the row in the original database and the
code. Then do an SQL join to search. For example:
mysql create table example (id int(11) NOT NULL auto_increment, blah
varchar(100), PRIMARY
I have a database project, historic building materials...
I've designed 4 Tables like this (there are more fields which I didn't
listed here):
table products
- primary key(productid)
- product description
...
table category
- primary key(categoryid)
- category description
table subcategory
-
.
On 26 Jan 2001, at 2:26, Tobias Talltorp wrote:
As I understand it, search engines use a "special" type of database
structure. They have a special table for common words/phrases and
another one with all the data. They link theese together by a third
one that contains only the ids from
As I understand it, search engines use a "special" type of database
structure.
They have a special table for common words/phrases and another one with all
the data.
They link theese together by a third one that contains only the ids from
the other two, thus making the search much fast
I'm not sure what you mean by "structural changes".
If the the two table have the same number of columns and they are in the same order,
you can do something like what I have explained below. It you included the table info
from prod and test I could help you better (DESC prod;).
# Create
clearer.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 1:48 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: Re: Database structure DIFF
I'm not sure what you mean by "structural ch
eyeballing it...I'm just too lazy. :)
Thanks for replying. Hope I've made things clearer.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 1:48 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: Re
63 matches
Mail list logo