Ideas for select all columns but one mysql stored procedure
Assume we’ve a table with 100 rows and we need to select all columns but one.The problem is headache of actually typing out all 99 required columns!! In this blog…
QA-Testing Definitions-Interview Questions: Part-III
QA-Testing Definitions-Interview Questions: III (T – Z): Race Condition: A cause of concurrency problems. Multiple accesses to a shared resource, at least one of which is a write, with no…
No More Spool Space Teradata Query Solution
Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The error: “NO MORE SPOOL SPACE”. Correct, the problem…
QA-Testing Definitions-Interview Questions: Part-II
QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a…
5 useful MySQL Command Options-pager-prompt-rehash-tee-system
There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command…
QA-Testing Definitions-Interview Questions: Part-I
QA-Testing Definitions-Interview Questions: I (A – I) Acceptance Testing: Testing conducted to enable a user/customer to determine whether to accept a software product. Normally performed to validate the software meets…