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';

Answer / sreeprasad

you use following sql query

select column name, count(column name)from table name.

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.

Answer / sreeprasad

Thanq Akshara..

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

Answer / prasad

Select column_name, count(column_name) from user_tab_columns
where table_name='EMP' group by rollup(column_name);

please tell me how to identify the index of the link in the web table .links are not constant.example i want to click the link in the inbox ,search the item and click the partcular mail.(mail links count is not constant)

1 Answers   IBM,

Need one Urgent help please,for ex: first time i created Local reposory and convert that local to shared Rep and save in some where(by using Export local objetcs), unfortunately that saved repository is missed, now i want same repository,but iam not able to export the same repository second time?? i need that Repository only how to get???

2 Answers   TCS,

Syntax for how to call one script from another? and Syntax to call one "Action" in another?

2 Answers  

How is the Bitmap checkpoint different from Image checkpoint?

0 Answers  

This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10

0 Answers  

How to maintain the old scripts in QTP?

2 Answers   Olive Tech, Wipro,

There is one login screen,after accepting valid username and apassword, it will show the next screen. In the 2nd screen u r having 2 combo boxes, U have to select any item from these, and click OK button. After closing that, it will show the 3rd screen. If u click CANCEL button from 2nd screen it will show the first screen. Write QTP script for it???

1 Answers   Sonata,

Discuss QTP Environment.

1 Answers  

Is it possible for QTP to capture the objects in word document.If so please give me the code.Thank you.

2 Answers  

some times we write user define functions.where we write main and sub program,how,where to insert the functions in qtp?

2 Answers   GE,

give me the code for check point for validating application

1 Answers  

how to reverse a string with out using string or predefined function,ex:string is " i love india". the output should be like this "i evol aidni"

10 Answers   Aspire, MNC, Omega,