An Error In Your Sql Syntax Near Character_set_results Null
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have error 1064 (42000): you have an error in your sql syntax; Meta Discuss the workings and policies of this site About Us Learn
#1064 - You Have An Error In Your Sql Syntax;
more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us you have an error in your sql syntax check the manual that corresponds to your mysql server version 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 mysql error 1064 (42000) you, helping each other. Join them; it only takes a minute: Sign up PHP MySQL: You have an error in your SQL syntax up vote 1 down vote favorite Can someone help why this sql database gave me error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
Check The Manual That Corresponds To Your Mysql Server Version For The Right Syntax To Use Near
version for the right syntax to use near 'SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */' when i import this sql to my server? -- phpMyAdmin SQL Dump -- version 3.4.7.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 11, 2012 at 01:22 AM -- Server version: 5.1.56 -- PHP Version: 5.2.9 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: `testdb` -- -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE IF NOT EXISTS `members` ( `id` int(11) NOT NULL, `username` varchar(40) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `salary` int(11), `student_year` int(11), PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `username`, `name`, `salary`, `student_year`) VALUES (1, '11John', 'John Smith', 12000, NULL), /*!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 */; mysql sql phpmyadmin share|improve this question edited Nov 15 '15
here for a quick overview of the site Help Center Detailed answers to any mysql server version for the right syntax to use near '' at line 1 questions you might have Meta Discuss the workings and policies of 1064 error in mysql this site About Us Learn more about Stack Overflow the company Business Learn more about hiring
Error 1064 Mysql 42000 Mysqldump
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 http://stackoverflow.com/questions/33725656/php-mysql-you-have-an-error-in-your-sql-syntax 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 in your SQL syntax up vote 0 down vote favorite I have this kind of error after i import a sql backup file: 1064 http://stackoverflow.com/questions/18938123/error-1064-you-have-an-error-in-your-sql-syntax - 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://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_comme
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Connector/ODBC :: ODBC - Character_Set_Results New Topic Advanced Search ODBC - http://forums.mysql.com/read.php?37,238798,238798 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 http://www.simplemachines.org/community/index.php?topic=56032.0 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: -------------------------- error in 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: an error in 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 Manua
This topic This board Entire Site Community Modifications Themes Wiki Mantis Select language: Albanian Arabic Bulgarian Catalan Chinese Simplified Chinese Traditional Croatian Czech Informal Czech Danish Dutch English British English Esperanto Estonian Finnish French Galician German Informal German Greek Hebrew Hungarian Indonesian Italian Japanese Kurdish Kurmanji Lithuanian Macedonian Malay Norwegian Persian Polish Portuguese Brazilian Portuguese Pt Romanian Russian Serbian Cyrillic Serbian Latin Slovak Slovenian Spanish Es Spanish Latin Swedish Thai Turkish Ukrainian Urdu Vietnamese News: Add us to your circles on Google+. Home Help Search Login Register Advertisement: Simple Machines Community Forum » SMF Support » Install and Upgrade Help » Topic: SQL syntax error « previous next » Print Pages: [1] Go Down Author Topic: SQL syntax error (Read 2515 times) touficjohn Semi-Newbie Posts: 17 SQL syntax error « on: November 09, 2005, 07:42:12 PM » Ok my knowledge of SQL is litterally like 0...Basically Im moving my forums from one server to another, i made a backup of all the html files no prob, but when it came to restoring the dump file, thru phpmyadmin:SQL, browse upload wait and it should just bloody work.No.....PhPMyAdmin returns this for some reason and i cant figure it out for the life of me!Code: [Select]Error
SQL query:
CREATE TABLE `smf_attachments` (
`ID_ATTACH` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`ID_MSG` int( 10 ) unsigned NOT NULL default '0',
`ID_MEMBER` int( 10 ) unsigned NOT NULL default '0',
`filename` tinytext NOT NULL ,
`size` int( 10 ) unsigned NOT NULL default '0',
`downloads` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `ID_ATTACH` ) ,
UNIQUE KEY `ID_MEMBER` ( `ID_MEMBER` , `ID_ATTACH` ) ,
KEY `ID_MSG` ( `ID_MSG` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
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 'DEFAULT CHARSET=latin1' at line 11
[ Back ] Logged Compuart SMF Friend SMF Hero Posts: 5,774 Gender: ZĂ©eeeal Re: SQL syntax error « Reply #1 on: November 09, 2005, 08:03:15 PM » It might be a version incompatibility (that is: the version from which you dumped the tables is higher than the version of MySQL