Peter Skipworth wrote:
>
> mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
> "/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
> myfield='1'" dbname
>
> On Wed, 4 Apr 2001, James
> Salinas wrote:
>
> > Hi,
> >
> > My problem is specifically conce
You could place the code that works in a text file and
feed the text file to mysql from the command line.
If the text file was named 'dothis', the command line
might look like:
'mysql -u username -p cDatabase < dothis'
You will be prompted for username's password after
pressing ENTER. If you w
mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
"/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
myfield='1'" dbname
On Wed, 4 Apr 2001, James
Salinas wrote:
> Hi,
>
> My problem is specifically concerning syntax for mysqldump.
> I can succe
Hi,
My problem is specifically concerning syntax for mysqldump.
I can successfully execute the following SQL commands from within MYSQL:
mysql> USE cDatabase
mysql> SELECT * INTO OUTFILE "/root/cTable-data.dump"
-> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
-> FROM cTable WHERE myfield='1';
Q