Hi, Shawn,
Thanks for replying. What i meant is that i would also like to create a
table with "site types", where i would have a listing of possible sites,
like arqueology, natural, etc. and maybe use it to redirect the queries
instead of having to hardcode the table name when i need to list a spe
On 7/8/2010 11:29 PM, Miguel Vaz wrote:
Hi,
I am having some uncertainty while designing the following structure:
I have two sets of data:
* arqueology sites (can be natural):
id
name
description
id_category
id_period
x
y
* natural sites (can be arqueological also - bear with me -, so there
At 5:32a -0400 on Fri, 16 May 2008, Ananda Kumar wrote:
>>> 2 Index would do range scan, which would be comparitivly slower.
>>
>> Not exactly. This, again, depends on implementation and the
>> data against which queries are run. An index is an index.
>> Remember, a primary key is implemented by
Hi Kevin,
> 2 Index would do range scan, which would be comparitivly slower.
Not exactly. This, again, depends on implementation and the data
against which queries are run. An index is an index. Remember, a
primary key is implemented by the MySQL engine as a unique not null
b-tree index. In f
At 2:49a -0400 on Fri, 16 May 2008, Ananda Kumar wrote:
> it goes without saying
Eh, not to those who don't know. Hence the list and question. :-D
Krishna, the short answer is that it depends on your data, and the
queries against it that you run. Test/benchmark on your own DB and data
to see w
it goes without saying
1. primary key and unique key would do unique scan which is fastest of all
scan
2 Index would do range scan, which would be comparitivly slower.
regards
anandkl
On 5/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I would like to know which is f
Hi,
I would like to know which is faster out of the below.
Primary Key
Unique Key
Indexing
Give the numbering 1, 2 and 3
Thanks a lot
On Thu, May 15, 2008 at 5:49 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> If both (user_id,delivery_id) can be made primary key, then the second
> index would
If both (user_id,delivery_id) can be made primary key, then the second index
would not be required. But the performance of the query would be better if
it reads one index rather than indexes on each COLUMN in the "WHERE CLAUSE"
On 5/15/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> H
Hi,
Since user_id is a primary key. It should work either with any of the column
and with both the column.
Any suggestion.
Thanks
On Thu, May 15, 2008 at 1:22 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Tue, May 13, 2008 at 1:30 AM, Krishna Chandra Prajapati
> <[EMAIL PROTECTED]> wrote:
>
On Tue, May 13, 2008 at 1:30 AM, Krishna Chandra Prajapati
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Below is the user_delivery table structure.
>
> CREATE TABLE `user_delivery` (
> `user_id` decimal(22,0) NOT NULL default '0',
> `delivery_id` decimal(22,0) NOT NULL default '0',
> `send_to_regula
i cant seem to access the server times out :|
http://www.research.att.com/sw/tools/graphviz/download.html
-Original Message-
From: Nicholas [mailto:[EMAIL PROTECTED] Behalf Of
Nicholas Spagnoletti
Sent: Friday, April 04, 2003 1:28 AM
To: [EMAIL PROTECTED]
Subject: Re: table structure
Hi
About Entity Relationship Diagrams: I use Graphviz to generate ERD's on
the fly, from the database. Graphviz is very cool:
http://www.research.att.com/sw/tools/graphviz/
Graphviz draws graphs from files written in its language (called 'dot')
Your PHP script (or language of choice) needs to get
Lots of them. None cheap. What ever you do, steer clear of the one at
www.thekompany.com. It's a piece of crap. I bought a version and then
foolishly bought an upgrade thinking it would be better. it's not and the
primary programmer for the project is very arrogant on the mailing list
setup for
> is there any table structure design program in a graphical layout for
windows available ? i have tables and
> fields on paper but would like a way to be able to lay them out on a
screen and show which table joins to
> what and what keys it uses let me know thanks
You can use EMS MySQL Manager fo
Hello,
I`m doing a database in MySQL to catalog cds, and i`m not sure if my table
structure is the best way to do it:
Artist Table
Artist_Id int unsigned not null auto_increment primary key
Name char(120) // Artist or Band Name
Country char(30) // Artist Or Band Country
Members char(255) // Ba
On Monday 13 May 2002 1:49 pm, Taylor Lewick wrote:
> Hi All, I am fairly new to mysql..
> I am using perl, mysql, and apache to do a little development, and to learn
> quickly I am trying to do some real dbase transactions...
>
> I have a program whcih gets a bunch of stock quotes from the intern
16 matches
Mail list logo
