incorrect column specifier for column
mysql, sql
Solution
`float(255)` is not valid when specifying the data type.
You can omit the value in the brackets, e.g. just have `float` by itself or specify the value in the brackets using something like `float(7,4)` (see this for information on what the values mean...you may need to customise these depending on what you're intending to store in the column)
Problem
I have: ``` create table `products` ( `id` int(11) not null auto_increment, `price` float(255), `weight` int(11), `sku` varchar(255), `stock_level` int(11), `image` mediumblob(1000), `search_engine_name` varchar(255), `description` varchar(1000), `url` varchar(255), `category` varchar(255), primary key (`id`) ); ``` MySql outputs: "Incorrect column specifier for column 'price' Why is this?