How to get the column count and column name from the
resultset in the database connection program?
Answer Posted / punit
in ur mysql database there is 1 database with name
information_schema,
so 1st type,
use information_schema;
inthis data base there is 1 table COLUMNS which contain all
the info related to allthe tables in ur mysql,
so hit the following queri for youe column count:-
select count(*) from COLUMNS where TABLE_NAME='Table name';
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain how qtp identifies object?
Can UFT be connected to Quality Center? If ‘Yes’ brief the process or steps.
What is standalone database?
What is TOM in QTP?
What is debugging? How you debug your script?
Differences between text and test area checkpoints?
What is 'sleep' in sync point?
What are the different types of recovery operation?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
Explain about datafile/verification of date file when file is not available in local system?
Want to verify notepad reports using QTP framework or any other BV script method. Can anyone share the method to achieve it? Eg. Person Name is the header and the actual name is John then how can we verify weather person name is John
What is Distributed testing? How does UFT support it?
Can anyone pls tell me in realtime (descriptive programming) how will the properties of the object be given to the test team. R they given in an excel sheet and is the same sheet also given to the development team and by whom is this given? Thanks a lot.
How to analyzing test results using quicktest professional (qtp)?
How to modify object property in qtp ?