MySQL and OpenMosix

2002-08-13 Thread Carlos Fernando Scheidecker Antunes
Hello all, Does MySQL works well with OpenMosix? Has anyone ever tried it? Is there any special configuration to MySQL that I should be aware of? Thank you in advance, Carlos Fernando Scheidecker Antunes Linux User #207984

How to duplicate records

2002-06-18 Thread Carlos Fernando Scheidecker Antunes
Hello all, I've got some records of a Database that I would like to duplicate if possible with an statement. The table has Code, Model, Year, units. The primary key is Code, Model and Year. What I need is to duplicate Code, Model and units for a different year. Say I want to duplicate all

Re: How to duplicate records

2002-06-18 Thread Carlos Fernando Scheidecker Antunes
for a specific code match but they have to be duplicated for year 2003. Thanks again, C.F. - Original Message - From: Don Vu [EMAIL PROTECTED] To: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 9:38 AM Subject: RE: How to duplicate

TEXT field: How many characters does it hold

2001-12-31 Thread Carlos Fernando Scheidecker Antunes
Hello All! Can anyone tell me how many characters a MySQL TEXT field can hold? What's the limit? Thank you, Carlos Fernando. Linux User #207984 - Before posting, please check: http://www.mysql.com/manual.php (the

How to update part of a field ?

2001-11-22 Thread Carlos Fernando Scheidecker Antunes
Hello all, I've got some e-mails addresses on an e-mails database where one domain has been changed to another. So I have : email1@domain1 email2@domain1 I need to change @domain1 to @domain2 on this e-mail field and keep the user name. Some e-mails of an specific ISP had their domains

Export just part of a table to a CSV file

2001-11-22 Thread Carlos Fernando Scheidecker Antunes
Hello all, Usually I back-up my tables importing them to .csv files. What I do is I issue the following command : mysqldump - h localhost -u user -ppassword --tab=/tmp --fields-terminated-by=; database_name table_Name table.csv This creates a file called table.csv by dumping all the contents

How to return the value of deleted rows

2001-05-07 Thread Carlos Fernando Scheidecker Antunes
Hello Folks, I wonder how can I return the number of deleted rows after a DELETE SQL statement. Is there any way to return the quantity of updated rows as well? Thanks, C.F.

Performance Problems with Huge Table

2001-05-05 Thread Carlos Fernando Scheidecker Antunes
you all, Carlos Fernando Scheidecker Antunes.