alter table COMPRAS modify column forma_pagt text not null;
| 36 | 98.7 | 2011-02-07 | 1 | LANCHONETE | boleto | | 37 | 213.5 | 2011-09-25 | 0 | ROUPAS | boleto | | 38 | 1245.2 | 2011-10-17 | 0 | ROUPAS | boleto | | 39 | 23.78 | 2011-12-18 | 1 | LANCHONETE DO ZÉ | boleto | | 40 | 576.12 | 2011-09-13 | 1 | SAPATOS | boleto | | 41 | 12.34 | 2011-07-19 | 0 | CANETAS | boleto | | 42 | 87.43 | 2011-05-10 | 0 | GRAVATA | boleto | | 43 | 887.66 | 2011-02-02 | 1 | PRESENTE PARA O FILHAO | boleto | | 45 | 50 | 2018-11-15 | 1 | feriado | NULL | +----+-------------------+------------+----------+-------------------------+------------+ 43 rows in set (0.00 sec)
mysql> alter table COMPRAS modify column forma_pagt text not null; ERROR 1265 (01000): Data truncated for column 'forma_pagt' at row 43 mysql>
