Table values being truncated

Question

I made code in the declaration part of the real number that word balance that it will receive a number with 6 digits and 2 two decimal places after the comma, except that all values that I enter are truncated, how to solve ?

create database uri
default character set utf8
default collate utf8_general_ci;

use uri;

create table pessoas(

 id int not null auto_increment,
 nome varchar(30),
 rua varchar(30),
 cidade varchar(30),
 regiao char(3),
 saldo decimal(6,2),
 primary key(id)

) default charset utf8;

insert into pessoas values
('1','Pedro Augusto da Rocha','Rua Pedro Carlos Hoffman','Porto Alegre','RS','700,00'),
('2','Antonio Carlos Mamel','Av. Pinheiros','Belo Horizonte','MG','3500,50'),
('3','Luiza Augusta Mhor','Rua Salto Grande','Niteroi','RJ','4000,00'),
('4','Jane Ester','Av 7 de setembro','Erechim','RS','800,00'),
('5','Marcos Antônio dos Santos','Av Farrapos','Porto Alegre','RS','4250,25');
SELECT nome FROM pessoas WHERE regiao = 'RS';

Answer 1

You must use point(.) and not comma(,) to separate the decimal, mysql does not use the Brazilian standard. http://sqlfiddle.com/#! 9/21d68c/2

Answer 2

Change "," to "." because the field is of the decimal type (only accepts number and the separator to decimal places is the point)

Example:

insert into pessoas values
('1','Pedro Augusto da Rocha','Rua Pedro Carlos Hoffman','Porto Alegre','RS','700.00')