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

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]>

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 recor

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 manual)

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 cont

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 change

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
nt is very long. By the way, my system has an SCSI HD which is quite fast for it. Thank you all, Carlos Fernando Scheidecker Antunes.