Somewhat tangential, but for whatever it is worth I agree with the
view expressed at
http://weblogs.sqlteam.com/jeffs/archive/2008/02/13/on-right-outer-joins.aspx:
Right joins should be avoided (IMHO).
> Anything to add or correct, please?
--
Rob Wultsch
--
MySQL General Mailing List
For lis
That sounds like the technical answer. I prefer an analogy a 5th
grader could understand. If you have 2 overlapping circles, and inner
join is the area that overlaps. A left/outer join is the all of the
left circle plus the content of the right circle that overlaps. A
right/outer join is ju
I'm trying to understand the terminology a bit.
A left or right join can only exist for an outer join. For an inner
join, the terminology would be out of context because inner joins are
symmetrical (whereas outer joins are asymmetrical).
Would this be a correct understanding? Anything to add
To: <[EMAIL PROTECTED]>
|
| cc:
|
| Subject
Does anyone know if MySQL has the concept of Synonyms, as Oracle does?
Raza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"MaFai" <[EMAIL PROTECTED]> wrote:
>
> I would also like to know the impact when:-
> - the master db fail
> - a lot of insert/update transactions in the master, would it replicate
> immediately to the 2nd database
If the mater db fail, how can be many inserts/updates?
> - when the secondary db f
Hello, mysql,
I would also like to know the impact when:-
- the master db fail
- a lot of insert/update transactions in the master, would it replicate
immediately to the 2nd database
- when the secondary db fail, the master cannot send the data to the 2nd,
would the data queue up ?
- Any chance fo
"MaFai" <[EMAIL PROTECTED]> wrote:
>
> After I create this table,and add foreign key tno to this table.
> If I delete "tno" in "p_program_type" table,it would alarm that some data still in
> "p_schedule".
> How can I define the "p_schedule" or "p_program_type" table to make sure that while
> del
# [EMAIL PROTECTED] / 2003-06-24 16:48:24 +0800:
> After I create this table,and add foreign key tno to this table.
> If I delete "tno" in "p_program_type" table,it would alarm that some
> data still in "p_schedule".
> How can I define the "p_schedule" or "p_program_type" table to make
> sure that
Hello, mysql,
After I create this table,and add foreign key tno to this table.
If I delete "tno" in "p_program_type" table,it would alarm that some data still in
"p_schedule".
How can I define the "p_schedule" or "p_program_type" table to make sure that while
delete the tno in p_program_type,the
context ... I had proposed writing a new backend for mysql
tailored to read only very large and very wide (lots of columns)
tables (14G + )
in which queries never involved more than a small percentage
of the available columns (i.e. < 5%) and often lacked WHERE
clauses.
A couple years ago I argued
Hi,
If you mean the concept (in Oracle) where an instance is effectively one
database, the architectures differ a whole lot. Whereas Oracle, as I said,
creates an instance for each database it's running, MySQL can handle
several databases within one server process instance.
The concept of
On Tue, Jul 16, 2002 at 08:59:12PM -0300, Alexander Burbello wrote:
> I would like to know if MySQL has the same concept
> like Oracle has about Instance? or phisical structure
> like datafiles, control files, etc.
If you explain the concepts, we can probably help answer your
questions
I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.
Regards
Alexander
sql, query
___
Yahoo! Encontros
O lugar certo para
I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http
-Original Message-
> From: Gregory Junker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 11, 2002 5:23 PM
> To: MySQL
> Subject: RE: MySQL concept question
>
>
> if you are interested in selecting records in the order in which they
> were inserted, apply an auto-
Can I hide the auto_increment field?
-Original Message-
From: Gregory Junker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 5:23 PM
To: MySQL
Subject: RE: MySQL concept question
if you are interested in selecting records in the order in which they
were inserted, apply an
.
> -Original Message-
> From: Thi Cao [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 11, 2002 6:09 PM
> To: MySQL
> Subject: MySQL concept question
>
>
> All,
>
> When I insert records into a database, the records will be
> inserted in the
> order
On Thursday 11 April 2002 4:09 pm, Thi Cao wrote:
> All,
>
> When I insert records into a database, the records will be inserted in the
> order that I have them listed in my insert statement. So my question is,
> will the MySQL database always return the records in the order of insertion
> when I
All,
When I insert records into a database, the records will be inserted in the
order that I have them listed in my insert statement. So my question is,
will the MySQL database always return the records in the order of insertion
when I perform any type of select query in the future? Of course,
Rich and Alejandro,
Have I got a query for you! :)
Using Alejandro's example, here is a query that would work:
SELECT s.trans_id, b.price FROM sales s, rates a, rates b WHERE
a.item=s.item AND b.item=a.item AND a.date < s.date GROUP BY s.trans_id,
b.item, b.date HAVING b.date=MAX(s.date)
Steve
I've got the same issue that you do. Here is my thinking thus far:
Say I have a transaction table:
Record_Key
Service_Date
Item_Code
Item_Quantity
I'm considering this structure for the rate table:
Item_Code
Effective_Date
Rate
It's practical from a data entry perspective, but I can't seem to
Thu, 1 Nov 2001, Rick Emery wrote:
> Date: Thu, 1 Nov 2001 17:20:00 -0600
> From: Rick Emery <[EMAIL PROTECTED]>
> To: 'Alejandro Zuzenberg' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: Can I use the concept of Effective Date with MySQL?
>
> SELECT p
SELECT price FROM mytable WHERE price <= theprice DESC LIMIT 1;
-Original Message-
From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 7:53 PM
To: [EMAIL PROTECTED]
Subject: Can I use the concept of Effective Date with MySQL?
I need to select
I need to select the appropriate price for a product in a table, and the
product has a compund key with 2 fields: product number and date.
For every transaction with a certain product, I need to retrieve the price
that was 'current' at the specific time when that transaction took place.
In joinin
> i don't understand what does connecting from different host mean?
Where do you have this problem?
> 1. does it mean connecting from a different pc to the pc hosting the mysql
> server through telnet?
Why would you like to do that? looks like a masochistic
approach to me, under no
hi,
i don't understand what does connecting from different host mean?
1. does it mean connecting from a different pc to the pc hosting the mysql
server through telnet?
2. connecting from the same pc hosting the mysql server and specifying the
host when connecting?
3. running
27 matches
Mail list logo
