41. How do you find out which auto increment was assigned on the last insert? SELECT LAST_INSERT_ID() will return the last value assigned ...
Saturday, August 6, 2011
Mysql Interview Question and Answers 4
31. what is difference between primary key and candidate key? Primary Key - are used to uniquely identify each row of the table. A table ...
Mysql Interview Question and Answers 3
21. Differentiate the LIKE and REGEXP operators? SELECT * FROM pet WHERE name REGEXP "^b"; SELECT * FROM pet WHERE name LIKE ...
Mysql Interview Question and Answers 2
11. What are ENUMs used for in MySQL? You can limit the possible values that go into the table. CREATE TABLE months (month ENUM ’January’...
SharePoint Interview Questions and Answers 2
16. How to create links to the mapped network drives? Creating links to mapped drives in WSS v3 or MOSS 2007 can be done via the new conte...
Subscribe to:
Posts (Atom)