Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Explain how qtp identifies object?

1085


Can UFT be connected to Quality Center? If ‘Yes’ brief the process or steps.

1105


What is standalone database?

2281


What is TOM in QTP?

2225


What is debugging? How you debug your script?

1198


Differences between text and test area checkpoints?

1120


What is 'sleep' in sync point?

1109


What are the different types of recovery operation?

1026


Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

2008


Explain about datafile/verification of date file when file is not available in local system?

2740


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

2592


What is Distributed testing? How does UFT support it?

1058


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.

2045


How to analyzing test results using quicktest professional (qtp)?

1040


How to modify object property in qtp ?

1006