Answer Posted / naveen

when data from more than one table in the database is
required,a join condition is used.
select empno,ename,dname,loc from emp,dept;
equi join
non-equi join
self join
outer join
cartesian join

how to take mysql database backup?

1070

---

How do I grant privileges to a user in mysql phpmyadmin?

954

---

How do I connect to a database in mysql workbench?

1025

---

How do you create a new database in mysql?

915

---

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

921

---

What is the purpose of -> in the mysql terminal?

1119

---

How do I insert an image into mysql workbench?

967

---

What is relational database in mysql?

920

---

What is difference between unix timestamp and mysql timestamp?

1014

---

What is delimiter in mysql stored procedure?

921

---

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1361

---

What are the similarities between a function and a procedure?

896

---

What are the mysql database files stored in system ?

1061

---

What is csv?

949

---

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2119

---