simple decimal problem
I have this code to create the database:
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().
drop database expenses2006;
create database expenses2006;
create table January ( <-- line 5
id int not null auto_increment,
Office Exp. decimal(),
Business Lunch decimal(),
Conf./Cont. ED. decimal(),
Supplies for Prod. decimal(),
Small Equip. decimal(),
Last edited by crazycoder; 03-11-2006 at 06:25 PM.
I've never worked with a database system that allowed column names with slashes, space, or periods. Could that be the problem?
I thought that might be the problem, but the errors from the console point elsewhere. I'll try it though.
Error messages are notorious for being misleading.
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.
Thanks! I just replaced all the ' ' with underscores.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)