I don't think you do anything about the output, you could however check if a
record is already in the table before inserting it... And skip it if already
there
Olaf
On 3/2/10 11:17 AM, "Richard Reina" wrote:
I have a perl script that periodically reads and enters (via perl->DBI parsed
syste
In general you need to adjust your server settings to actually use the new RAM.
This depends on various things, storage engines used, what else runs on the
box, etc.
In addition you should look at your schema, see if you have the right indices
for what you want to do.
E.g. All columns that you u
Robert,
the import of the dump will not remove your other tables unless there is a
naming conflict, then the table will be overwritten. As far as the prefix goes
you can edit the dump file, find the create table statement for each table and
add the prefix. If you have lots of tables or a huge d
In that case you either need the users password or create a user with the same
permissions and try with that user
Olaf
-Original Message-
From: Pete Harlan [mailto:[EMAIL PROTECTED]
Sent: Tue 7/24/2007 7:30 PM
To: Mogens Melander
Cc: Carlo Sogono; mysql@lists.mysql.com
Subject: Re: su-l
As fat as your first and last question go you can create views.
create view somename as select c1,c2,c2 from table (limit 5);
and then
select from somename;
i am not familiar with the windows client but i would expect auto completion
there too
olaf
-Original Message-
From: Olav Mørkr
