2005/9/18, Jasper Bryant-Greene [EMAIL PROTECTED]:
Alvaro Cobo wrote:
Thanks Pooly and Peter:
The problem is that in the same php page I would like to choose either the
calculation from an especific year or the calculation from the whole table
using URL.
The same page can easily
2005/9/17, Miguel Cardenas [EMAIL PROTECTED]:
In the last episode (Sep 17), Miguel Cardenas said:
I have a technical doubt, very simple but not mentioned in the manual...
What happens if I call mysql_free_result() after performing a query
but without doing mysql_fetch_row() ???
Hi,
while ( my1.fetch ) {
my2.query + my2.store
if ( my2.fetch ) {
report = my1 + my2 results
} else {
report = my1
}
my2.FreeResult --- free for every my2.query inside loop
}
my1.FreeResult --- free for unique my1.query
One My2.store == One My2.free.
you're
Hi,
Database is MySQL 4.1.5-gamma, running on Linux.
All charset variables are set to default 'latin1', except
'character_set_system', which is utf8.
A database was created and running in this environment, but the data it
gets (from php) were in utf8. Mysqldump is used without any options to
hi
how can i uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz i would
like to install mysql-4.1.14.tar.gz
thank you very much.
rgds,
Joeffrey
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
http://dev.mysql.com/doc/mysql/en/mysql-free-result.html
it does not says : you have to retrieve all rows before freing it. So
you should be able to free the result. Otherwise it's a bug or
undocumented behaviour.
But why don't you use the Count(*) solution ?? that's exactly what you
need
If you can catch hold of a windows box then there is
tool called SQLyog that has a great migration tool.
I was able to import a clients MDB database with all
the FKs directly from Access to MySQL. You dont need
to go thru Access - Script - MySQL.
You can download it from http://www.webyog.com
--
___
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.
Powered by Outblaze
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Josh Chamas [EMAIL PROTECTED] writes
Dyego Souza Dantas Leal wrote:
I want to use INTEL SHARED MySQL 4.0.25 - Pro with innodb tables on
PRODUCTION SERVER DELL 2600
The Linux Kernel is 2.6.12 and the hardware is DUAL XEON 2.4 HT iwth 4
GB of RAM
(i'm using raw partitions feature on innodb
Hello
I've just experienced troubles with mysql_free_result() but don't know what is
wrong... one of my programs has 2 simultaneous connections to MySQL and
crashed when doing the mysql_free_result(), I thought it was 'cos the way I
was making the program, but now I have the problem with
Alvaro,
The problem is that in the same php page I would like to choose
either the
calculation from an especific year or the calculation from the
whole table
using URL.
That needn't raise a problem, especially in PHP. If the user chooses a
year, have the page construct the appropriate WHERE
Scott Gifford wrote:
Ken Gieselman [EMAIL PROTECTED] writes:
[...]
So, here's my question: How can I find out how many rows are being
returned by a query, without using mysql_stmt_store_result() to
buffer all the rows back to the client?
One straightforward way is to replace the SELECT
Hello,
I have two tables - one containing messages, and another containing links
between messages and other messages in a tree structure (much like a threaded
mailing list archiving thing). A single message can have multiple parents
though, meaning the links table can have several entries for a
My question question from MySQL 4.0.22: is it okay that a null interger tests as
equal to any value. I am not sure the table structure matters but in case it is
I included it.
I did not expect that null was not not-equal to 1. Cursory testing seems to
indicate that a null integer field is not
Richard
I would like to display all messages which match both 5 and 7 in terms
of the parent_id, meaning messages 10 and 13 would be displayed.
SELECT f1.child
FROM foo AS f1
INNER JOIN foo AS f2 USING(child)
WHERE f1.parent=5 AND f2.parent=7;
PB
-
Hobbs, Richard wrote:
Hello,
I have
2005/9/18, Miguel Cardenas [EMAIL PROTECTED]:
http://dev.mysql.com/doc/mysql/en/mysql-free-result.html
it does not says : you have to retrieve all rows before freing it. So
you should be able to free the result. Otherwise it's a bug or
undocumented behaviour.
But why don't you use the
Greetings
What might be causing the 1064 error in the following query?
SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
+ Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpumalanga
GP + Glam Slam
Ken Gieselman [EMAIL PROTECTED] writes:
[...]
Yeah, that's my fall-back option -- though the thought of executing
the query twice is a bit daunting. Some of the tables run into
billions of rows per year (the merge tables anyhow, the data tables
are broken down by month to keep them from
[EMAIL PROTECTED] wrote:
I did not expect that null was not not-equal to 1.
Any comparison with NULL returns NULL:
mysql select null1,null1,null1,null=1;
+-++++
| null1 | null1 | null1 | null=1 |
+-++++
|NULL | NULL |
Schalk Neethling wrote:
Greetings
What might be causing the 1064 error in the following query?
SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
+ Eastern Cape Classic + SA Model Super Star + KZN Model GP +
Thanks but I still do not get why this does not merit a, you might want to
think about this.
So in the following query:
select * from new_payments where closed1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a feature, I expected that;
[EMAIL PROTECTED] wrote:
Thanks but I still do not get why this does not merit a, you might want to
think about this.
So in the following query:
select * from new_payments where closed1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a
Belay my comments on true and false. I got mixed up. That works as documented.
On Mon, 19 Sep 2005, Roger Baklund wrote:
[EMAIL PROTECTED] wrote:
I did not expect that null was not not-equal to 1.
Any comparison with NULL returns NULL:
mysql select null1,null1,null1,null=1;
Hi all,
I have two three tables, spread accross two databases:
hotel_1 database:
table room (room_id, room_name)
table package (package_id, package_name)
master database:
table search_cache (date, room_id, package_id, hotel_id)
I'd like to search for any combination of room/package ids that
solved it...
i used 'distinct' in main and subquery and somehow it affects the whole
query results...
---
Badai Aqrandista
Cheepy (?)
From: Badai Aqrandista [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: subquery accross different database
Date: Mon, 19 Sep 2005 15:14:06 +1000
25 matches
Mail list logo