October 2024
Intermediate to advanced
974 pages
27h 14m
Spanish
Content preview from Libro de cocina de MySQL, 4ª ediciónBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 13. Importar y exportar datos
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
13.0 Introducción
Supón que un archivo llamado somedata.csvcontiene 12 columnas de datos en formato de valores separados por comas (CSV). De este archivo quieres extraer sólo las columnas 2, 11, 5 y 9 y utilizarlas para crear filas de base de datos en una tabla MySQL que contenga las columnas name, birth, height y weight. Debes asegurarte de que la altura y el peso son enteros positivos, y convertir las fechas de nacimiento de formato MM/DD/YY al formato YYYY-MM-DD formato. ¿Cómo puedes hacerlo?
Los problemas de transferencia de datos con requisitos específicos ocurren con frecuencia cuando transfieres datos a MySQL. Los archivos de datos no siempre están formateados para estar listos para cargarse en MySQL sin ninguna preparación. Como resultado, a menudo es necesario preprocesar la información para ponerla en un formato aceptable para MySQL. Lo contrario también es cierto; los datos exportados desde MySQL pueden necesitar un masaje para que sean útiles para otros programas.
Aunque algunas operaciones de preparación de datos requieren una gran cantidad de comprobaciones y reformateos manuales, en la mayoría de los casos puedes hacer al menos parte del trabajo automáticamente. Prácticamente todos estos problemas implican al menos algunos elementos de un conjunto común de problemas de conversión. Este capítulo y el siguiente tratan ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.