Hi, I want to export some fields (username, password, email) from a table. Can someone advise me how to do this? Thanks!
insert into database1..tablename (username,passwor,email) select username, password, email from originaldatabase..tablename
try this. Suppose your table name is table1 select username,'|',password,'|',email,'|' into outfile '/tmp/x.txt' from table1 order by username This is in Mysql Now you have a text file with '|' separated files, all the database packages can import this.