h... All this is what might happen...that true...But yet I do not
see anyone willing to put up anything to support mysql... you don't like
it... put up a billion dollars an take control or shut the heck up!
Doug
Ryan Chan wrote:
On Sun, Dec 13, 2009 at 11:48 AM, Michael
Just wondering with MySQL 5.0, if using the spatial extensions provides any
real performance advantage in the following scenario:
Table with ~1 million rows:
CREATE TABLE `places` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`latitude` decimal(10,8) NOT NULL,
`longitude`
Doug:
I do not
see anyone willing to put up anything to support mysql... you
don't like
it... put up a billion dollars an take control or shut the heck up!
Assuming MySQL as it stands today is 100% open source,
I think an easier path is to create a new project from
the currently existing
Hi;
mysql insert into tem126072414516 (ProdID, Quantity) values (2, 2);
ERROR 1062 (23000): Duplicate entry '2' for key 2
mysql select * from tem126072385457;
Empty set (0.00 sec)
mysql describe tem126072385457;
+--+-+--+-+-++
| Field|
Victor Subervi wrote:
Hi;
mysql insert into *tem126072414516* (ProdID, Quantity) values (2, 2);
mysql select * from *tem126072385457*;
t
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I am astonished that this attitude could exist in the open source
world. MySQL has *always* been open source, since the early days when
it was a handful of us lurking on Monty's mailing list waiting
breathlessly for the next feature to be released so we could release
the projects we had built
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor tib...@tibyke.hu wrote:
Victor Subervi wrote:
Hi;
mysql insert into *tem126072414516* (ProdID, Quantity) values (2, 2);
mysql select * from *tem126072385457*;
mysql insert into *tem126072414516* (ProdID, Quantity) values (2, 2);
ERROR 1064
I was wondering if someone could lend a hand with the following query. I have
table.
SEARCHES
|ID |trans_no|comp_id|result
13 | 455| 675| o
15 | 302| 675| o
16 | 455| 675| o
12 | 225| 629| y
SELECT count(*) FROM SEARCHES WHERE comp_id=675 AND result='o'
I'm trying to get started with running mysqld but I can't set up the
data directory. Any hints? Thanks in advance. Details follow:
$ uname -a
Linux hammer.csail.mit.edu 2.6.27.35-170.2.94.fc10.x86_64 #1 SMP Thu
Oct 1 14:41:38 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
$ mysql/bin/mysqld --version
Depending on whether you just need to count or the transaction numbers, one of
the following three should get you where you want/need to be:
To identify the count for comp_id = 675:
select count(distinct trans_no) from trans where comp_id = 675 and result = 'o';
To identify the transactions:
hi friend
Am working in php and mysql, i want to write the join query from the 4
table,
Am very confused how to do ,
Here is the atachment ,
Please tell me , How to to
Master table is
CREATE TABLE `med_patient` (
`id` bigint(20) NOT NULL auto_increment,
`cInitial` varchar(5) default
On December 13, 2009 01:36:41 pm Richard Reina wrote:
I was wondering if someone could lend a hand with the following query. I
have table.
SEARCHES
|ID |trans_no|comp_id|result
13 | 455| 675| o
15 | 302| 675| o
16 | 455| 675| o
12 | 225| 629|
Michael Dykman mdyk...@gmail.com :
Are we such sheep that we leave this in the hands of the highest
bidder?
I dont understand: Dont'you like the idea of forking?
Why exactly?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
SELECT count(distinct trans_no) from SEARCHES WHERE comp_id=675 and
result='o';
- Original Message -
From: Richard Reina rich...@rushlogistics.com
To: mysql@lists.mysql.com
Cc: rich...@rushlogistics.com
Sent: Sunday, December 13, 2009 11:36 AM
Subject: Query help
I was wondering if
At 01:17 PM 12/13/2009, bharani kumar wrote:
hi friend
Am working in php and mysql, i want to write the join query from the 4
table,
Am very confused how to do ,
I'm not sure why you would want to join all of the tables together and then
export them. It will mean you will have rows repeated
Hi,
How would one go about doing this:
- I have 3 tables:
- A relationship table(REL), then TABLE1 and TABLE2:
REL TABLE has fields:
. ID
. TYPE - type of event
. ID_EVENT - id of event, but this id will either point to TABLE1 or TABLE2,
depending on the content of the field TYPE
Is it
Hi All,I really don't know how to elaborate this problem
because it is quite strange-I have deleted .frm files but
not by issuing Drop table command I deleted the folder from backend at folder
level as there was some problem.Is there any way I can
delete this definition from innodb datafile?Thanks
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
capital gains http://en.wikipedia.org/wiki/Capital_gain in 2008 (16.8
million € total income), making the top 10 of highest earners in Finland
that year.
[wikipedia]
Cheers
Claudio Nanni
Michael Widenius wrote:
Subject:
Claudio Nanni wrote:
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
(...)
I fail to see the relevance of this quote for this thread...
Regards,
Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
Cheers
Claudio
Jigal van Hemert wrote:
Claudio Nanni wrote:
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
(...)
I fail to see the relevance of this quote for this thread...
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
capital gains http://en.wikipedia.org/wiki/Capital_gain in
So, he got paid for his contribution to the world.
Is that so bad? MySQL has allowed people to make
much more money than that. It is a small amount of
the
Totally agree.
But in the moment you sell something you lose control on it, and one of
the more or less foreseeable risks is exactly what is happening,
and worst nightmare become truth.
Cheers
Claudio
Neil Aggarwal wrote:
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
22 matches
Mail list logo