Finally got the basic mysql installation solved and is up and running.
Now I'm trying to figure out how to work in the workbench, which makes life
a lot simpler.
Creating a new database is a piece of cake.
Creating a new table winds up with a syntax error. Error 1064 syntax error.
Don't blame me dufus, you're the one creating the required syntax. All I
did was supply a name.

CREATE TABLE `a1960`.`asongs1960` (

)

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci;

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 CHARACTER SET = utf8

COLLATE = utf8_general_ci' at line 2

SQL Statement:

CREATE TABLE `a1960`.`asongs1960` (

)

DEFAULT CHARACTER SET = utf8

COLLATE = utf8_general_ci


Ok so how does this get corrected?
BTW, the manual has no information on this.

richard:

Well, that's the problem. Tables with just a name aren't very useful.
You want fields in tables.

See? No fields.


--
Erick

On 20 Feb 2011 07:26:02 GMT, Erick T. Barkhuis wrote:

Thanks. You'd think they'd just come right out and say "no fields present"
or something.
Once I put in a couple of fields, things work better. Now I'm off to
conquer and rule the world!

richard:

Well, in the past 24 hours, you've managed to blame quite a number of
developers for their software.
Perhaps you're right...they may have done a terrible job alltogether.
But on the other hand, it wouldn't hurt to understand, that installing
and using MySQL isn't the same thing as firing up MS Access. You've got
to do some reading, first.

Really? How is your knowledge of data modeling?
[Without some, the result may be disappointing. But you can still have
fun experimenting with MySQL]

--
Erick