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
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 VBS
> -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 b
> -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
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 wra
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 abo
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
>
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 PRO
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:
mysql>GRANT 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:
mys
12 matches
Mail list logo
