On 11/5/05, Ezra Taylor wrote:
To Mysql users:
Just to remind you all, Oracle is a
business that expects to make money. As you all know, Mysql is a
threat to the fat cats such as Oracle,DB2,MSSql and others. If you
think Oracle is going to play fair with us
I
Rhino wrote:
I can't test this in MySQL- I'm using an older version of MySQL that doesn't
support subqueries - but it works in DB2 and it should do the trick for
getting the current weight of each VBS_id value:
select VBS_id, date, weight
from VBS_table x
where date =
(select max(date) from
-Original Message-
From: Fabricio Mota [mailto:[EMAIL PROTECTED]
Sent: zaterdag 5 november 2005 3:56
To: Ezra Taylor
Cc: mysql@lists.mysql.com
Subject: RES: Heikki: What will become of InnoDb once MySQL license
runs out
To Mysql users: Just to remind you all, Oracle is a business
On 11/5/05, Mark wrote:
Is there anyone who can shed some light on this without the anti-Orcacle
hysteronics?
No.
Those who know have to go through proper channels. Oracle is a public
company and the disclosure of its future actions has to go through
proper channels or it will incur the wrath
In article [EMAIL PROTECTED],
Barbara Deaton [EMAIL PROTECTED] writes:
All,
I need help with using load data to load a text file that is created by
another application.
I have a text file that contains 2 columns, date and smallint and 2 rows:
d,e
2005-12-31,
,2
In the above example
I have the following tables:
languages
language_id int,
language_title varchar(80)
objects
object_id int
object_language_id int
object_title varchar(100)
I want to select ALL available languages, and match the translated object
(if it is exists) for a specific object_id. If it does not exists
2005/11/5, Guy Brom [EMAIL PROTECTED]:
I have the following tables:
languages
language_id int,
language_title varchar(80)
objects
object_id int
object_language_id int
object_title varchar(100)
I want to select ALL available languages, and match the translated object
(if it is
I'm glad the explanation helped. I figured that the solution alone wouldn't
be very useful if it wasn't explained since it is not obvious to most people
how correlated queries work :-)
I really wasn't trying to center you out with my rant about MySQL version.
It's been a long-running frustration
Have a look at the reply I just wrote for Gobi, entitled Re: Help with an
SQL query. You'll find an explanation there for how to use temporary tables
and joins instead of subqueries in MySQL versions that don't support
subqueries.
Rhino
- Original Message -
From: Guy Brom [EMAIL
Bruce Martin wrote:
When I log in as root using:
mysql -u root -p mysql
I get the mysql prompt:
mysql
I then issue this command or statement:
mysqlGRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
'some_password' WITH GRANT OPTION;
First, your hostname is blank. That won't work.
Mark wrote:
-Original Message-
From: Bruce Martin [mailto:[EMAIL PROTECTED]
Sent: zaterdag 5 november 2005 3:58
To: mysql@lists.mysql.com
Subject: Add New User
When I log in as root using: mysql -u root -p mysql I get the
mysql prompt:
mysql
I then issue this command or statement:
11 matches
Mail list logo