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 firm,
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
: 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,
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?
n [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, location, weight, grade,
any
shapes
you have. And your SQL statements will be generic, most 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, Ju
78-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 ta
j 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 all,
i'm seeking for help/suggestion o
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, l
(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 relationship for this
scenar
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 ho
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 in
e 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 what software releases
may be
viewed?
Thanks.
--
Chris W
KE5GIX
"Protect your digital freedom and privacy, eliminat
ay to structure a database so that other forms 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 the
er forms 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 corresp
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, a
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
-
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 ea
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 certa
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
p
-bruce
-Original Message-
From: Devananda [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 colleg
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),
college_id
@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
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 referenc
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
co
Ronan Lucio
> Cc: [EMAIL 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
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 b
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 different
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 ge
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 that
> 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 a
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.
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.
Th
> 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
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:
Pla
n 26, 2004, 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 Dev
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
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
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. (
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 logic
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 inf
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 incl
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 is
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 wan
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
prog
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
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..
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?
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
-
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/
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 K
-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
> 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
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, dat
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 postin
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 KEY(id)
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:
12&5&34
When searching I
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
- prima
.
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 cont
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 id´s from
the other two, thus making the search much fast
s or a mysqldump of the databases and comes up with a sql script:
> >
> > Alter table Table1 add myField4 int;
> > Alter table Table1 change myField1 myField1 varChar(60);
> >
> > Yes, I can do it by eyeballing it...I'm just too lazy. :)
> >
> >
> -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 changes
;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: Database structure DIFF
I'm not sure what you mean by "structu
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 t
Pardon the newbie question but is there a tool available for MySQL that I
can give it 2 databases and it give me the ALTER TABLE statements necessary
to make 2 identical to 1?
Specifically, I have a test and prod database. I've made structural changes
to test and want to propagate them to prod.
65 matches
Mail list logo
