From: David Blomstrom (david_blomstromyahoo.com)
Date: Mon Feb 14 2005 - 15:11:14 CST

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

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

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

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