Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the column count and column name from the
resultset in the database connection program?
- 6 Answers
- 12892 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sreeprasad
you use following sql query
select column name, count(column name)from table name.
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / uday kumar_anem
Hello friends, just observe the question.
It is not Datatable, it is database connection program.
Say i user "select * from table"
Here i dont know how many col r there in my table.
So give the answer to find the number of columns in that
table.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / akshara
in the vb script we use genralluy to count the rows as
rowcount=datatabble.GetSheet("Sheet name").GetRowCount
MsgBox(rowcount)
i fyou need sheet count
datatable.getcheetcount
Thank you
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / prasad
Select column_name, count(column_name) from user_tab_columns
where table_name='EMP' group by rollup(column_name);
| Is This Answer Correct ? | 0 Yes | 5 No |
If 3 browsers are opened in our system, how to enter the facebook url into second browser by using descriptive programing
what is the difference between testing and debugging?
How to Analyze the Checpoint results by Text/Text Area Checkpoint?
What are the types of object repository?
Can the mode of object repository be change during run time? Eg. if the mode is per-action during design time can i change it to shared and vice-versa? Any scripting possible?
write a script to verify links on any web page by using descriptive method by creating a description object (give a filter condition only link) ... need to verify expected like name by reading
What are the enhancements u did after recording ur script?
What are all the common questions asked for the candidates having more than 1 yrs exp in QTP?
What is 'sleep' in sync point?
How can I find out the cursor position through QTP suppose I am keep tabbing(Pressing the tab key continuously) and stoped at a position Now I want to find out where the cursor position is
Name the properties you would use for identifying a browser and page when using descriptive programming?
1>How to get the browser name by writing the VBScript. 2>How did you used the GetROProperty and GetTOproperty .give real time scenario. 2>Give and real time ex for the bug having "High Severity and low priority"on banking doamin web based application.
WinRunner 
