[OT] Mysql console parsing error: 1064

Hello there!

I know it sounds stupid, but when creating a table in a mysql (win32)
database, it won't let me create this "mytable". Here goes my
ER_PARSE_ERROR.

mysql> CREATE TABLE `mytable` (
-> `mytable_id` int(25) NOT NULL auto_increment,
-> `mytable_title` varchar(100) NOT NULL default '',
-> `mytable_dts` varchar(25) NOT NULL default '',
-> `mytable_caption` tinytext NOT NULL,
-> `mytable_full_body` text NOT NULL,
-> PRIMARY KEY (`mytable_id`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Testing Full
Text Search Functionality.';

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 'DEFAULT CHARSET=latin1 COMMENT='Testing Full Text Search
Functi

At the same time while inserting a large text as pasted to mysql
console, only couple of lines gets there.

INSERT INTO `mytable` VALUES (1, 'Mozilla Firefox is Cool!',
'1111813200', 'Mozilla Firefox blah blah .... more 500 words ');

I guess, the mysql console is limiting the size as input. Do I have to
edit that my.cnf file?

Could you please point where am I heading?


mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32)



TIA

--
Raqueeb Hassan
Bangladesh

Raqueeb Hassan wrote:

> Hello there!
>
> I know it sounds stupid, but when creating a table in a mysql (win32)
> database, it won't let me create this "mytable". Here goes my
> ER_PARSE_ERROR.
>
> mysql> CREATE TABLE `mytable` (
> -> `mytable_id` int(25) NOT NULL auto_increment,
> -> `mytable_title` varchar(100) NOT NULL default '',
> -> `mytable_dts` varchar(25) NOT NULL default '',
> -> `mytable_caption` tinytext NOT NULL,
> -> `mytable_full_body` text NOT NULL,
> -> PRIMARY KEY (`mytable_id`)
> -> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Testing Full
> Text Search Functionality.';
>
> 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 'DEFAULT CHARSET=latin1 COMMENT='Testing Full Text Search
> Functi
>
> At the same time while inserting a large text as pasted to mysql
> console, only couple of lines gets there.
>
> INSERT INTO `mytable` VALUES (1, 'Mozilla Firefox is Cool!',
> '1111813200', 'Mozilla Firefox blah blah .... more 500 words ');
>
> I guess, the mysql console is limiting the size as input. Do I have to
> edit that my.cnf file?
>
> Could you please point where am I heading?
>
>
> mysql> status
> --------------
> mysql Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32)

This sounds familiar. I have had issues pasting stuff into an
interactive mysql session under windows that seemed to have to do with
limits on the buffer size. The solution for me was to put the commands
into a text file and input-redirect from it, like this..

mysql databasename < file.txt

Chris
--
http://www.lowth.com - home of the p2pwall project.

http://www.lowth.com/rope - write you own iptables packet match modules
using a simple scripting language.

> mysql databasename < file.txt

That sounds logical. I'll do that. Do you have any suggestion on
increasing the buffer size? Cause, it won't change anything in "cmd"
properties.

TIA

--
Raqueeb Hassan
Bangladesh