Look at db.use_result() and db.store_result() here :
http://www.birgerblixt.com/doc/packages/python-mysql/MySQLdb-2.html#ss2.
2
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Smelly Socks [mailto:[E
You guys are the best!!!.
I have spent hours trying to solve this problema and Peter´s answer was the
solution. I´ll write a post with the whole explanation of the problem.
Thanks and best regards,
Alvaro.
PD: Mathias, I´ll send the tables with data and the solution. Thanks!.
- Orig
Hi!
I am porting a function library app I wrote in PHP to Python. At work they
only use Python. I've researched how to connect to a MySql database using
Python, and how to retrieve rows. However, I am wondering how to do the
following:
I can do this in Python => $da=MYSQL_QUERY("select * fro
I think the second can be better (more different values). But it
contains almost the same data than the table.
Try :
explain Select machine,count(*) from syslog WHERE date1 > (NOW()
- INTERVAL 24
hour) AND message LIKE 'sshd%' GROUP BY machine;
But an index with(date1, message, machine)
Alvaro,
I suspect the error message refers to the subquery missing a
non-aggregate column on which to GROUP BY.
I may misunderstand your query--I'm not clear why you can't just write
...
SELECT
f.PK_partic,
f.FK_IS,
f.OB_familia,
Sum( IF( insumo_or = "Animal1", cantidad_or, 0 ))
Hello,
I have the following table setup:
IDhostnamefacilityprioritydatemessage
ID is auto incrementing.
This is used to store all of the syslog messages, currently there are
over 7 million:
The following query takes forever:
Select machine,count(*) from syslog WHERE da
Hi,
What do you obtain with :
Select FK_partic,
Sum(IF(insumo_or = "Animal1", cantidad_or, 0) ) AS "Animal1",
Sum(IF (insumo_or = "Animal2", cantidad_or, 0) ) AS "Animal2",
Sum(IF (insumo_or = "Animal3", cantidad_or, 0) ) AS "Animal3",
Sum(IF (insumo_or = "Animal4", cantidad_or, 0) ) AS "Animal4
Hi guys:
I am quite new in SQL and I need to build a crosstab based in two tables using
Mysql and PHP, but it is becoming quite dificult.
I've got the next query, but it keeps giving the next error:
"#1241 - Operand should contain 1 column(s)"
/*GENERAL EXPLANATION OF THE QUERY
I work in
Hi,
I hope that this link will help
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Kenneth Wagner [mailto:[EMAIL PROTECTED]
Sent: mardi 26
Hi all,
I have removed mysql 4_0_20d and installed 4.1.
My puzzle is this:
1. I have prior databases in 4.0 (intact data directory with InnoDB files
*.idb, etc.) data directory with sub directories.
2. I want to bring in some of the databases to the new 4.1 version.
The 4.0 databases
Hi,
If my englsih is so bad, i'll try to explain and stop this thread now.
I'm not teaching, i'm answering questions. If someone wants to read
docs, he (she) doesn't ask a question on the list. So if i answer, i
answer the question, just the question.
You want to know my level of knowledgne, 10 ye
thanks, I'll give that a try tomorrow. :o)
Jeffrey S. McKeon
Manager of Information Technology
Telaurus Communications LLC
[EMAIL PROTECTED]
+1 (973) 889-8990 ex 209
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, April 2
"mathias fatene" <[EMAIL PROTECTED]> wrote on 04/25/2005 04:24:42 PM:
> Hi,
> Im sorry to disappoint you but this is an anti-performance solution.
> Use joins rathers than subqueries, and don't use joins if you can (all
> data in the mother table).
>
> Imagine that table2 has 30.000.000 records,
Title: Message
Jeff,
3.23.
no control over this right now or i'd upgrade, believe me!
Yep, I maintain websites with the same
problem. Shawn Green just posted a solution that doesn't need inline
user variable assignment.
PB
-
Jeff McKeon wrote:
3.23.
no control ove
3.23.
no control over this right now or i'd upgrade, believe me!
jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:43 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Query qu
Title: Message
That's real syntax for inline assignment of a column value to a user
variable. What MySQL version are you using?
PB
Jeff McKeon wrote:
Peter,
I'm unfamiliar with the "@d := " section
you describe. Is this psudo code or real syntax?
thanks,
Jeff
"Jeff McKeon" <[EMAIL PROTECTED]> wrote on 04/25/2005 04:08:29 PM:
> Thanks all but I don't have a mysql version high enough for subqueries.
>
> Thanks,
>
> Jeff
>
> > -Original Message-
> > From: Peter Brawley [mailto:[EMAIL PROTECTED]
> > Sent: Monday, April 25, 2005 4:01 PM
> > To:
Title: Message
Mathias,
>Im sorry to disappoint you but this
is an anti-performance solution.
>Use joins rathers than subqueries,
and don't use joins if you can (all data in the mother table).
This 2-query solution uses neither a join
nor a subquery. What do you mean?
PB
-
mathias fa
Peter,
I'm unfamiliar with the "@d := " section you describe. Is this psudo
code or real syntax?
thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:17 PM
To: Jeff McKeon
Cc: mysql@
Hi,
Im sorry to disappoint you but this is an anti-performance solution.
Use joins rathers than subqueries, and don't use joins if you can (all
data in the mother table).
Imagine that table2 has 30.000.000 records, and not good indexes. you
can wait for your answer a long time.
Best Regards
---
Jeff,
Then do it with 2 queries,
SELECT @d := MAX( datestamp )
FROM table2
WHERE parentID = X;
SELECT *
FROM table2
WHERE parentID = X AND [EMAIL PROTECTED];
PB
-
Jeff McKeon wrote:
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
---
Jeff,
Then do it with 2 queries,
SELECT @d := MAX( datestamp )
FROM table2
WHERE parentID = X;
SELECT *
FROM table2
WHERE parentID = X AND [EMAIL PROTECTED];
PB
-
Jeff McKeon wrote:
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
---
Here we are Shawn,
With empty tables :
+++---+--+---+--+---
--+--+--+-+
| id | select_type| table | type | possible_keys | key |
key_len | ref | rows | Extra |
+++---+--+
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 25, 2005 4:01 PM
> To: Jeff McKeon
> Cc: mysql@lists.mysql.com
> Subject: Re: Query question
>
>
> Jeff,
>
>
Hi,
Why my answer doesn't answer his question. Did you heared about his
comment. Let him do it.
If you're confused, i can explain more one-to-many relashionships.
If you think about joins and want absolutely add them, this is the error
generating performance problems asked along all RDMBS, especi
Jeff,
Something like ...
SELECT *
FROM table2 AS a
WHERE datestamp = (
SELECT MAX( b.datestamp )
FROM table2 AS b
WHERE a.parentID = b.parentID
);
PB
-
Jeff McKeon wrote:
I have a table that contains records that link back to a main talbe in a
many to one configuration linked by table1.id =
"mathias fatene" <[EMAIL PROTECTED]> wrote on 04/25/2005 03:19:33 PM:
> Hi,
> You can do something like that :
>
>
> mysql> select * from son;
> +--+
> | a|
> +--+
> |1 |
> |2 |
> |3 |
> +--+
> 3 rows in set (0.02 sec)
> mysql> select * from mother;
> +--+--+
Hi,
You can do something like that :
mysql> select * from son;
+--+
| a|
+--+
|1 |
|2 |
|3 |
+--+
3 rows in set (0.02 sec)
mysql> select * from mother;
+--+--+
| a| b|
+--+--+
|1 | a|
|1 | b|
|2 | a|
|2 | c|
|
"Jeff McKeon" <[EMAIL PROTECTED]> wrote on 04/25/2005 03:00:55 PM:
> I have a table that contains records that link back to a main talbe in a
> many to one configuration linked by table1.id = table2.parentid
>
> Table1 (one)
> Table2 (many)
>
> I want to pull the latest records from table2 for e
I have a table that contains records that link back to a main talbe in a
many to one configuration linked by table1.id = table2.parentid
Table1 (one)
Table2 (many)
I want to pull the latest records from table2 for each record in table1
where certain criteria applie.
So, if record 100 in table1 l
Frank Bax <[EMAIL PROTECTED]> wrote on 04/25/2005 02:27:58 PM:
> At 02:07 PM 4/25/05, Scott Gifford wrote:
>
> >[EMAIL PROTECTED] writes:
> >
> > > Frank Bax <[EMAIL PROTECTED]> wrote on 04/25/2005 11:47:12 AM:
> > >> Or simply use "split", default is 1000 lines, but can be changed
via
> > >> co
At 02:07 PM 4/25/05, Scott Gifford wrote:
[EMAIL PROTECTED] writes:
> Frank Bax <[EMAIL PROTECTED]> wrote on 04/25/2005 11:47:12 AM:
>> Or simply use "split", default is 1000 lines, but can be changed via
>> command line.
That's a start, but the files each need to be a valid SQL statement,
so that'
[EMAIL PROTECTED] writes:
> Frank Bax <[EMAIL PROTECTED]> wrote on 04/25/2005 11:47:12 AM:
>
>> At 10:44 AM 4/25/05, Art.M (Wikki) wrote:
>> >I have a large .sql file to upload which is about 9 mb and I was
>> >wondering if anyone knew of a program that could break it up into
>> >chunks of 2 mb or
On Mon, 25 Apr 2005, mathias fatene wrote:
Sorry,
Alter table toto ENGINE=innodb.
You don't must, you can. You can also have differents storage ENGINES in
the same mysql database.
With innodb, you will earn ROW level locking.
Best Regards
Mathias FATENE
Thanks, Mathias!
Carl
Ca
Sorry,
Alter table toto ENGINE=innodb.
You don't must, you can. You can also have differents storage ENGINES in
the same mysql database.
With innodb, you will earn ROW level locking.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
Yes, but your myIsam Tables stay myisam ones.
After restarting, you must change them to innodb by :
Alter table toto storage=innodb.
For new tables, they will have innodb storage.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-
We are running MySQL on Red Hat Enterprise Linux 3, using the Red Hat-
supplied RPM file mysql-server-3.23.58-2.3. Our current MySQL
configuration has MyISAM as the default database file type. I would like
to change this such that InnoDB is the default. My understanding of the
documentation s
Frank Bax <[EMAIL PROTECTED]> wrote on 04/25/2005 11:47:12 AM:
> At 10:44 AM 4/25/05, Art.M (Wikki) wrote:
> >I have a large .sql file to upload which is about 9 mb and I was
> >wondering if anyone knew of a program that could break it up into
> >chunks of 2 mb or under? So I can upload it to a sh
At 10:44 AM 4/25/05, Art.M (Wikki) wrote:
I have a large .sql file to upload which is about 9 mb and I was
wondering if anyone knew of a program that could break it up into
chunks of 2 mb or under? So I can upload it to a shared web server.
You can't upload a 9M file to webserver? But you can upl
Hi Mikel,
Show create table shows a line CONSTRAINT ... FORIEGN KEY ...
you can add a grep on this line. But this will be difficult. You can construct
another desc2xml using just "show create table" to have it easier.
Mathias
Selon Mikel - <[EMAIL PROTECTED]>:
> Thanx Mathias for your quick and
Hi,
do you continue to have it even if you EXIT your Mysql Administrator ?
Mathias
Selon [EMAIL PROTECTED]:
> Does anyone know why this message keeps repeating:
> 050425 11:31:40 229 Query SHOW STATUS
> 229 Query SHOW INNODB STATUS
> 050425 11:31:41 229 Qu
Does anyone know why this message keeps repeating:
050425 11:31:40 229 Query SHOW STATUS
229 Query SHOW INNODB STATUS
050425 11:31:41 229 Query SHOW STATUS
229 Query SHOW INNODB STATUS
050425 11:31:42 229 Query SHOW S
I am using MySQL 4.0.17 on QNX 6.2.1b.
I have noticed this in the last couple of days. There were two MySQL
clients running: one since 1:30 that morning; one at 1:30 the previous
morning. These are "reset master" commands we issue from cron to clean up
the transaction logs.
This morning I tried
On Fri, 22 Apr 2005 22:44:44 +0300
Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> Make a bug or feature report at http://bugs.mysql.com.
Already did - 10098 - it was recently closed, guess it was already
fixed in 5.0.5.
Josh
--
MySQL General Mailing List
For list archives: http:
Hello,
I have a large .sql file to upload which is about 9 mb and I was
wondering if anyone knew of a program that could break it up into
chunks of 2 mb or under? So I can upload it to a shared web server.
Thanks ahead for your response.
Wikki
--
MySQL General Mailing List
For list archives: ht
Try this
If something is numeric
SELECT * FROM table1, table2, table3, table4, table5, table6
WHERE table1.something = table2.something
AND
table1.something = table3.something
AND
table1.something = table4.something
AND
table1.something = table5.something
Thanx Mathias for your quick and effective response, I see that your program
almost display the format that I need, the thing is that I need the foreign
key information too, Does MySQL have a statement besides "show create table"
to display this information?Thanks again for your suggestions
"Ed Reed" <[EMAIL PROTECTED]> wrote on 04/25/2005 02:33:23 AM:
> Does anyone else have any ideas about this topic?
>
> Thanks
>
> >>>Ed Reed <[EMAIL PROTECTED]> 04/23/05 1:29 pm >>>
> Thanks for the reply,
>
> I realize that user variables disappear when the connection closes
> but I don't un
Thanks for the info. I am using 4.0.24, so maybe this is the problem.
I was able to get around this by first checking if the mac field was
empty, but I will look into upgrading mysql to a more current version.
thanks
- Original Message -
From: [EMAIL PROTECTED]
Date: Monday, April 25,
Hi,
this is an example where what you describe doesn't happen (v 4.1 and 5.0) :
mysql> create table ports(mac varchar(17),port_index varchar(3));
Query OK, 0 rows affected (0.10 sec)
mysql> insert into ports values('00:04:FB:23:5A:44','120'),(NULL,'120');
Query OK, 2 rows affected (0.08 sec)
Recor
That is very odd behavior and shouldn't be happening. I ran a quick
test on my machine and MySQL does not exhibit that behavior. You may
try running and repair on your table. Perhaps something is out of
whack. What version of MySQL are you running?
On Apr 22, 2005, at 6:08 PM, [EMAIL PROTECTED]
[snip]
Don't be so hasty to criticise. I took the original question to mean
"While I have an existing spreadsheet open in EXCEL, can I cause a
selected
row in a MySQL table to be updated?". This is quite a different
question
than "How can I convert one sheet from an EXCEL file into a new MySQL
Hello.
Have you ran mysql_init_db on a new data directory?
> store the tables that store grants and such, but how to we get those
> created for the new instance. We've been all over the MySQL.com docs
It is unclear for me. You may specify the datadir for every new
instance. See:
ht
Hello.
Make a bug or feature report at http://bugs.mysql.com.
Josh Trutwin <[EMAIL PROTECTED]> wrote:
> Would it be possible to add:
>
> ENGINE=MyISAM
>
> To all the CREATE TABLE statements in the mysql_fix_privilege_tables
> script? The server (tested with 5.0.3 and 5.0.4) crashe
Hello.
I don't know if it is a good idea, but at least check that you have the
same version of MySQL on Linux. On Windows, lower_case_table_names is
set to 1 by default. See:
http://dev.mysql.com/doc/mysql/en/moving.html
Marcin Lewandowski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've
Do that ,
SELECT field_name FROM meta WHERE id ='13'
Union
SELECT field_name FROM meta WHERE id ='11'
Union
SELECT field_name FROM meta WHERE id ='7'
Union
SELECT field_name FROM meta WHERE id ='8'
Union
SELECT field_name FROM meta WHERE id ='9'
Union
SELECT field_name FROM meta WHERE id ='
Read 7xx
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: mathias fatene [mailto:[EMAIL PROTECTED]
Sent: lundi 25 avril 2005 10:18
To: 'Anirban Karmakar'; 'mysql@lists.mysql.com'
Subject: RE: libCstd
Do you have /cnem/server/bin/mysqld file ? Is it exec (6xx)?
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: Anirban Karmakar [mailto:[EMAIL PROTECTED]
Sent: lundi 25 avril 2005 09:12
To: mysql@lis
Hi Adrian,
you can do
SELECT field_name FROM meta WHERE id IN
('13','11','7','8','9','10','12')
ORDER BY FIELD(id,'13','11','7','8','9','10','12')
/Johan
Adrian wrote:
Hi everyone,
Here is my issue:
I have this Query : SELECT field_name FROM meta WHERE id IN
Hi everyone,
Here is my issue:
I have this Query : SELECT field_name FROM meta WHERE id IN
('13','11','7','8','9','10','12')
I want the rows to be display in the same order as the in list of
ids.Any ideas? Should I use order by? Whit witch optio
Http://www.gunmuse.com
Ok I use a storelocator.
First if you have 8000 + records it becomes an issue. BUT Lat and long is
in minutes and minutes can be used to estimate miles. By Breaking down the
lat and long, Breaking down the Zip to a two digit prefix 88254 becomes 88
for indexing (Because
Hi,
Select * from table1 T1, table2 T2, table3 T3, table4 T4, table5 T5,
table6 T6
Where T1.col=T2.col
and T2.col=T3.col
and T3.col=T4.col
and T4.col=T5.col
and T5.col=T6.col
and T1.col=T6.col
[and col='val']
Doesn't this work ? Have you an example ?
Best Regards
Mathia
Hi,
I installed mysql-standard-4.0.24-sun-solaris2.8-sparc on a Solaris 5.8 macine.
However while i'm running the mysql_install_db script i'm getting the error
ld.so.1: ./bin/mysqld: fatal: libCstd.so.1: open failed: No such file
or directory
Killed
Installation of grant tables failed!
I've my .
Loo at :
mysql> show master status;
+---+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---+--+--+--+
| binlog.03 | 79 | | |
+--
64 matches
Mail list logo
