Hello,
This doesn't relates to php directly.
Oracle , MSSQL supports TDE innately. Is there any way to adding that
support to mysql too ? Looking for some free, opensource solution.
Something which won't be much of a hit on performance.
thanks
--
Regards,
Nitesh Nandy
bject: Re: [PHP] 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
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 Dav
:[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 lot into memory before returning it to
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.
--
.--
;t seem to have an effect, however.
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_
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
"sele
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
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
"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
[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 1(catDepa
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 1(catDepartment)
[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 ne
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 lo
olmes...
> -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 ye
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
nesday, 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() yo
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 users
> 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?
>
Assuming that both databases are on the same server and that you have created the
empty table in the second database:
mysql
> INSERT INTO DATABASE2.TABLENAME SELECT * FRO
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 Castold
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 PR
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:
-B
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 co
23 matches
Mail list logo
