Error 1064 You Have An Error In Sql Syntax
Contents |
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET 1064 you have an error in your sql syntax US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING
Error 1064 42000 You Have An Error In Your Sql Syntax
CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated Hosting
Mysql Error 1064 You Have An Error In Your Sql Syntax
Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question User Submitted Articles Education Channels Android BoldGrid
Error 1064 42000 You Have An Error In Your Sql Syntax Check The Manual That
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 Website Design WordPress error 1064 mysql 42000 create table 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)Redirects (4)Restricting Bots (5)Search Engine Optimization (1)Secu
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) mysql posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss error 1064 mysql 42000 mysql import Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes error 1064 mysql 42000 you have an error in your sql syntax a minute: Sign up #1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version up vote 5 down vote favorite 1 I'm new to PHP and MySQL and ran into a http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 little trouble with a learning project I'm working on. Whenever I try to create a table CREATE TABLE transactions( id int NOT NULL AUTO_INCREMENT, location varchar(50) NOT NULL, description varchar(50) NOT NULL, category varchar(50) NOT NULL, amount double(10) NOT NULL, type varchar(6) NOT NULL, notes varchar(512), receipt int(10), ) I get the following error message: #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 http://stackoverflow.com/questions/21798464/1064-you-have-an-error-in-your-sql-syntax-check-the-manual-that-corresponds-t ') NOT NULL, type varchar(6) NOT NULL, notes varchar(512), receipt int(10), ' at line 6** Here is some info on what I'm working with •Server type: MySQL •Server version: 5.5.32 - MySQL Community Server (GPL •phpMyAdmin: 4.0.4.1, latest stable version: 4.1.7 I've spent a day knocking my head against the wall over this and now I think its time to ask for help.I was wondering if anyone can tell me what I'm doing wrong? mysql error-handling create-table share|improve this question edited Nov 17 '14 at 4:45 Ataboy Josef 1,128821 asked Feb 15 '14 at 13:54 tsjr63 26112 4 You have a comma at the end of the receipt line. –Gordon Linoff Feb 15 '14 at 13:57 add a comment| 5 Answers 5 active oldest votes up vote 5 down vote Remove the comma receipt int(10), And also AUTO INCREMENT should be a KEY double datatype also requires the precision of decimal places so right syntax is double(10,2) share|improve this answer edited Feb 15 '14 at 15:37 answered Feb 15 '14 at 13:58 G one 2,0391514 This answer is partly correct. It did not answer on what the error message returned. –Ravinder Reddy Feb 15 '14 at 14:32 @Ravinder: Thanks I missed one thing :) –G one Feb 15 '14 at 15:38 add a comment| up vote 0 down vote I see two problems: DOUBLE(10) precision definitions need a total number of digits, as well as a
here for a quick overview of the site Help Center Detailed answers to any questions you might have http://stackoverflow.com/questions/28445024/you-have-an-error-in-your-sql-syntax-check-the-manual-that-corresponds-to-your 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 posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just error 1064 like you, helping each other. Join them; it only takes a minute: Sign up 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 '-db' up vote 0 down vote favorite I'm trying to delete a database inside an RDS MySQL you have an instance and I get the following error . Can someone kindly help me resolve this issue [ec2-user@ip-10-10-1-14 ~]$ mysql -h wda2d.cmkridjjwpjp.ap-southeast-2.rds.amazonaws.com -u happy-p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6241 Server version: 5.6.19-log MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +-----------------------+ | Database | +-----------------------+ | information_schema | | database | | innodb | | mysql | | performance_schema | | richard-db | | word-db | | wordpress-db | +-----------------------+ 10 rows in set (0.00 sec) mysql> DROP DATABASE wordpress-db; 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 near '-