Error In Your Sql Syntax Near Character_set_results Null At Line

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 error 1064 (42000): you have an error in your sql syntax; site About Us Learn more about Stack Overflow the company Business Learn more

#1064 - You Have An Error In Your Sql Syntax;

about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x you have an error in your sql syntax check the manual that corresponds to your mysql server version 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 syntax error mysql error 1064 (42000) on import mysql up vote 5 down vote favorite this 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

Mysql Server Version For The Right Syntax To Use Near '' At Line 1

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: `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 quest

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 check the manual that corresponds to your mysql server version for the right syntax to use near Learn more about Stack Overflow the company Business Learn more about hiring developers 1064 error in mysql or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack

Error 1064 Mysql 42000 Mysqldump

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 Error 1064 - You have an error http://stackoverflow.com/questions/16449996/syntax-error-on-import-mysql in your SQL syntax up vote 0 down vote favorite I have this kind of error after i import a sql backup file: 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 '' at line 1 My sql file begins as follow: -- phpMyAdmin SQL Dump -- version 4.0.5 http://stackoverflow.com/questions/18938123/error-1064-you-have-an-error-in-your-sql-syntax -- http://www.phpmyadmin.net -- -- Host: localhost -- Generato il: Set 21, 2013 alle 21:03 -- Versione del server: 5.5.32-cll-lve -- Versione PHP: 5.3.17 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 */; -- -- Database: `webedili_wp879` -- -- Struttura della tabella `wp_commentmeta` -- CREATE TABLE IF NOT EXISTS `wp_commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=379 ; -- -- Dump dei dati per la tabella `wp_commentmeta` -- INSERT INTO `wp_commentmeta` (`meta_id`, `comment_id`, `meta_key`, `meta_value`) VALUES (322, 255, 'is_customer_note', '0'), (323, 256, 'is_customer_note', '0'), (324, 257, 'is_customer_note', '0'), (325, 258, 'is_customer_note', '0'); -- -- Struttura della tabella `wp_comments` -- CREATE TABLE IF NOT EXISTS `wp_comments` ( `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0', `comment_author` tinytext NOT NULL, `comment_author_email` varchar(100) NOT NULL DEFAULT '', `comment_author_url` varchar(200) NOT NULL DEFAULT '', `comment_author_IP` varchar(100) NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content`

Services [FAQs] [Adv Search] Forum General Questions General Questions Why Does this SQL not work? If this is https://www.zen-cart.com/showthread.php?181112-Why-Does-this-SQL-not-work your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link http://piwigo.org/forum/viewtopic.php?id=25236 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 error in 1 to 6 of 6 Thread Tools Show Printable Version Subscribe to this Thread… Search 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 error in your Why Does this SQL not work? Hi, I'm dropping my 'reviews' table and trying to upload a new version. However I keep 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 defa

Tags Timeline User list Rules Search You are not logged in. (Register / Login) Announcement [2016-07-08] Piwigo 2.8.2 [2016-05-04] Piwigo 2.8.1 [2016-04-29] Contribute to Demo [2016-03-08] Piwigo 2.8 [2016-02-01] Piwigo 2.8.0RC2 Pages: 1 Post reply Forum Index»How-To and Troubleshooting»Database error on migrating from Bluehost to Godaddy #12015-03-01 17:10:13 Mandraek Member Registered: 2015-03-01 Posts: 6 Database error on migrating from Bluehost to Godaddy Tags: [error, GoDaddy, migration, sql] Hello/Hi/Greetings,Have setup a fresh install on godaddy that works, deleted tables in sql and imported tables from previous installation on bluehost but get error message, any help much appreciated:ErrorSQL query: