What is a join in mysql?



What is a join in mysql?..

Answer / Sunita Tevatiya

In MySQL, JOIN is used to combine rows from two or more tables based on a related column between them. There are several types of joins like INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is msql?

1 Answers  


Write a query to stop mysql in unix

1 Answers  


when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  


How to use in conditions?

1 Answers  


How to present a past time in hours, minutes and seconds?

1 Answers  


How can you get your MySQL root password, if you lost it?

1 Answers   PCS,


What is mysql aggregate functions? Explain

1 Answers  


What is the return type of mysqli_query?

1 Answers  


What is a crosstab query?

1 Answers  


How many rows we can insert in a mysql table?

1 Answers  


Write a command with which mysql table can be repaired

1 Answers  


What are the disadvantages of mysql?

1 Answers  


Categories