Advertisement
Guest User

Untitled

a guest
Feb 17th, 2020
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.34 KB | None | 0 0
  1. COPY obra(id,titulo)
  2. from 'C:\tmp\obra.csv' DELIMITER ',' CSV HEADER;
  3.  
  4. COPY cliente(id,nombre,fecha_nto)
  5. from 'C:\tmp\cliente.csv' DELIMITER ',' CSV HEADER;
  6.  
  7. COPY encargado(codigo,nombre)
  8. from 'C:\tmp\encargado.csv' DELIMITER ',' CSV HEADER;
  9.  
  10. COPY director(id,nombre)
  11. from 'C:\tmp\director.csv' DELIMITER ',' CSV HEADER;
  12.  
  13. COPY tarifa(id,valor,fecha_inicial,fecha_final)
  14. from 'C:\tmp\tarifa.csv' DELIMITER ',' CSV HEADER;
  15.  
  16. COPY papel(codigo,nombre)
  17. from 'C:\tmp\papel.csv' DELIMITER ',' CSV HEADER;
  18.  
  19. COPY actor(id,nombre,fecha_nto)
  20. from 'C:\tmp\actor.csv' DELIMITER ',' CSV HEADER;
  21.  
  22. COPY teatro(id,nombre,direccion,codigo_encargado)
  23. from 'C:\tmp\teatro.csv' DELIMITER ',' CSV HEADER;
  24.  
  25. COPY telefono_actor(id_actor,telefono)
  26. from 'C:\tmp\telefono_actor.csv' DELIMITER ',' CSV HEADER;
  27.  
  28. COPY cliente_tarifa(id_tarifa,id_cliente,fecha_venta)
  29. from 'C:\tmp\cliente_tarifa.csv' DELIMITER ',' CSV HEADER;
  30.  
  31. COPY obra_director(id_obra,id_director)
  32. from 'C:\tmp\obra_director.csv' DELIMITER ',' CSV HEADER;
  33.  
  34. COPY telefono_director(id_director,telefono)
  35. from 'C:\tmp\telefono_director.csv' DELIMITER ',' CSV HEADER;
  36.  
  37. COPY obra_actor(id_obra,id_actor,codigo_papel)
  38. from 'C:\tmp\obra_actor.csv' DELIMITER ',' CSV HEADER;
  39.  
  40. COPY boleta(id,id_cliente,id_teatro,id_obra,fecha,hora_inicio,hora_fin)
  41. from 'C:\tmp\boleta.csv' DELIMITER ',' CSV HEADER;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement