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

javascript - three.js lot of meshes optimization -

smartface.io - Proper way to change color scheme for whole application -

Email notification in google apps script -