Mysql Delete Table Error 1064
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or error 1064 (42000): you have an error in your sql syntax; posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join 1064 mysql the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes
Mysql Error 1064 (42000)
a minute: Sign up unable to Drop a table in My Sql, You have an error in your SQL syntax 1064 up vote 0 down vote favorite i have just make a table as Customer 1, & now want to Drop
You Have An Error In Your Sql Syntax Check The Manual That Corresponds To Your Mysql Server Version
that, so used DROP TABLE Customer 1. but my sql shows, You have an error in your SQL syntax 1064. i tried multiple combinations of above command, but still unable to do so. Error - #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 mysql share|improve this question asked Mar 12 '14 at 12:33 user3410633 11 add a comment| #1064 - you have an error in your sql syntax; 1 Answer 1 active oldest votes up vote 1 down vote The issue here is likely to be the space in the table name. Have you tried the following? DROP TABLE `Customer 1`; share|improve this answer answered Mar 12 '14 at 12:40 user2254180 262116 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql or ask your own question. asked 2 years ago viewed 140 times active 2 years ago Related 1Unable create a table - ERROR 1064 (42000): You have an error in your SQL syntax-11064 - You have an error in your SQL syntax01064 (You have an error in your SQL syntax;1(#1064) - You have an error in your SQL syntax1#1064 - You have an error in your SQL syntax0#1064 - You have an error in your SQL syntax3ProgrammingError: 1064 (42000): You have an error in your SQL syntax; Unable to create table using foreign key0#1064 - You have an error in your SQL syntax; when creating table-11064; You have an error in your SQL syntax;01064 - You have an error in your SQL syntax? Hot Network Questions How does a Dual-Antenna WiFi rout
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack
Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near
Overflow the company Business Learn more about hiring developers or posting ads with us mysql server version for the right syntax to use near '' at line 1 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a error 1064 mysql 42000 mysqldump community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Unable to drop database due to illegal character up vote 8 down vote favorite How can http://stackoverflow.com/questions/22351700/unable-to-drop-a-table-in-my-sql-you-have-an-error-in-your-sql-syntax-1064 i drop a database containing the "-" symbol? mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | vms01 | | vms-0.1.0 | +--------------------+ 4 rows in set (0.00 sec) mysql> drop database vms-0.1.0; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n ear '-0.1.0' at line http://stackoverflow.com/questions/7618575/unable-to-drop-database-due-to-illegal-character 1 mysql> mysql sql-drop share|improve this question edited Mar 25 '14 at 16:24 Kara 3,16973147 asked Oct 1 '11 at 6:23 Oh Chin Boon 10.4k3191163 add a comment| 1 Answer 1 active oldest votes up vote 16 down vote accepted You can quote identifiers (for example table and column names) with backticks: drop database `vms-0.1.0` See the documentation for more details: Schema Object Names. The identifier quote character is the backtick ("`"): share|improve this answer answered Oct 1 '11 at 6:39 Mark Byers 449k8810941194 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql sql-drop or ask your own question. asked 5 years ago viewed 3360 times active 10 months ago Related 99How to drop unique in MySQL?71Force drop mysql bypassing foreign key constraint158MySQL DROP all tables, ignoring foreign keys2MySQL Dropping Tables15MySQL bulk drop table where table like?146How to remove all MySQL tables from the command-line without DROP database permissions?1How can I drop a
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 MEET US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question User Submitted Articles Education Channels error 1064 Android BoldGrid cPanel DokuWiki Drupal 7 Drupal 8 Everything Email Joomla 2.5 Joomla 3.1 K2 Magento 1.6 Mambo MediaWiki Moodle Movable Type OpenCart OpenCart 2.0 osCommerce PHP-Fusion PHP-Nuke phpBB phpList Premium Website Builder PrestaShop 1.5 PrestaShop 1.6 SMF Tiki Wiki VirtueMart 3 Web Hosting Manager you have an Website Design WordPress Tools & Resources Email Configuration Blacklist Check Visual DNS Lookup Quick Tagger Icon Sets Favicon Generator Bounce Back Parser What is my IP address? >>Website .htaccess (17)Adobe Flash (2)APIs (2)Backup and Restore (15)Billing (8)Browser Issues (2)Connecting to a Database (5)cPanel (26)cPanel Account Management (16)Cron Jobs (4)Cube Cart (2)Database Setup (5)Database Troubleshooting (6)Domain Management (2)Dreamweaver (12)Drush (2)eCommerce (7)Elasticsearch (4)Fantastico (4)File Management (16)File Manager (6)FTP (10)FTP Client Setup (21)General Server Setup / Management (15)Getting Started Guides (18)Ghost (3)Google Tools (21)How To (23)HTML (2)Image Editing (2)IP Addresses (3)iWeb (1)JavaScript (2)Joomla (10)Joomla 2.5 (36)Koken (11)Linux (27)Logaholic (5)Magento (2)Maintaining Your Website (1)Managing Files (7)Microsoft FrontPage (11)Microsoft Publisher (1)ModSecurity (7) MODx (3)New Customers (7)Open Classifieds (1)PCI Compliance (7)PHP (15)PHP Configuration (7)PHP Troubleshooting (6)phpBB (25)phpMyAdmin (10)Premium Website Builder (22)Prestashop (1)Protecting Files (5)Publishing Your Site (2)Python (1)Red