Solved

drop table sql script

Posted on 2016-08-29
1
21 Views
Last Modified: 2016-08-29
I imported some data to my Mysql database and Mysql created new tables ( I forgot to give the table names )
Mysql automatically gave them name as TABLE 10 and TABLE 13,
I decided to delete the tables but I can not delete them because the sql script do not work since TABLE names sequential,
DROP TABLE TABLE 10,
how can I delete them?
0
Comment
Question by:Braveheartli
1 Comment
 
LVL 42

Accepted Solution

by:
zephyr_hex earned 500 total points
ID: 41774904
Put the names using reserved words in brackets, like so:

DROP TABLE [TABLE 10]

Open in new window

0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now