GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

MYSQL Interview Questions


MYSQL Interview Questions

Questions: 44
Comments: 108
 MYSQL Tags
 Showing Questions 1-10 of 44 Questions
[1] 2 3 4 5 Next >>
 Sponsored Links

 
 MYSQL Interview Questions
Sorting Options :  

Latest Answer: A candidate key is a unique identifier that could be used as a primary key, which when you choose the primary key, the rest will then just be data fields ...


Latest Answer: select sname,phone,feebal,feepaid from student s left outer join fees fon s.sid=f.sid;union select sname,phone,feebal from student s right outer join fees f on s.sid=f.sid;u can use this compile code ...

Latest Answer: as row id is in oracle same as id is in mysql but in mysql there is no concept of rownum ...

Latest Answer: SELECT c1.CategoryID, c1.Name, c2.CategoryID, c2.NameFROM category AS c1, category AS c2WHERE c1.CategoryID = c2.ParentIDORDER BY c1.CategoryID, c2.CategoryID ...
Read Answers (1) | Asked by : Vishwapati Mishra

select salary from tablename order by desc limt 4; 
Latest Answer: select sal from emp order by sal desc limit 3, 1;This will select the 4th highest salary from emp table, i.e picks up after the third, next value ...
Read Answers (3) | Asked by : Vishwapati Mishra

Latest Answer: hey,here it is :--select/update/delet/insert- from-where-group by-having-order byI think this is the oder of the execution. ...

Latest Answer: if u r talking about setting different timezone from diff connection on same DB then i wont think its possibleAs per My knowledge Time zone settings are golbal and are applied server side ...
Read Answers (1) | Asked by : Ranjit

Latest Answer: For Mysql database, you can use mysqldump for that.See details with examples @ http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html ...

How do you reformat system date in MySQL?Explain various formats ..? how to add a date/hour/minute/second to a date?

View page [1] 2 3 4 5 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 
Sponsored Links



 

 
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape