Hello,
I am looking for how to save into file content of table,
Can you give an example of mysql query,
thanx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Do you mean run a query that pulls all content in a table?
OR
Something thatÂ’s saves all content of a table?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 8:52 AM
To: [EMAIL PROTECTED]
Subject: How to save the table content into
Hello,
I want to store my table in text file,
I've tried :
select * from news into outfile 'news1.txt'
but doesn't work
Can you help to do this with phpmyadmin or sql,
thanx
-
Before posting, please check:
In phpmyadmin
Choose the table from the list... Scroll down the main screen and you
will see this:
View Dump(schema) of table:
You will have options like Structure only, Structure and data, CSV for
MS Excel... Structure dumps the column names and all the field types...
Structure AND data