Are equi-joins faster than left joins?

I have 3 tables that are 1:1 and will always have a row for a given product,_code & date. If I want to join them together, is it going to be faster to use an equi join or a left join, or does it matter? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Auto increment?

I read your other replies about the timestamp not working. I still think adding the updated and created fields is a good idea in general, to any table. I have some questions about the below since the original suggestion would not work for you. On Apr 2, 2009, at 12:35 AM, Andreas Pardeike

Re: mysqldump failing to load data

Hi, On Thu, Apr 2, 2009 at 1:18 PM, Virgilio Quilario wrote: >> Hi, >> >> MySQL v4.1.22 on Linux 2.6.18-6-686 >> >> I have a dump file generate with mysqldump created by a version 4.1.10 >> server. >> >> I want to import the dump file into a different server. When I run >> >> mysqldump --databas

Re: mysqldump failing to load data

> Hi, > > MySQL v4.1.22 on Linux 2.6.18-6-686 > > I have a dump file generate with mysqldump created by a version 4.1.10 server. > > I want to import the dump file into a different server. When I run > > mysqldump --database mydb --debug < mydumpfile.sql > > I get the following: > > -- MySQL dump 1

Re: Auto increment?

Steve & Scott, Thanks for the suggestions. The problem with a timestamp is that it's not fine granular. The consumer application can record last_poll_time and if it is X then either of the following will not work: 1) select * from table where tstamp >= X -> this fails because it will receive r

Re: Auto increment?

On Apr 2, 2009, at 12:51 AM, Steve Edberg wrote: At 9:35 AM +0200 4/2/09, Andreas Pardeike wrote: Hi, I have a table 'test' +-+--+--+-+--- ++ | Field | Type | Null | Key | Default | Extra | +-+-

Re: Auto increment?

At 9:35 AM +0200 4/2/09, Andreas Pardeike wrote: Hi, I have a table 'test' +-+--+--+-+---++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+---+---

Auto increment?

Hi, I have a table 'test' +-+--+--+-+--- ++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+--- ++ | id | int(11) | NO |

re: Question!

Hi! > "Jarikre" == Jarikre Efemena writes: Jarikre> Dear sir, Jarikre>   Jarikre> I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites. Jarikre>   Jarikre> Please, how do I import, upload/export Mysql database to a w