Logo F2FInterview

MySql Interview Questions

Q   |   QA

first of all instead of using select * from table1, use select column1, column2, column3.. from table1. Look for the opportunity to introduce index in the table you are querying. use limit keyword if you are looking for any specific number of rows from the result set.

By below method if password is pass and user name is root
# [mysql dir]/bin/mysql -h hostname -u root -p pass

mysql> create database databasename;

mysql> show databases;

mysql> use databasename;

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: