www.mysql.com provides piles of excellent resources. If you need a client for connecting to your mysql server, I recommend MyControlCenter (MyCC). Its a graphical MySQL client and works well for simple databases (and maybe bigger ones too, but I haven't used it for databases over 15M😎. Anyhow, that will get you connected if that's what you're asking. It also has a table editor for creating new tables which you can toy around with to get the table you want.
MySQL also has excellent SQL documentation if you prefer to do everything from SQL (I usually use the text-based client). The query for creating tables is, ironically enough, "CREATE TABLE". If you look that up, you can find help on the SQL below:
CREATE TABLE fateam (
id INT auto_increment,
title VARCHAR(40) not null,
body TEXT not null,
time DATETIME not null,
postby VARCHAR(40) no null,
PRIMARY KEY(id)
)
Just a couple comments on the way I did things here:
id is the unique key. When inserting data, you omit that field or provide 0 and it will be assigned the next unassigned value (so the lowest possible is 1).
time is a datetime field which can be a little tricky to get used to. Read the documentation carefully. You may decide that you would prefer to use separate fields for date and time or that you would rather use strings (often very easy if you just want to read the timestamp and nothing complex) or integers if you just want to store the unix timestamp. If the field is a mysql date/time type (DATETIME is one of many date type), then you can use mysql's NOW() function when inserting data to have mysql set the current time like
INSERT INTO fateam(time) VALUES (NOW());
Anyhow, I've gotten a little long-winded but please let me know if there's anything you want me to ad or clarify.
