MySQL Cookbook, Second Edition > Obtaining and Using Metadata > Determining Whether a Statement Produced a Result Set

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

MySQL Cookbook, Second Edition

Search

Preface

Ch. 1. Using the mysql Client Program

Ch. 2. Writing MySQL-Based Programs

Ch. 3. Selecting Data from Tables

Ch. 4. Table Management

Ch. 5. Working with Strings

Ch. 6. Working with Dates and Times

Ch. 7. Sorting Query Results

Ch. 8. Generating Summaries

Ch. 9. Obtaining and Using Metadata

Introduction

Obtaining the Number of Rows Affected by a Statement

Obtaining Result Set Metadata

Determining Whether a Statement Produced a Result Set

Using Metadata to Format Query Output

Listing or Checking Existence of Databases or Tables

Accessing Table Column Definitions

Getting ENUM and SET Column Information

Using Table Structure Information in Applications

Getting Server Metadata

Writing Applications That Adapt to the MySQL Server Version

Determining the Default Database

Monitoring the MySQL Server

Determining Which Storage Engines the Server Supports

Ch. 10. Importing and Exporting Data

Ch. 11. Generating and Using Sequences

Ch. 12. Using Multiple Tables

Ch. 13. Statistical Techniques

Ch. 14. Handling Duplicates

Ch. 15. Performing Transactions

Ch. 16. Using Stored Routines, Triggers, and Events

Ch. 17. Introduction to MySQL on the Web

Ch. 18. Incorporating Query Results into Web Pages

Ch. 19. Processing Web Input with MySQL

Ch. 20. Using MySQL-Based Web Session Management

Appx. A. Obtaining MySQL Software

Appx. B. Executing Programs from the Command Line

Appx. C. JSP and Tomcat Primer

Appx. D. References

Colophon

Index

9.4. Determining Whether a Statement Produced a Result Set

9.4.1. Problem

You just executed an SQL statement, but you’re not sure whether it produced a result set.

9.4.2. Solution

Check the column count in the metadata. If the count is zero, there is no result set.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial