Hi,

Here are some tips of using MYSQL Commands in Command Prompt.
Executing Commands from Outside MYSQL in Command Prompt.


For Creating Database

DB@server:/> mysql -u root -e "DROP DATABASE test1";

For Executing any Queries

DB@server:/> mysql -u root -e "SELECT * FROM TABLENAME" dbname;

Export the Record set of the Table into XML/HTML

DB@server:/> mysql -u root -X -e "SELECT * FROM TABLENAME" dbname;
DB@server:/> mysql -u root -H -e "SELECT * FROM TABLENAME" dbname;

-X --> Exports the Record set into XML Form.
-H --> Exports the Record set into HTML Form.

The Output Can be saved to a particular path by specifying the path.

DB@server:/> mysql -u root -X -e "SELECT * FROM TABLENAME" dbname > (Destination File Path);
DB@server:/> mysql -u root -H -e "SELECT * FROM TABLENAME" dbname > (Destination File Path);

__________________
-Murali..