Webnology

mysql is a simple SQL shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively, query results are presented in an ASCII-table format. When used non-interactively (for example, as a filter), the result is presented in tab-separated format. The output format can be changed using command options.

Using mysql is very easy. Lets See Below Code For Your Reference.

With Shell
mysql db_name
Or:
mysql --user=user_name --password=your_password db_name

Then type an SQL statement, end it with “;”, \g, or \G and press Enter.

Let we will see how we can connect mysql Database With Command Prompt

Before you can use MySQL, you need to create a database on your Control Panel. Once you have created a database, there are a few ways you can connect to it with the help of command line:

At a shell prompt you type all one 1 single line:

mysql -u DBUSERNAME -h DBSERVER -p DBNAME

DBUSERNAME: Database User Name
DBSERVER: Database Server Name(Most of the time Localhost)
DBNAME: Database Table Name

See Below Example For Further Help
Example:

mysql -u FutureS -h db.kb.com -p Client

DBUSERNAME: FutureS
DBSERVER: db.kb.com
DBNAME: Client

For Further Command Lines Syntax Visit Following Links:
http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html
http://dev.mysql.com/doc/refman/5.1/en/mysql-commands.html

Some Important Facts About PHP Interview:

1) Always Expect Unexpected Questions.
2) Always Give any sample answers you find which is suitable to that question.
3) Job interview questions are not things to fear, they are opportunities to excel. They allow you to show why you are the best person for the job, so instead of afriad them, take it positive way and look forward to them! Try to give better answers than anyone else.

You have to take Following actions:

1) Make a list of your positive points for the position. try to find out What qualifications, skills, experience, knowledge, background, personality do you possess that would apply to this particular job?
2)Dont Depend on job sample interview questions you find through various resources, you must develop yourself try to make a list of questions based specifically on the job for which you are applying.
3) Write down your answers which is suitable to questions.
4) Review and edit your answers until you feel they are "just right."
5) Don't try to memorize answer;

There are few Suggessations For You:

1) Be yourself, Be concise.
2) Let the interviewer lead, If they want you to talk more, talk more but in a such a way that person will appriciate your answer.
3) Don’t talk too quickly.
4) Don’t ask for questions.
5) Do your own research.
6) Think properly about what you would like to say.
7) Always Remember what the interviewer wants.
8) Be accessible, Give the phone number and an email address. Don’t hide behind a company. Other wise its difficult to them to contact you.
9) Reach for Interview On Time.
10) Prepare yourself For Each And Every Condition.
11) Don't answer it
There are some questions that simply shouldn’t be asked. If you think you've just had one of these (e.g. whether you're planning a family or not), then politely explain that you'd rather not discuss that in the context of an interview; you like to keep your work and home life separate. Stay calm and realise that this type of question is almost always asked innocently, as an ice-breaker
12) It's ok to ask for time to think.

If you have any doubts or query than contact us.