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

how will you load the test cases in ddt?

2144


how can i pass a "cript"as a parameter in to a function

2048


What is test object model in quicktest professional?

1129


Explain the types of object repository?

1029


wht type of User defined functions or Java Releated functions do we write in VB scripting

2289


How is UFT 11.5 version different from UFT 12.0?

1112


Did QTP prove efficient for your project? Yes or No, explain?

6680


Why is Client side image is preferred over server side image?

1952


What are the key points to create a framework in QTP for oracle forms?

2309


Can anyone pls tell me how to do action parameterization (input and output parameters) with respect to login window and insert order of flight reservation window in detail( pls give a clear step by step explanation with example) anyone please. Will be very thankful to u

1837


Explain different type of event trigger option.

1022


I have enrolled for a QTP course which is a four weekend course.Do you think its a good way to start off learning this tool?What all do i need with me in order to become a pro at using this tool?

2195


what is clean sweep?

2038


How to test fly out menu in qtp?

1011


In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer

2468