Re: How to Dump only Data

2001-10-02 Thread fi-claudemir
Didn't work... still there are informations and the INSERT INTO clause into the dumped file Thanks anyway! Claudemir F. Martins Robert Cope wrote: >On Tue, Oct 02, 2001 at 01:55:13PM -0300, fi-claudemir wrote: > >>How to Dump only the data from a Table. >>I took

How to Dump only Data

2001-10-02 Thread fi-claudemir
Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php

How to delete diferent lines in 2 tables ?

2001-10-01 Thread fi-claudemir
Hi I'working with two tables (table1 and table2). I 'm trying to use a sub-select to delete the lines that are in the table2 but are not in the table1 but I didn't get it. Below the way I've tried: DELETE FROM Table1 SELECT Table1.* FROM Table1 LEFT JOIN Table2 ON Table1.ID=Table2.ID WHERE T