what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---

Is a foreign key always unique?

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

---

Is left join faster than join?

0 Answers  

---

What is the difference between jpql and sql?

0 Answers  

---

how will i became good database developer?

1 Answers  

---