Re: Print file

2002-02-12 Thread Gerald R. Jensen
Christo: Write a query that does what you want to a text file called virtusertable.sql: USE databasename; SELECT name FROM tablename; Then run the query from the command line (mysql -uusername -p databasenamevirtusertable.txt) Gerald Jensen - Original Message - From: "Christo Rademeyer"

Re: Print file

2002-02-12 Thread DL Neil
Hi Christo, > How can I take info from one table and print it into a txt file. > the table is (NAME) > and all the names in it I want to print out to a file name virtusertable. Would SELECT ... INTO OUTFILE 'file_name' suit you? (MySQL manual: 6.4.1 SELECT Syntax) Regards, =dn ---

Re: Print file

2002-02-07 Thread Gerald R. Jensen
Christo: Write a query that does what you want to a text file called virtusertable.sql: USE databasename; SELECT name FROM tablename; Then run the query from the command line (mysql -uusername -p databasenamevirtusertable.txt) Gerald Jensen - Original Message - From: "Christo Rademeyer"

Re: Print file

2002-02-07 Thread DL Neil
Hi Christo, > How can I take info from one table and print it into a txt file. > the table is (NAME) > and all the names in it I want to print out to a file name virtusertable. Would SELECT ... INTO OUTFILE 'file_name' suit you? (MySQL manual: 6.4.1 SELECT Syntax) Regards, =dn ---