RE: Getting Oriented: Political versus Ecological Geography

Hm... I think you were an even bigger help than I anticipated! If I understand correctly, I need to fix the tables I've already created. Consider three tables - Continents, Nations and States - which look something like this: CONTINENTS North America | New World | West [Hemisphere] | cna (cod

RE: Getting Oriented: Political versus Ecological Geography

For what i understand, what you need to do is create this structure: Characteristic K Char_Code Char_Description Continent K Con_Code Con_Description Country K Cot_Code Cot_Description Cot_Continent ( This is the code of a continent in the table continent) Country_Charact K Des_Countr

Re: Optimizing Queries (specifically with LIMIT)

(reconstructed from archives i accidentally deleted the copy in my mailbox Daniel Clark writes: I don't see how LIMIT would make a difference. LAST_INSERT_ID() only returns one record. But it's worth trying in a big loop to get timing numbers. Well, I decided to test this all out and see what ha

Re: Getting Oriented: Political versus Ecological Geography

--- Peter Brawley <[EMAIL PROTECTED]> wrote: > >In the states table, should I list Colorado's > regions > >in three cells... Great Plains | Rocky Mountains | > >Colorado Plateau, or group them in one cell, like > >this: > > >Colorado | state | grasslands, Rocky Mountains, > >Colorado Plateau | co

RE: MySQL Benchmark.

At 05:12 PM 5/29/2004 -0500, you wrote: Now the fun part becomes which linux distro do you use? Which is faster? Because trust me, each distro will benchmark differently. Let the games begin! Donny I've seen benchmarks from people who did different linux distros, and they were all pretty much with

RE: MySQL Benchmark.

Now the fun part becomes which linux distro do you use? Which is faster? Because trust me, each distro will benchmark differently. Let the games begin! Donny > -Original Message- > From: JG [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 29, 2004 4:34 PM > To: [EMAIL PROTECTED] > Subj

RPM install upgrade error / ver. 4.0.20

Hello, got this error when updating our MySQL: rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm Preparing...### [100%] file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0 conflicts with file from package MySQL-shared-compat-4.

Re: 'group by' does a free 'sort by'?

[EMAIL PROTECTED] wrote: Guys - I think this fusing of GROUP BY and ORDER BY is a bad thing - even if it works. GROUP should group and if you want an order - add an ORDER clause explicitly. Yes, the GROUP BY does a sort and you are tempted to leverage it, but it could lead to problems. It may not b

Re: MySQL Benchmark.

At 11:57 AM 5/27/2004 -0700, you wrote: At 11:02 AM 5/27/2004 -0700, you wrote: Hi, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on produ

Re: Transfer records from one table to another

At 02:13 PM 5/29/2004, you wrote: Hi,, I have database about national historical events and another one about world events.. Here's the structure: National events (d: day m: month a: year hecho: fact) |---| | id| d | m | a |h

Re: Cluster and Fulltext indexes?

At 01:39 PM 5/29/2004, you wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano - Santino, Where does it say that in the docs? Can you post the documentation that says f

Cluster and Fulltext indexes?

Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

Re: Lots of databases...how wrong is it?

Le sam 29/05/2004 à 15:28, Ryan Fox a écrit : > It depends on the table type, but I'll gear my answers toward myisam. > > MySQL uses the os's filesystem calls to list directories. Slowdowns / > limits to the number of myisam databases will be caused by the > filesystem. > > > - how many database

Re: Transfer records from one table to another

INSERT INTO world SELECT * FROM national; PB - Original Message - From: tommie ramirez.andujar To: [EMAIL PROTECTED] Sent: Saturday, May 29, 2004 2:13 PM Subject: Transfer records from one table to another Hi,, I have database about national historical events and anothe

Transfer records from one table to another

Hi,, I have database about national historical events and another one about world events.. Here's the structure: National events (d: day m: month a: year hecho: fact) |---| | id| d | m | a |hecho | |-

Re: Lots of databases...how wrong is it?

On Sat, May 29, 2004 at 02:31:08PM +0100, Yannick Warnier wrote: > Hi there, > All of my my comments are base don my personal experience: > - how wrong is creating 20 databases (total 400 tables) when you know > you could create just one (total around 200 tables)?

Re: Optimizing Queries (specifically with LIMIT)

I don't see how LIMIT would make a difference. LAST_INSERT_ID() only returns one record. But it's worth trying in a big loop to get timing numbers. >>I have a rather simple straightforward question that I was not able to find >>in any of the documentation. >>I am in the process of writing an

Re: Getting Oriented: Political versus Ecological Geography

>In the states table, should I list Colorado's regions >in three cells... Great Plains | Rocky Mountains | >Colorado Plateau, or group them in one cell, like >this: >Colorado | state | grasslands, Rocky Mountains, >Colorado Plateau | co | cna | 5 >It gets even trickier, because I may link Colora

Re: "Batch" Update?

For reference, multiple-table updates are documented in the manual . They work starting with mysql 4.0.4. Michael Peter Brawley wrote: UPDATE tableA, tableB SET tableA.column2 = tableB.column2 WHERE tableA.rowID = tableB.rowID; PB - Original

Re: Optimizing Queries (specifically with LIMIT)

LAST_INSERT_ID is connection-specific, not table-specific. When you say, SELECT LAST_INSERT_ID() FROM foo; you are asking for the LAST_INSERT_ID to be repeated once for each row of table foo. This is analogous to SELECT NOW() FROM foo; or SELECT 2 FROM foo; Adding a LIMIT would work, but

Re: Extending mySQL

Hi! On May 25, Yiannis Mavroukakis wrote: > Hello, > > I'm hoping this is the correct list to post my question ( I was also > considering mysql internals), if not accept my apologies. Yes, internals@ would be better for these kind of questions. > I wish to write a mySQL extension, that will do

Optimizing Queries (specifically with LIMIT)

Hello, I have a rather simple straightforward question that I was not able to find in any of the documentation. I am in the process of writing an application, and I was wonder whether there is any benefit (or penalty) in LIMIT(ing) a LAST_INSERT_ID() query? i.e. SELECT LAST_INSERT_ID() FROM foo

Lots of databases...how wrong is it?

Hi there, I am using a mysql server at the moment which contains 2800 different databases. phpmyadmin is really slow listing them, but that's not really a big deal. The thing is my view on this set of databases (every database contains about 20 tables) is it is really bad, because actually there