Member Avatar for vaish dhina

hai am using a stored procedure in mysql. in that stored procedure i have an temporary table. i want to check if that temporary table is already exist then drop it. else create it. reply your comments

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by Atli
Member Avatar for Atli

Hi.

You don't actually have to check if it exists, just use the IF EXISTS clause:

DROP TABLE IF EXISTS `myTable`;
CREATE TABLE `myTable`( ... );
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.