Phil schrieb:
In my never ending quest for speed ups I've been trying the following..
I pull in xml data for roughly (at the peak) 1.8M hosts from the BOINC
[EMAIL PROTECTED] hosts files.
Each host will have a unique id, a score, createdate and possibly a country
& team (as well as a number of
On Thu, 06 Mar 2008 08:05:06 -0800, puntapari wrote:
> And returning a list of numbers? It can be and how?
A bit tangential, but this calculation could be done recursively with
ruby. Are you tied to SQL for this?
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql
Hi,
I'm writing a custom engine to read data written in a legacy format as it was a
regular mysql table.
To read data properly I need information from some myisam tables in the same db.
How can I query those myisam tables from my custom engine? I don't like the
idea of connecting to mysql... I
In my never ending quest for speed ups I've been trying the following..
I pull in xml data for roughly (at the peak) 1.8M hosts from the BOINC
[EMAIL PROTECTED] hosts files.
Each host will have a unique id, a score, createdate and possibly a country
& team (as well as a number of other characteri
Hi, im having a lot of trouble with one query, i hope someone could give me
a hand with this, i would be really grateful
these are the tables:
TABLE friends
id_usr INT
id_friend INT
with INDEX on (id_usr,id_friend)
TABLE status
id_usr INT
lastConnection
(other irrelevant info)
with INDEX on
>Description:
It is my first install of MySQL 64 bit. The platform is Mac G4 under
OS 10.4.10.
My guide has been the included text file, INSTALL-BINARY whose
instructions are referred to below.
The instructions call for adding a user via ADDUSER, a FreeBSD
command that nevertheless is no
Hello all,
I have a quite silly question I guess but it's been bugging me up recently.
A client has just acquired a SAN for his servers.
Between these servers he also has 2 mysql ones.
What would happen if I were to define a single shared disk on the SAN
and I place both Mysqls to work in the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.1.6, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.
Version 5.1.6 is suitable for use with any MySQL version including
MySQL-4.1, MySQL-5.0, My
On 3/6/08 12:09 PM, "Tim McDaniel" <[EMAIL PROTECTED]> wrote:
> On Thu, 6 Mar 2008, Dan Rogart <[EMAIL PROTECTED]> wrote:
>> On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
>>> I got 4 tables:
>>>
>>> Table A
>>> | ID | Description1 |
>>>
>>> Table B
>>> | ID | De
I am working on a project where I have have several processes writing
records to an InnoDB table. There are two separate queries doing the
inserts. In maybe one out of a couple 100 inserts, I get an integrity
constraint violation error, complaining about a duplicate entry for key 1.
The first
If you are calling this stored procedure from PHP or Java, then you can fetch
each number one at a time from the result set.
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2008 12:43 PM
To: Paul DuBois; puntapari; mysql@lists.mysql.com
Subject
I have a more masochistic way to do this without a table
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`sp_NumberList` $$
CREATE PROCEDURE `test`.`sp_NumberList` (LastNumber INT)
BEGIN
DECLARE j INT;
DECLARE SQLPiece TEXT;
DECLARE SQLStmt TEXT;
SET j = 0;
SET SQLStmt = 'SELECT 0
At 9:10 AM -0800 3/6/08, puntapari wrote:
Somethin like this?
DELIMITER $$
DROP PROCEDURE IF EXISTS `cantidad` $$
CREATE PROCEDURE `cantidad` (in n int )
for i in 0..n loop
insert into temp values(i);
end loop;
select * from temp;
END $$
DELIMITER ;
Not quite. This will still re
Somethin like this?
DELIMITER $$
DROP PROCEDURE IF EXISTS `cantidad` $$
CREATE PROCEDURE `cantidad` (in n int )
for i in 0..n loop
insert into temp values(i);
end loop;
select * from temp;
END $$
DELIMITER ;
Thanks
--
View this message in context:
http://www.nabble.com/function-p
On Thu, 6 Mar 2008, Dan Rogart <[EMAIL PROTECTED]> wrote:
On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID | Description3 |
Table D
| ID | Description4
At 8:05 AM -0800 3/6/08, puntapari wrote:
Hi!
And returning a list of numbers? It can be and how?
You cannot return a list. You could generate a result
set in a procedure, but it's returned to the client, not
the caller.
That's why I suggested writing the numbers into a table.
Then you can s
Hi!
And returning a list of numbers? It can be and how?
Thanks
--
View this message in context:
http://www.nabble.com/function-procedure-error%21-tp15875760p15876992.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http
At 7:48 AM -0800 3/6/08, puntapari wrote:
Hi everybody!
I have a little problem with one function. What i want is to make a function
which returns me numbers from 0 to the number that receives the function.
That can't work. A function returns a single value.
Perhaps you can write a procedure
Hi everybody!
I have a little problem with one function. What i want is to make a function
which returns me numbers from 0 to the number that receives the function.
Example: if the function receives the number 4, it will return 0,1,2,3 and
4.
numbers
0
1
2
3
At 4:20 PM +0100 3/6/08, Andre Hübner wrote:
Hi List,
user wants to do:
SELECT COUNT(*) FROM mysql.time_zone_name;
problem ist that this table in mysql is empty. I
dont know how to fill with data. I tried on
testmachine with mysql_install_db but it leaves
empty.
Where to get sql-data to fi
On Thu, Mar 6, 2008 at 10:20 AM, Andre Hübner <[EMAIL PROTECTED]> wrote:
> Hi List,
>
> user wants to do:
>
> SELECT COUNT(*) FROM mysql.time_zone_name;
>
> problem ist that this table in mysql is empty. I dont know how to fill with
> data. I tried on testmachine with mysql_install_db but it le
Hi List,
user wants to do:
SELECT COUNT(*) FROM mysql.time_zone_name;
problem ist that this table in mysql is empty. I dont know how to fill with
data. I tried on testmachine with mysql_install_db but it leaves empty.
Where to get sql-data to fill these tables in mysql-db?
Thank you
Andre
Thanks guys!! << gone to chase some of Dan's coffee >>
Brain gone.. and too many remnants of FoxPro SQL with "INNER JOINS"
Rog
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: 06 March 2008 13:53
To: Dan Rogart; roger.maynard; mysql list
Subject: Re: Im being dumb!
On 06.03.2008 15:15 CE(S)T, Paul DuBois wrote:
Here's some advice from Alexander Barkov:
You might be able to use a particular collation to achieve what you want.
For example, latin1_general_ci.
You can take a look at its collation chart here:
http://www.collation-charts.org/mysql60/mysql604.lat
As soon as I posted I found the example.. ;)
the answer was to use a UNION
http://www.w3schools.com/sql/sql_union.asp
SELECT DATA1STAMP as DATASTAMP , DATA1DATA as DATA from DATATABLE
UNION
SELECT DATA2STAMP as DATASTAMP , DATA2DATA as DATA from DATATABLE;
This makes a union and puts the data
Good Morning Lucas-
could you define the formatting specifics of DATA and DATASTAMP result-type?
Thank You
Martin
- Original Message -
Wrom: REXCAXZOWCONEUQZAAFXISHJEX
To:
Sent: Thursday, March 06, 2008 8:43 AM
Subject: Formatting in same columns when selecting from two tables.
> I have
Ack, listen to Nanni not me. Join order doesn't matter, now that I tested
some more :).
Off to drink more coffee,
Dan
On 3/6/08 8:45 AM, "Dan Rogart" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
>
>> I got 4 tables:
>>
>> Table A
>> |
[snip]
-Original Message-
From: roger.maynard [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2008 7:33 AM
To: mysql@lists.mysql.com
Subject: Im being dumb!
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID | Descript
Hi Roger,
That is ok, just try to substitute 'INNER' with 'LEFT'
Aloha!
Claudio Nanni
-Messaggio originale-
Da: roger.maynard [mailto:[EMAIL PROTECTED]
Inviato: giovedì 6 marzo 2008 14.33
A: mysql@lists.mysql.com
Oggetto: Im being dumb!
I got 4 tables:
Table A
| ID | Description
Hi,
On 3/6/08 8:33 AM, "roger.maynard" <[EMAIL PROTECTED]> wrote:
> I got 4 tables:
>
> Table A
> | ID | Description1 |
>
> Table B
> | ID | Description2 |
>
> Table C
> | ID | Description3 |
>
> Table D
> | ID | Description4 |
>
> ALL Ids ARE COMMON
I have a table in my database with 4 fields, Because it is already
implemented in the application I am modifying I cannot change the table.
Here is what I have
DATA1STAMP type DATE , DATA1DATA type INTEGER, DATA2STAMP type DATE,
DATA2DATA type INTEGER in my DATATABLE.
I now need to select this
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID | Description3 |
Table D
| ID | Description4 |
ALL Ids ARE COMMON Values and NONE are MISSING
How can I create
| ID | Description 1 | Description 2 | Description 3
Hi,
[EMAIL PROTECTED] schrieb:
Hi,
I have 2 tables as follows:
table 1 contains code,order_qty
table 2 contains code,stock_qty
table 1:
code1, 10
code2, 2
code3, 5
table 2:
code1, 3
code3, 5
code1, 4
code3, 2
I need to see the following result:
code | order_qty| stock_qty
code1 | 10
33 matches
Mail list logo
