erro:0 row(s) affected, 1 warning(s): 1292 Incorrect date value: '2002' for column 'datap' at row 1 Rows matched: 0 Changed: 0 Warnings: 1
CREATE DATABASE controle_compras;
Use controle_compras;
CREATE TABLE Compras (id int auto_increment primary key,
valor double,
datap date,
recebido boolean,
observacoes varchar(256));
select * from compras;
update Compras set observacoes = 'preparando natal' where datap = '2010-12-20';
update Compras set valor = valor+10 where datap >= '2009-06-01';
update Compras set observacoes = 'entregue antes 2011',recebido = True
where datap between '2009-07-01' and 2010-07-01;
desc compras observacoes;
drop table compras;