ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'auto increment primary key, valor double, data date, observacoes varchar(255), r' at line 1
o comando utilizado foi esse. mysql> create table compras (id int auto increment primary key, valor double, data date, observacoes varchar(255), recebido boolean);
