Hi,
I'm sure this is a stupid question, but I haven't been able to find
it myself. Surely there must be a free PHP utility to
web-administrate a MySQL database? I use CocoaMySQL
(http://cocoamysql.sourceforge.net/) on my own Mac, but it isn't
suitable for online databases. Can anyone lead me
@lists.mysql.com
Subject: MySQL database design documentation
Hi,
I'm sure this is a stupid question, but I haven't been able to find
it myself. Surely there must be a free PHP utility to
web-administrate a MySQL database? I use CocoaMySQL
(http://cocoamysql.sourceforge.net/) on my own Mac
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3, which was easy. I've installed Perl support for MySQL,
which was suprisingly difficult. I've installed CocoaMySQL
(http://cocoamysql.sourceforge.net/) to create, inspect and backup
databases. And now I'm
- 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,
Hi,
We are developing an application that needs to use a massive back-end
database. The database will contain around 75 million rows with around
80 columns per row. We would prefer to use MySQL as the database
platform as it is free. The MySQL database would be hosted on a
dedicated server that
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
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
)
VALUES (3,3,.5);
-Original Message-
From: Colaluca, Brian [mailto:[EMAIL PROTECTED]]
Sent: Friday, 10 January 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: MySQL Database Design
I am in the midst of designing a personal database for keeping track of
wines. After perusing through several
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
I am in the midst of designing a personal database for keeping track of
wines. After perusing through several beginner books on MySQL and PHP, I
have decided that my next step would be to embark upon database design.
My design is almost complete and normalized, although I do expect to be
on the naming conventions I have
illustrated. Use what you like best.
-Original Message-
From: Colaluca, Brian [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 12:56 PM
To: [EMAIL PROTECTED]
Subject: MySQL Database Design
For instance, let's say that wine XYZ has 80% GrapeA
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
2002, david wrote:
Date: Sun, 11 Aug 2002 00:43:14 -0400
From: david [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL database design, one column, 10 entries?
I am creating several tables in MySQL and linking via primary keys. I am held
up on one issue, for one row in one table i have
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 otherwise develop this
db?
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 creating several tables in MySQL and linking via primary keys. I am held
up on one issue, for one row in one table i have a column 'favorites' where i
want to hold up to 10 unique entries, how do i implement this?
userTable
userId varchar(20)
name varchar(30)
email varchar(40)
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
21 matches
Mail list logo