simple decimal problem

[crazycoder]

I have this code to create the database:

drop database expenses2006;
create database expenses2006;
use expenses2006;
create table January (                 <-- line 5
	id int not null auto_increment,
	Date varchar(5),
	Description varchar(50),
	Office Exp. decimal(),
	Dues/Public decimal(),
	Business Lunch decimal(),
	Conf./Cont. ED. decimal(),
	Supplies for Prod. decimal(),
	Small Equip. decimal(),
	Prom./Adv. decimal(),
	Travel decimal(),
	Freight decimal(),
	Photo decimal(),
	Post decimal(),
	primary key(id)
);

I have it make an identical table for every month of the year. It gives me messages saying something is wrong with the 'decimal' in line five. I have tried decimal, decimal(3,2), and as you can see decimal().

[NogDog]

I've never worked with a database system that allowed column names with slashes, space, or periods. Could that be the problem?

[crazycoder]

I thought that might be the problem, but the errors from the console point elsewhere. I'll try it though.

[NogDog]

Error messages are notorious for being misleading.

[chazzy]

you have the following errors in your create table:

error: column names can't contain spaces
warning: invalid character ("/")
warning: invalid character (".")
error: invalid column type decimal().

decimal needs at least 1 argument, it seems.
http://dev.mysql.com/doc/refman/5.0/...ric-types.html

[crazycoder]

Thanks! I just replaced all the ' ' with underscores.