Answers were Sorted based on User's Feedback
Answer / mala yadav
select command is used to fetch the result from the table ,
but of u want the combine results from more than 1 table
then in this case we use JOINS rather than a single table
In joins u can join upto 2 to 61 tables to get tha required
joins are of 5 types
- inner join
- self join
- cross join
- left outer join
- right outer join
|Is This Answer Correct ?||1 Yes||0 No|
Answer / vishal
if u donot know join means u always working in one table but
always single table is not enough to give the result than
comes the concept of joins in which two table we join must
have a column same on the basis of the table are join. join
are of various type such as left outer, right outer ,inner
|Is This Answer Correct ?||0 Yes||0 No|
What is an index? How can an index be declared in mysql?
What happens if a table has one column defined as TIMESTAMP?
Is mysql same as mariadb?
How do I check mysql version?
Is mariadb better than mysql?
Can you tell which of the following where clauses is faster?
Can you save your connection settings to a conf file?
Is mysql query case sensitive?
Give string types available for column?
write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
Which storage engine is best in mysql?
What is latest version of mysql?