[OT] Mysql console parsing error: 1064

Discussion in 'Linux Networking' started by Raqueeb Hassan, Jun 10, 2005.

  1. 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, Jun 10, 2005
    #1
    1. Advertisements

  2. 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
     
    Wolfman's Brother, Jun 10, 2005
    #2
    1. Advertisements

  3. 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, Jun 11, 2005
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.