From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Tue Feb 15 2005 - 03:12:06 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello.

> I just installed a new software package that included
> a MySQL upgrade.

What exact version of MySQL do you use?

> Also, I noticed that when I create tables, I no longer
> have a choice for InnoDB, so I've been choosing
> MyISAM. If I leave it at default, what kind of table
> would I get?

In what way do you create you tables?

> version for the right syntax to use near 'collate
> latin1_general_ci NOT NULL default '',
> `IDRealm` varc

Please, send a piece of your file where the error occurs.

David Blomstrom <david_blomstromyahoo.com> wrote:
> I just installed a new software package that included
> a MySQL upgrade. Everything was working fine until I
> tried to import one of my tables to my online database
> and got 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 'collate
> latin1_general_ci NOT NULL default '',
> `IDRealm` varc
>
> What does this mean, and what's the solution?
>
> Also, I noticed that when I create tables, I no longer
> have a choice for InnoDB, so I've been choosing
> MyISAM. If I leave it at default, what kind of table
> would I get?
>
> Actually, I'm leaning towards MyISAM anyway. I thought
> InnoDB were generally considered superior, but when my
> computer crashed, I lost most of my InnoDB tables but
> none of my MyISAM tables.
>
> Thanks.
>
>
>
> __________________________________
> Do you Yahoo!?
> The all-new My Yahoo! - What will yours do?
> http://my.yahoo.com
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]