i am acesing mysql database through command prompt.i am new to it.pls tell me first of all how to run select queries and get the data in proper form because data is coming in a very distorted mannner.

Pls guide me how to wrk on mysql

please show example of query that returns "very distorted" data

pls find in the attahmenet i am suposed to wrk on ms sql thrugh comand prompt but the data i souming in a v ery unmanneredd way

you can either use the MySQL command client or a visual client such as MySQL Workbench, HeidiSQL, PHPMyAdmin or the host of others out there

as far as I can see your MySQL command line client is working fine. I don't know what the stuff above the last 9 lines is.. but from e:\ptogram files.... everything seems fine.

I don't know what you mean by 'unmannered' or distorted in this context

however Id suggest you reopen your MySQL command line client and then issue a few SQL statements

eg
show databases;

select * from mydatabase.mytable;


replacing mydatabase and mytable with valid names within your schema

if you are struggling with that then consider downloading somethign like MySQL Workbench from the MySQL site

not sure what you are doing, but the attachment you posted does not shed any light on it