mysql create table with decimal not null -


this blows @ amount decimal(3,2) not null, line

 create table if not exists nutrition (     foodid int not null,     measurmentid not null,     amount decimal(3,2) not null,     calories int not null,     carbs decimal(3,2) not null,     fat decimal(3,2) not null,     protein decimal(3,2) not null,     sodium decimal(3,2) not null,     fiber decimal(3,2) not null, ); 

measurementid not null has no type definition.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -