MySQL Table Adding Double Value

Question

I am trying to create a table on mySQL console.

CREATE TABLE TRY (Essn int(10), Pno int(2), Hours DOUBLE(40,0));

When I try to add something to table:

INSERT INTO TRY ('123456789','1','32,5');

I got an error about syntax. I couldn't find the problem. Can anyone help?

Answer 1

Get rid of the quote, replace 32,5 with 32.5, and add VALUES keyword should work:

INSERT INTO TRY VALUES (123456789,1,32.5);

You might also want to change your double field definition for allowing more decimal numbers in Hours field:

CREATE TABLE TRY (Essn int(10), Pno int(2), Hours DOUBLE(40,2));

refer to MySQL's approximate value section for more details

“(M,D)” means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. For example, a column defined as FLOAT(7,4) will look like -999.9999 when displayed. MySQL performs rounding when storing values, so if you insert 999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001.