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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]