Hi all- is there a way have a large data result set from MySQL compressed?
E.g. I have a table with over a million rows of data that I want to do a
select * from on and then take that result, do some field/data
manpulation, and then insert row-by-row to another table. The problem is
the result
On 6 Feb 2006 at 16:03, David Yee wrote:
Hi all- is there a way have a large data result set from MySQL compressed?
E.g. I have a table with over a million rows of data that I want to do a
select * from on and then take that result, do some field/data
manpulation, and then insert row-by-row
Hi David,
See http://www.php.net/mysql_unbuffered_query
It won't load the whole lot into memory before returning it to php.
David Yee wrote:
Hi all- is there a way have a large data result set from MySQL compressed?
E.g. I have a table with over a million rows of data that I want to do a
.
David
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 4:16 PM
To: David Yee
Cc: 'php-general@lists.php.net'
Subject: Re: [PHP] PHP mysql data result set compression
Hi David,
See http://www.php.net/mysql_unbuffered_query
It won't load the whole
On Mon, 2006-02-06 at 19:39, David Yee wrote:
I'm still not sure why the MYSQL_CLIENT_COMPRESS didn't seem to have an effect
That causes the data to be transfered from the MySQL server to the
client with compression. The results are still uncompressed on the
client.
Cheers,
Rob.
--
PM
To: David Yee
Cc: 'php-general@lists.php.net'
Subject: Re: [PHP] PHP mysql data result set compression
Hi David,
See http://www.php.net/mysql_unbuffered_query
It won't load the whole lot into memory before returning it to php.
David Yee wrote:
Hi all- is there a way have a large data
w/o disk swapping then that would be the fastest way to do
this?
David
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 4:50 PM
To: David Yee
Cc: 'php-general@lists.php.net'
Subject: Re: [PHP] PHP mysql data result set compression
Hi David,
From
] PHP mysql data result set compression
Hi David,
From the comments on unbuffered_query:
However, when using different db connections, it all works ofcource ...
So create a second db connection and when you run the insert use that
instead:
$result2 = mysql_query(insert blah, $dbconnection_two
Jlake [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have a small database that I want to display data from. in such a way
that
it shows shows in a table with the table header being the department
category and the table cells being the categories for each department. I
have no
I have a small database that I want to display data from. in such a way that
it shows shows in a table with the table header being the department
category and the table cells being the categories for each department. I
have no problem connecting to the database) I imagine that I will need
nested
[snip]
I have a small database that I want to display data from. in such a way
that it shows shows in a table with the table header being the
department category and the table cells being the categories for each
department. I have no problem connecting to the database) I imagine that
I will need
Data is as such right now for testing purposes:
ID, catName, catLink, catDepartment.
I will have multiple instances of the same text in catDepartment. I realize
this is a fopaux. I'm just trying to do a quick fix.
none the less I want the data formatted like this:
DEPARTMENT NAME
[snip]
Data is as such right now for testing purposes:
ID, catName, catLink, catDepartment.
I will have multiple instances of the same text in catDepartment. I
realize
this is a fopaux. I'm just trying to do a quick fix.
none the less I want the data formatted like this:
DEPARTMENT NAME
I have a database with a TEXT field in it, and I've been using it this way
for over three years... today was the first time an INSERT was truncated on
this field... It was an unusually large INSERT, and due to the truncation
I'm now has wondering what are the limits (if any) on inserting data
...
-Original Message-
From: JSheble [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 3:43 PM
To: PHP List
Subject: [PHP] mySQL Data Limits
I have a database with a TEXT field in it, and I've been using it this
way
for over three years... today was the first time an INSERT
This question has not much with PHP, but I work with PHP...
Can I get the data from a table in MySQL and copy/transfer all data to
other database to a table with the same name?
regards,
Augusto Cesar Castoldi
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
Hi:
The easiest way to do it is using mysqldump. mysqldump creates a file
that contains SQL statements to reconstruct a database, which you can
easily execute on the other database. It will create tables with same
names and all the records will be copied, too.
Seung-woo Nam
Augusto Cesar
There are a few ways to do this...
1.) Copy the binary files over in the mysql data directory ... have to be root
and normally at a shell.
2.) SELECT * FROM table and then while() you have rows INSERT INTO other_table
those values
3.) mysqldump can be used via PHP and used by most
, April 18, 2001 10:48 AM
To: Augusto Cesar Castoldi
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL data
There are a few ways to do this...
1.) Copy the binary files over in the mysql data directory ... have to be
root
and normally at a shell.
2.) SELECT * FROM table and then while() you have
Hi,
I got Data from my Database,
but how can I show them in a textfiled within a html form?
Any ideas?
Thanks in advance.
--
Best Regards
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To
Hi Denis,
@ 8:13:41 PM on 4/15/2001, Denis Mettler wrote:
I got Data from my Database, but how can I show them in a textfiled
within a html form? Any ideas?
Show us some code?
Assuming you've gotten the data into a $row-column, just echo it
into the value of one of the form fields:
input
21 matches
Mail list logo