Error In Your Sql Syntax Near Character_set_results Null At
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 error 1064 (42000): you have an error in your sql syntax; about Stack Overflow the company Business Learn more about hiring developers or posting ads
#1064 - You Have An Error In Your Sql Syntax;
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack you have an error in your sql syntax check the manual that corresponds to your mysql server version Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up syntax error on import mysql up vote 5 down vote favorite this
Mysql Error 1064 (42000)
is my sql i want to use in my database but i have a problem with that: -- phpMyAdmin SQL Dump -- version 3.5.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 27, 2012 at 07:12 PM -- Server version: 5.5.19 -- PHP Version: 5.3.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 check the manual that corresponds to your mysql server version for the right syntax to use near */; -- -- Database: `lol` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(48) CHARACTER SET utf8 NOT NULL, `password` varchar(48) CHARACTER SET utf8 NOT NULL, `email` varchar(255) CHARACTER SET utf8 NOT NULL, `sid` varchar(32) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1020 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`, `email`, `sid`) VALUES (1001, 'Larry', 'md5passhere', ' @', ''), /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; when i want to import that into database i have this 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 'SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */' at line 8 i don't know how to fix that with search on web i cannot find useful thing about my problem so you think how i can resolve that problem? mysql syntax share|improve this question asked May 8 '13 at 20:52 user1973003 50227 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted At the end of you IN
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET
Mysql Server Version For The Right Syntax To Use Near '' At Line 1
US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING
1064 Error In Mysql
CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated Hosting Reseller error 1064 mysql 42000 mysqldump Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question User Submitted Articles Education Channels Android BoldGrid http://stackoverflow.com/questions/16449996/syntax-error-on-import-mysql 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 http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 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)Secure Socket
Services [FAQs] [Adv Search] Forum General Questions General Questions Why Does this SQL not work? If this is your first visit, be sure to check https://www.zen-cart.com/showthread.php?181112-Why-Does-this-SQL-not-work out the FAQ by clicking the link above. You may have to http://forums.mysql.com/read.php?37,238798,238798 register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Thread: Why Does this SQL not work? Results 1 to 6 of 6 Thread Tools Show Printable Version Subscribe to this Thread… Search error in Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 7 Jun 2011,10:40 AM #1 plymgary1 View Profile View Forum Posts View Blog Entries View Articles Zen Follower Join Date Feb 2009 Posts 124 Plugin Contributions0 Why Does this SQL not work? Hi, I'm dropping my 'reviews' table and trying to upload a new version. However I keep error in your getting the 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 '2011-02-13 15:17:05', NULL, 19, 1),(80, 180, NULL, 'M', 5, '2011-02-13 15:18:05'' at line 71 This is what I'm trying to insert: Code: -- phpMyAdmin SQL Dump -- version 2.11.11.3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 01, 2011 at 04:20 PM -- Server version: 4.1.22 -- PHP Version: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `xkwies_handcrafteduk` -- -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE IF NOT EXISTS `reviews` ( `reviews_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `customers_id` int(11) default NULL, `customers_name` varchar(64) NOT NULL default '', `reviews_rating` int(1) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `reviews_read` int(5) NOT NULL default '0', `status` int(1) NOT NULL default '1', PRIMARY KEY (`reviews_id`), KEY `idx_products_id_zen` (`products_id`), KEY `idx_customers_id_zen` (`customers_id`), KEY `idx_status_zen` (`status`), KEY `idx_date_added_zen` (`date_added`) ) ENGINE=MyISAM DEFAULT
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Connector/ODBC :: ODBC - Character_Set_Results New Topic Advanced Search ODBC - Character_Set_Results Posted by: Jimmy Hendrix () Date: December 16, 2008 09:18AM Hello, I have a MySQL database 3.23.58 installed on a web server. So far, I've been using ODBC Connector 3.51, everything worked fine. I've tried to install ODBC Connector 5.1, but each time I test the Connection, I get the following error: -------------------------- Conection Failed: [HY000][MySQL][ODBC 5.1 Driver] You have an error in your SQL syntax near 'character_set_results = NULL' at line 1 -------------------------- Would somebody now what needs to be done to correct the problem? Thanks for your answers. Cheers Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ODBC - Character_Set_Results Jimmy Hendrix 12/16/2008 09:18AM Re: ODBC - Character_Set_Results Jess Balint 12/16/2008 08:44PM Re: ODBC - Character_Set_Results John Kolvereid 01/01/2009 12:33PM Re: ODBC - Character_Set_Results Jess Balint 01/07/2009 10:24AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides MySQL Cluster Legal Legal Policies Your Privacy Rights Terms of Use Trademark Policy Contributor Agreement © 2015, Or