export data to file.txt

------=_Part_16448_32607940.1117467200318
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

hello=20
i need export tables the datas the a database a file .tx.
i used mysqldump, but this is a backup.

thanks

------=_Part_16448_32607940.1117467200318--

Re: export data to file.txt

OK, I couldn't understand most of it, but I got this: You want to
export tables to a .txt file (text only), that can be done using lots
of formats (including CSV, tab separated fields, etc) check the
mysqldump syntax, specially the -T (--tab) option, the manual has all
the options, check the --lines-xxx and --fields-xxx for producing
output other than tab separated fields.

Good luck,

On 5/30/05, fernando monta=F1o wrote:
> hello
> i need export tables the datas the a database a file .tx.
> i used mysqldump, but this is a backup.
>=20
> thanks
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: export data to file.txt

Search for "select ... into file ..." in MySQL manual.

Petr Vileta, Czech republic
(My server reject all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)


----- Original Message -----
From: "fernando montaño"
To:
Sent: Monday, May 30, 2005 5:33 PM
Subject: export data to file.txt


hello
i need export tables the datas the a database a file .tx.
i used mysqldump, but this is a backup.

thanks


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Something boring about mysql application!!!

Hi,
>>> mysql -S /opt/usr/mysql4/var/mysql.socket -uusr -p111111

is 111111 your database, i don't think so. That should dbe the password.
so, the command to connect that can be found in the doc can be :
mysql -uusr -p mysql

this will prompt you tu enter the password
Password:

here type 111111

and you are connected.

look at the doc at mysql.com

Mathias


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

GROUP BY approximation

I have table with very similar values in one field,

count word
----- ----
2 APPLE
6 APPLES
1 APPEL

select *,sum(count) as total from table group by word will leave these
rows separated.

So I want to GROUP BY that field to add the numbers (to come up with 9
APPLES). Is this possible? I guess I'm searching for some type of
functionality similar to SOUNDEX(), except for grouping not selecting.

Thanks,
Andy


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: GROUP BY approximation

In the last episode (Jul 22), Andy McHargue said:
> I have table with very similar values in one field,
>
> count word
> ----- ----
> 2 APPLE
> 6 APPLES
> 1 APPEL
>
> select *,sum(count) as total from table group by word will leave
> these rows separated.
>
> So I want to GROUP BY that field to add the numbers (to come up with
> 9 APPLES). Is this possible? I guess I'm searching for some type of
> functionality similar to SOUNDEX(), except for grouping not
> selecting.

SELECT SUM(count), MIN(word), SOUNDEX(word) GROUP BY SOUNDEX(word)

If you are running mysql >= 4.1, you can use GROUP_CONCAT() to fetch
all the words matching each soundex group.

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org