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
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
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
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]
]
|
| cc:
|
| Subject: DOES MYSQL HAS CONCEPT OF SYNONYM
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 fail, the
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
# [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 while delete
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
delete the tno in
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
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
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
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.
Jeremy
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 data
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
-
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-increment/identity field to your table
schema and when
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
.
-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 that I have them listed in my insert statement. So my
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
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
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
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 price FROM mytable WHERE price = theprice DESC LIMIT 1
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.
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
24 matches
Mail list logo