Solved

drop table sql script

Posted on 2016-08-29
1
30 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 43

Accepted Solution

by:
zephyr_hex (Megan) 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AWS EC2 & RDS Instance 5 63
Incorrect definition of table mysql.proc 7 87
Wifi connection to laptop without router windows 10 11 48
Unwanted output from my query 5 40
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

756 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