multi table update

[Tomas Carmen]

Hi list:

How can I update a table field from a another table field, the
multitable update is not implemented  or yes?.
I am thinking in use a foreign key (references) or tmp table or can I
use table aliases? something like this:

replace into table master( fielda, fieldb , fieldc) select t1.fielda,
t1.fieldb, t2.fieldx from master as t1 left join t2 on
t1.fielda=t2.fielda;

Any suggestion

Thanks in advance.

-- 
Tomas Carmen R.
TCC S.A.
telef.:+51-1-4428842
fax  : +51-1-4426434

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqldump issues

[Tomas Carmen]

daniel james wrote:
> 
> I need to generate a tab-delimited text dump of table
> data ONLY and have it output to a text file. I don't
> want any table info, delimiters, etc.  I need this to
> copy/paste into a excel spreadsheet.  What's the
> syntax?
> 
> I'm stuck here:

Hi: 
What do you think about: 

select fields from table  into outfile 'file' 
  


> 
> % mysqldump dbname tablename > ???
> 
> pleasepleaseplease help..!
> 
> ______
> Do You Yahoo!?
> 
-- 
Tomas Carmen R.
TCC S.A.
telef.:+51-1-4428842
fax  : +51-1-4426434

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ERROR 1114

[Tomas Carmen]

Hi:
Someone knows why I am getting this error after some left joins between
3 tables or more tables.

ERROR 1114 at line 292: The table 'SQL202_0'  is full

It's only  whith more than 8000 rows moreless.

I'm working with mysql 3.22.27 (server an client) on RH 7.1

Can you help me, please?

Thanks in advance

Tomas Carmen R.