Have An Error In Your Sql Syntax Near Character_set_results
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 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
Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near
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 error 1064 (42000) 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 questi
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
Mysql Server Version For The Right Syntax To Use Near '' At Line 1
this site About Us Learn more about Stack Overflow the company Business 1064 error in mysql Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask mariadb server version for the right syntax 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 http://stackoverflow.com/questions/16449996/syntax-error-on-import-mysql up SQL - #1064 - You have an error in your SQL syntax; up vote -3 down vote favorite I exported my database, because I changing server. Now I want to import my SQL Dump, but I getting error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax http://stackoverflow.com/questions/38075695/sql-1064-you-have-an-error-in-your-sql-syntax to use near 'phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1 Here is begin of my dump: -- phpMyAdmin SQL Dump -- version 4.0.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Czas wygenerowania: 28 Cze 2016, 12:42 -- Wersja serwera: 5.5.32-cll -- Wersja 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 */; mysql phpmyadmin mariadb share|improve this question edited Jun 28 at 12:04 Panagiotis Kanavos 29.4k34267 asked Jun 28 at 12:02 Vertisan 879 SQL Server doesn't have a dump command. Please use the proper tags. –Panagiotis Kanavos Jun 28 at 12:04 The error message implies that -- does not denote a comment which is weird because mariadb.com/kb/en/mariadb/comment-syntax says it is and the export is the one that put it there... –Jerry Jeremiah Jun 28 at 12:21 show variables where variable_name like '%version%'; and see what is allowed for each –Drew Jun 28 at 12:26 What is the command that used that dump file and got that error? –Rick
during import: #1064 - You have an error in your SQL syntax Posted by: ChrisUCLA (---.socal.res.rr.com)Date: August 11, 2013 12:43AMHi, I took my last site off of godaddy to serve on my wamp with http://forum.wampserver.com/read.php?2,116983,117063 2 working wordpress sites. (Apache 2.4.2, php 5.4.3, MySQL 5.5.24)WHile importing the sql database, I got the following error (BEGINNING OF ERROR) :ErrorSQL query:CREATE TABLE wp_netblog_bibitem (itemID INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,fieldID SMALLINT( 5 ) UNSIGNED NOT NULL ,fieldValue VARCHAR( 255 ) NOT NULL ,usage INT( 10 ) UNSIGNED NOT NULL DEFAULT error in '1',PRIMARY KEY ( itemID )) ENGINE = M-- MySQL dump 10.11---- Host: localhost Database: fra1301704504244-- -------------------------------------------------------- Server version 5.0.96-log/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;MySQL said: Documentation#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 @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at have an error line 13(END OF ERROR) and then when trying to acces the wp-admin page, it directed to a repair page and gave me these errors and said paste them in the forum:wp_users: Table 'franklinian.wp_users' doesn't existwp_usermeta: Table 'franklinian.wp_usermeta' doesn't existwp_posts: Table 'franklinian.wp_posts' doesn't existwp_options: Table 'franklinian.wp_options' doesn't existwp_postmeta: Table 'franklinian.wp_postmeta' doesn't existwp_terms: Table 'franklinian.wp_terms' doesn't existwp_term_taxonomy: Table 'franklinian.wp_term_taxonomy' doesn't existwp_term_relationships: Table 'franklinian.wp_term_relationships' doesn't existIm totally lost as what to do with this.Options:Reply•QuoteRe: SQL Problems during import: #1064 - You have an error in your SQL syntax Posted by: RiggsFolly (---.as13285.net)Date: August 12, 2013 10:23AMHere is your error:ENGINE = M-- MySQL dump 10.11I assume you are using the MyISAM engine so change 'M-- MySQL dump 10.11' to 'Engine = MyISAM'Options:Reply•QuoteRe: SQL Problems during import: #1064 - You have an error in your SQL syntax Posted by: ChrisUCLA (---.socal.res.rr.com)Date: August 12, 2013 10:12PMIm way lost.. Ok, the sql backup file came from godaddy, and I tried to import that file into my wamp, (Apache 2.4.2,