Error No 1064
Contents |
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING sql error no 1064 CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides
Error 1064 (42000)
Dedicated Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a error 1064 mysqldump Question User Submitted Articles Education Channels Android BoldGrid cPanel DokuWiki Drupal 7 Drupal 8 Everything Email Joomla 2.5 Joomla 3.1 K2 Magento 1.6 Mambo MediaWiki Moodle Movable
Mysql Error 1064
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 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 error 1064 sqlstate 42000 (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)Secure Socket Layer (SSL) Tutorials (13)Security (12)Sending Email From Websites (2)Server Security (2)Server Usage (21)Slow Websites (7)Social Media (4)Software FAQs (11)Soho Web Builder (18)SSH and Root access (21)Statistics/Logging (12)Troubleshooting Comment Spam (3)Troubleshooting Hacked Websites (9)Web Host Manager (7)Website Error Numbers (4)Website Is Unavailable (3)Website Transfers (6)Website Troubleshooting (26)Welcome to AMP (22)What Is... (9)WooCommerce (5)WordPress (102)WordPress Development (12)Wordpress Plugins
here for a quick overview of the site Help
Error 1064 Sqlstate 42000 (er_parse_error)
Center Detailed answers to any questions you might have Meta
Error 1064 You Have An Error In Your Sql Syntax
Discuss the workings and policies of this site About Us Learn more about Stack error 1064 mysql workbench Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 x Dismiss 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 a minute: Sign up MySql Error no 1064 up vote -3 down vote favorite 1 My table format is CREATE http://stackoverflow.com/questions/19095213/mysql-error-no-1064 TABLE IF NOT EXISTS `clinicReg` ( `clinicRegId` varchar(10) NOT NULL, `clinicName` varchar(20) NOT NULL, `clinicAddress` varchar(500) NOT NULL, `clinicContactNo` int(20) NOT NULL, `clinicContactNO1` int(20) NOT NULL, `clinicMobileNo` int(20) NOT NULL, `clinicMobileNo1` int(20) NOT NULL, `clinicCatagories` varchar(50) NOT NULL, `clinicServices` varchar(500) NOT NULL, `clinicLogo` longblob NOT NULL, `ownerName` varchar(20) NOT NULL, `clinicEmailId` varchar(20) NOT NULL, `clinicEmailId1` varchar(20) NOT NULL, `loginTimeStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`clinicRegId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; my insert query is insert into 'harshal.clinicreg' (clinicRegId,clinicName, clinicAddress,clinicContactNo,clinicContactNO1, clinicMobileNo,clinicMobileNo1,clinicCatagories, clinicServices,clinicLogo,ownerName,clinicEmailId, clinicEmailId1,loginTimeStamp) Values ('ORCCli1','Smile Clinic','Mulund', 3456,544,234,567,'Gen','ABC', load_file(C:\Users\harshal420\Pictures\Camera Roll\Capture.jpg), 'Smile','abc@xyz.com','def@pqr.com', CURDATE()); It is giving me error 1064 can any one help me??? mysql share|improve this question edited Sep 30 '13 at 13:14 Mahmoud Gamal 56.7k1282109 asked Sep 30 '13 at 13:13 Er Pathak Harshal 475 5 Please post the complete error message. You should not be stor
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 http://stackoverflow.com/questions/5808750/mysql-query-giving-error-1064-any-ideas 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 like you, helping each other. Join them; it only takes a minute: Sign up MySQL query giving error 1064 - any ideas? up vote 5 down vote favorite This query: UPDATE jos_content SET fulltext='\r\n
\" some other text' WHERE id=3 gives: ERROR 1064 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 'fulltext='\r\n
\" some other text' WHERE id=3' at line 1 Anyone has any idea why? Thanks in adv. mysql mysql-error-1064 share|improve this question edited Sep 10 '12 at 5:36 Marc Alff 4,3551343 asked Apr 27 '11 at 18:27 ed22 109312 Is it a typo here that you are missing error no 1064 a ; at the end of the query? –Mahesh Apr 27 '11 at 18:29 trailing semicolons aren't required for single queries. Only if you were doing multiple queries would you need ; to separate them, and MySQL doesn't allow multiple queries in a single query call. –Marc B Apr 27 '11 at 18:31 @Raj, please do not edit the code. If there's an error in there that relates to the question, you've just obscured the error and confused everybody –Johan Apr 27 '11 at 18:35 1 @Johan Please check the edit history before you post comments. My edit was to format the code, not change it. You were the one to actually add a new line and edit the code. –Raj More Apr 27 '11 at 19:45 @ray did look at the orig post, but must have misread sorry sorry 1000x sorry –Johan Apr 27 '11 at 20:29 | show 1 more comment 1 Answer 1 active oldest votes up vote 11 down vote accepted fulltext is a reserved word. http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html rename your field or put it within backticks '`' (alt + 96) like so: UPDATE jos_content SET `fulltext`='\r\n
\" some other text' WHERE id=3 share|improve this answer edited Apr 27 '11 at 18:44 Johan 48.9k16105201 answered Apr 27 '11 at 18:28 Nicola Cossu 26.6k106480 Alt+96 depends on the keyboard layout