sql - Why is the comma messing up the insert -

Here is my query

  Set invoice invoice_number = '823 n 9823', value = '11, 768.00 ', code =' ret_4_business', created_act = '2010-09-27';  

But my price in my DB is 11, not 11768

How do I handle money in mysql? Field a decimal

  create tab 'invoice' (`id 'int (11) faucet auccrement,` invoice_number` varchar (255) collet utf 8_onexodi default faucet, `value` decimals (10, 0 ) Default call, `code 'varchar (255) COLLATE utf8_unicode_ci DEFAULT NULL,` created_at` datetime default ft, `updated_at` datetime default faucet, primary key (` id`)) engine = indoodb attribute = 2 default charge = utf 8 = Utf8_unicode_ci; Any non-numbered character will eliminate parsing and save only one part of the number. Remove the comma characters from the query  

.