Quote:
|
Originally Posted by Magoth78
Hello,
I would like to export 2 columns (name and charname) from the account table.
Once it's done, I'd like to import it in a table called 'access' wich has 2 columns: Login / Password.
- the datas of the 'charname' column will go in the new Login column
- the datas of the 'name' column will go in the new Password column.
Is it possible to do that just with Mysql commands?
Thx,
Mag
|
you can outside of mysql
mysqldump -u sdabbs -p account password > accounts.txt
this will dump your passwords into a text file called accounts.
im not sure how to do login and password but if you toy with it you should get it working.