give id in decimal sql : I have a table name content_details and want to print id in decimal like this:

<pre>id     contents
1.1    vegetarian
1.2    non-vegetarian</pre>

I have used this query to <pre>
`ALTER TABLE content_details
ADD COLUMN id decimal(4,2)`

then used this to save data in column <br>
`ALTER TABLE content_details
ADD id_sub = 1.1000
WHERE contents_details= 'vegetarian'`

But getting error
