Hello,
Two admin tools to check out if you haven't already...
PHP, you can try PHPMyAdmin - http://www.phpmyadmin.net/home_page/index.php
Non-PHP, try MySQL's GPL MySQL Administrator -
http://dev.mysql.com/downloads/administrator/index.html
However, they too may not be suitable for remote
- Original Message -
From: Maurice van Peursem [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac OSX
10.3, which was easy. I've
A couple of good links for databases.
Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side
SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced:
Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206
The original edition was my first primer on relational databases. It was
an excellent read.
Ben
Maurice van Peursem wrote:
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3,
You can find a number of good starting point data
models here:
http://www.databaseanswers.com/data_models
You might also check out some of the applications on
sites like www.hotscripts.com and www.sourceforge.net
to see how they have structured their database for
similar projects. (or maybe you
Hi Brian,
By no means am I a MySQL guru (or any other database server environment
guru, for that matter), but could you simply have a reference table that
indicates the percentage of the grape used in the relevant wine?
So, you might have three tables, Wines, GrapeVariety,
ID a4
wine3 x
2 nulls
===end chatter
-Original Message-
From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 6:09 PM
To: Colaluca, Brian
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Database Design
Blend will be a cross reference with a one to many relationship
This is very simplified but an example of your data could be:
Select * from Wine;
++--+
| WineID | WineName |
++--+
| 1 | XYZ |
++--+
Select * from Grape;
Colaluca, Brian wrote:
I have come to a brick wall on one facet of my design, however. I've come
to understand that having a lot of NULLs in your database may be a sign of a
poor design. And yet I'm having a problem reconciling this with the wildly
un-uniform world of wines from around the
You need to add an additional table, favorites.
It should have three columns:
favoriteID INT,
userID INT,
favoriteTypeID INT REFERENCES FavoriteType.
Plus the additional column for the rating, assuming it's associated with a
favorite.
Each row represents a single preference (this way users
At 8/11/2002, you wrote:
MySQL queries.. tables... design.
http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
There you will see a rough draft of what I am trying to do.
Perhaps you will see some places that I will need to use a table_map?
Or you can advise me of how to arrange my keys, or
on 8/11/02 2:47 PM, Pekka Saarinen, typed:
At 8/11/2002, you wrote:
MySQL queries.. tables... design.
http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
There you will see a rough draft of what I am trying to do.
Perhaps you will see some places that I will need to use a table_map?
At 8/11/2002, you wrote:
I believe that what you called intermediate table books are calling
table map, or something with the word map in it.
Hi Lloyd,
Books are nice to have (you can lie down to a sofa or sit in the loo with a
book), and what I started with (SAMS Teach Yourseft MySQL in 21
I am not very sure I understand the questionbut maybe column type 'enum'
is what you are looking for.
- Original Message -
From: david [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 10, 2002 9:43 PM
Subject: MySQL database design, one column, 10 entries?
I am
14 matches
Mail list logo