Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from articulos where descripcion LIKE '%108957%';
- select * from vendedores where ape_vendedor LIKE '%108957%';
- select * from clientes where ape_cliente LIKE '%108957%';
- select * from barrios
- insert into articulos (descripcion,stock_minimo, pre_unitario, observaciones) values ('108957-Lápices Color Largos *12 u', 0, 21.5, '')
- insert into articulos (descripcion,stock_minimo, pre_unitario, observaciones) values ('108957-Conjunto Geométrico', 0, 8.3, 'Regla - Escuadra - Transportador')
- insert into articulos (descripcion,stock_minimo, pre_unitario, observaciones) values ('108957-Respuesto Gloria Rayado', 120, 26.3, '400 Hojas')
- insert into articulos (descripcion,stock_minimo, pre_unitario, observaciones) values ('108957-Repuesto Rivadavia', 0, 65.9, '400 Hojas Margen Reforzado')
- insert into vendedores (ape_vendedor, nom_vendedor, calle, altura, nro_tel, [e-mail], fec_nac, cod_barrio) values ('108957-Monti', 'Juan', 'Alto Aguirre', 1245, 4522122, null, null, 5)
- insert into vendedores (ape_vendedor, nom_vendedor, calle, altura, nro_tel, [e-mail], fec_nac, cod_barrio) values ('108957-Sena', 'Rosa', 'Av. Velez Sarsfield', 25, null, 'rsena@hotmail.com', '15/5/1968', 1)
- insert into clientes (ape_cliente, nom_cliente, calle, altura, nro_tel, [e-mail], cod_barrio) values ('108957-Bustos', 'Jorge', 'Av San Martin', 485, 420659, null, 4)
- insert into clientes (ape_cliente, nom_cliente, calle, altura, nro_tel, [e-mail], cod_barrio) values ('108957-Paulich', 'Mirtha', 'Av Bach', 322, 420251, 'mapaulich@gmail.com', 1)
- insert into clientes (ape_cliente, nom_cliente, calle, altura, nro_tel, [e-mail], cod_barrio) values ('108957-Hoffman', 'Erwin', 'Pedrano', 355, 458963, 'ehoffmanh@gmail.com', 2)
- update articulos set descripcion = '108957-Conjunto Geométrico de Plástico' where cod_articulo = 237;
- update articulos set stock_minimo = 100, pre_unitario = 17.20, observaciones = 'Caja con motivos de Disney' where cod_articulo = 236
- update articulos set descripcion = '108957-Repuesto Rivadavia Cuadriculado', observaciones = '48 Hojas' where cod_articulo = 239
- update vendedores set fec_nac = '10/10/1970', [e-mail] = 'emonti@hotmail.com' where cod_vendedor = 84
- update vendedores set nro_tel = 4522221, altura = 125, cod_barrio = 1 where cod_vendedor = 85
- update articulos set pre_unitario = pre_unitario*1.15 where pre_unitario < 20 and descripcion = '%108957'
- update articulos set pre_unitario = pre_unitario*1.1 where pre_unitario between 20 and 30 and descripcion like '%108957%'
- delete articulos where descripcion = '108957-Respuesto Gloria Rayado'
- delete vendedores where ape_vendedor = '108957-Sena'
- delete clientes where ape_cliente = '108957-Bustos'
- delete clientes where ape_cliente = '108957-Hoffman'
- delete articulos where descripcion like '%108957%'
- delete vendedores where ape_vendedor like '%108957%'
- delete clientes where ape_cliente like '%108957%'
Add Comment
Please, Sign In to add comment