Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-pb-irap.sql 516 Bytes
Edit Raw Normal View History
9b4da83b   Alexandre   Version: 2.5.0.0 
1
2
3
4
5
6
7
 
use database;

update materiels set numero_laboratoire ="IRAP-2016-0021" where numero_laboratoire ="IRAP-16-0001";
update materiels set numero_laboratoire ="IRAP-2016-0022" where numero_laboratoire ="IRAP-16-0002";
update materiels set numero_laboratoire ="IRAP-2016-0023" where numero_laboratoire ="IRAP-16-0003";
update materiels set numero_laboratoire ="IRAP-2016-0024" where numero_laboratoire ="IRAP-16-0004";
update materiels set numero_laboratoire ="IRAP-2016-0025" where numero_laboratoire ="IRAP-16-0005";