Continuación de casos de negocio

Contenido del curso

Introducción

CREATE

INSERT

Bash y archivos SQL

14
Cómo importar archivos SQL con MySQL
07:18 min

SELECT

Consultas en MySQL

Contenido Bonus

24
MySQL en terminal: datos a decisiones
15:24 min

Tomar examen

Cursos Empresas Blog Live Conf Eventos Precios

0:0019:07

Continuación de casos de negocio

Curso de SQL y MySQL 2018

Clase 20 de 24

Clase 20 / 24

Recursos

Aprende a obtener valor real de tus datos con consultas SQL claras. Desde precios promedio y desviación estándar hasta reportes finales con clientes, libros y autores, verás cómo combinar tablas, ordenar resultados y trabajar con fechas para convertir datos en información accionable.

¿Cómo explorar precios con select, order by y agregaciones?

Con una columna basta para empezar. Un simple “trae precios” permite observar el rango de valores y preparar agregaciones más útiles.

Usa select para aislar columnas clave. Por ejemplo: precios.
Ordena con order by price desc limit 10 para ver los más caros.
Cambia a asc para detectar los precios más bajos.
Calcula promedio con la función AVG y desviación estándar con STDDEV para entender dispersión.

Ejemplos de consultas:

-- Precios aislados
SELECT price FROM books;

-- Títulos y precios más caros
SELECT title, price
FROM books
ORDER BY price DESC
LIMIT 10;

-- Agregaciones globales
SELECT AVG(price) AS precio_promedio,
       STDDEV(price) AS desviacion_estandar
FROM books;

Lo interesante llega al cruzar datos. Con JOIN entre libros y autores y GROUP BY por nacionalidad, obtienes precio promedio y desviación estándar por país, y además puedes contar cuántos libros aporta cada uno.

SELECT a.nationality,
       COUNT(b.book_id) AS libros,
       AVG(b.price) AS precio_promedio,
       STDDEV(b.price) AS desviacion_estandar
FROM books AS b
JOIN authors AS a ON a.author_id = b.author_id
GROUP BY a.nationality
ORDER BY libros DESC;

Claves prácticas:

El grupo depende de una “columna pivote” bien elegida: aquí, nationality.
Si un país tiene un solo libro, la desviación estándar es 0.
Los nulos importan: una nacionalidad NULL puede concentrar muchos libros aunque falten datos del autor.
Ejemplos útiles: precio máximo visto 34.82; promedios cercanos a 22.39; Estados Unidos con 34 libros y promedio 22.12.

¿Por qué ordenar por libros en lugar de promedio?

Porque el volumen da contexto a los promedios.
Una media con pocos datos puede inducir a error.
Ordenar por libros DESC prioriza nacionalidades con más representatividad.

¿Qué revelan max y min por nacionalidad?

Además del promedio, los extremos muestran la amplitud de precios por país.

-- Máximo y mínimo globales
SELECT MAX(price) AS precio_maximo,
       MIN(price) AS precio_minimo
FROM books;

-- Extremos por nacionalidad
SELECT a.nationality,
       MAX(b.price) AS max_por_pais,
       MIN(b.price) AS min_por_pais
FROM books AS b
JOIN authors AS a ON a.author_id = b.author_id
GROUP BY a.nationality;

Observaciones prácticas:

País con un solo libro: máximo = mínimo.
Estados Unidos exhibe rango amplio: por ejemplo, de 34.82 a 10.17.
Ver extremos ayuda a detectar oportunidades (catálogo caro/barato) y anomalías.

¿Cómo elegir la columna pivote correctamente?

Piensa en la pregunta de negocio: por país, por autor, por cliente.
Evita ambigüedades: agrupa por la columna que resumes en pantalla.
Revisa nulos y consistencia: afectan totales y estadísticas.

¿Cómo armar un reporte final con joins, concat y fechas?

Un reporte legible combina transacciones, clientes, libros y autores. Se recomienda LEFT JOIN desde la tabla de transactions y proyectar las columnas clave.

SELECT T.type,
       B.title,
       CONCAT(A.name, ' (', A.nationality, ')') AS autor
FROM transactions AS T
LEFT JOIN clients AS C ON C.client_id = T.client_id
LEFT JOIN books AS B ON B.book_id = T.book_id
LEFT JOIN authors AS A ON B.author_id = A.author_id;

Mejoras de lectura:

Usa CONCAT para mostrar “Nombre (nacionalidad)” en una sola columna.
Aplica alias claros: autor, libros, precio_promedio, etc.

Para trabajar con fechas, la función TODAYS convierte una fecha a el número de días desde el inicio de la era. Esto facilita comparaciones numéricas directas: ayer, hoy, hace X días.

-- Días desde el inicio de la era hasta ahora
SELECT TODAYS(NOW());

-- Días vividos por cliente
SELECT name, TODAYS(birthdate) AS dias_desde_origen
FROM clients;

-- “Hace cuánto” sucedió cada transacción
SELECT T.type,
       B.title,
       TODAYS(NOW()) - TODAYS(T.created_at) AS ago
FROM transactions AS T
LEFT JOIN books AS B ON B.book_id = T.book_id;

Ideas clave con fechas:

TODAYS(NOW()) entrega un entero usable en restas.
Diferencia de TODAYS entre hoy y created_at da el “ago” en días.
Útil para saber hace cuánto se rentó o vendió un libro.
Ejemplo real: una transacción con fecha 2018-01-01 resultó en 99 días de diferencia frente a los datos insertados hoy.

¿Qué habilidades consolidas con estos casos?

Construir consultas con select, order by, limit y alias claros.
Agregar con avg, stddev, count, max, min y group by.
Cruzar tablas con join y left join a partir de una tabla clave.
Formatear columnas con concat para resultados legibles.
Operar fechas con todays y now para métricas de tiempo.
Interpretar nulos, conteos y dispersión para decisiones de negocio.

¿Quieres que integremos filtros por rango de fechas, tipo de transacción o país, y generemos un dashboard mínimo con estas consultas? Comparte qué vista te serviría más.

Emmanuel Octavio Martinez C

Hace 8 años

Para los que no tengan precios en la DB ejectuar:

TRUNCATE `books`;

INSERT INTO `books` VALUES (1,1,'The Startup Playbook',2013,'en',NULL,10.00,1,5,'Advice from the experts'),
(2,1,'The Startup Playbook',2014,'es',NULL,10.00,1,5,'Consejo de los expertos, traducido por Platzi'),
(3,3,'Estudio en escarlata',1887,'es',NULL,5.00,1,10,'La primera novela de Sherlock Holmes'),
(4,6,'Wallander: Asesinos sin rostro',1991,'es',NULL,15.00,1,3,''),
(5,6,'Wallander: Los perros de Riga',1992,'es',NULL,15.00,1,3,''),
(6,6,'Wallander: La leona blanca',1993,'es',NULL,15.00,1,3,''),
(7,6,'Wallander: El hombre sonriente',1994,'es',NULL,15.00,1,3,''),
(8,6,'Wallander: La falsa pista',1995,'es',NULL,15.00,1,3,''),
(9,6,'Wallander: La quinta mujer',1996,'es',NULL,15.00,1,3,''),
(10,6,'Wallander: Pisando los talones',1997,'es',NULL,15.00,1,3,''),
(11,6,'Wallander: Cortafuegos',1998,'es',NULL,15.00,1,3,''),
(12,5,'El llano en llamas',1953,'es',NULL,10.00,0,1,'Cuentos mexicanos'),
(13,7,'Fundamentals of Wavelets',1900,'en',NULL,15.20,1,4,NULL),
(14,8,'Data Smart',1900,'en',NULL,20.5,1,4,NULL),
(15,9,'God Created the Integers',1900,'en',NULL,12.5,1,4,NULL),
(16,10,'Superfreakonomics',1900,'en',NULL,10.5,1,4,NULL),
(17,11,'Orientalism',1900,'en',NULL,21.2,1,4,NULL),
(18,12,'The Nature of Statistical Learning Theory',1900,'en',NULL,15.0,1,4,NULL),
(19,13,'Integration of the Indian States',1900,'en',NULL,13.5,1,4,NULL),
(20,14,'The Drunkard\'s Walk',1900,'en',NULL,21.2,1,4,NULL),
(21,15,'Image Processing & Mathematical Morphology',1900,'en',NULL,12.3,1,4,NULL),
(22,16,'How to Think Like Sherlock Holmes',1900,'en',NULL,15.2,1,4,NULL),
(23,17,'Data Scientists at Work',1900,'en',NULL,15.2,1,4,NULL),
(24,18,'Slaughterhouse Five',1900,'en',NULL,15.2,1,4,NULL),
(25,19,'Birth of a Theorem',1900,'en',NULL,10.5,1,4,NULL),
(26,20,'Structure & Interpretation of Computer Programs',1900,'en',NULL,10.5,1,4,NULL),
(27,21,'The Age of Wrath',1900,'en',NULL,10.5,1,4,NULL),
(28,22,'The Trial',1900,'en',NULL,15.5,1,4,NULL),
(29,23,'Statistical Decision Theory',1900,'en',NULL,15.5,1,4,NULL),
(30,24,'Data Mining Handbook',1900,'en',NULL,15.5,1,4,NULL),
(31,25,'The New Machiavelli',1900,'en',NULL,15.5,1,4,NULL),
(32,26,'Physics & Philosophy',1900,'en',NULL,10.2,1,4,NULL),
(33,27,'Making Software',1900,'en',NULL,11.2,1,4,NULL),
(34,28,'Vol I Analysis',1900,'en',NULL,15.3,1,4,NULL),
(35,29,'Machine Learning for Hackers',1900,'en',NULL,10.5,1,4,NULL),
(36,30,'The Signal and the Noise',1900,'en',NULL,12.5,1,4,NULL),
(37,31,'Python for Data Analysis',1900,'en',NULL,10.0,1,4,NULL),
(38,32,'Introduction to Algorithms',1900,'en',NULL,21.5,1,4,NULL),
(39,33,'The Beautiful and the Damned',1900,'en',NULL,20.5,1,4,NULL),
(40,34,'The Outsider',1900,'en',NULL,22.5,1,4,NULL),
(41,3,'The - Vol I Complete Sherlock Holmes',1900,'en',NULL,23.5,1,4,NULL),
(42,3,'The - Vol II Complete Sherlock Holmes',1900,'en',NULL,21.5,1,4,NULL),
(43,37,'The Wealth of Nations',1900,'en',NULL,22.5,1,4,NULL),
(44,38,'The Pillars of the Earth',1900,'en',NULL,24.5,1,4,NULL),
(45,39,'The Tao of Physics',1900,'en',NULL,15.5,1,4,NULL),
(46,40,'Surely You\'s re Joking Mr Feynman',1900,'en',NULL,12.3,1,4,NULL),
(47,41,'A Farewell to Arms',1900,'en',NULL,14.6,1,4,NULL),
(48,42,'The Veteran',1900,'en',NULL,10.6,1,4,NULL),
(49,43,'False Impressions',1900,'en',NULL,12.4,1,4,NULL),
(50,44,'The Last Lecture',1900,'en',NULL,13.6,1,4,NULL),
(51,45,'Return of the Primitive',1900,'en',NULL,14.3,1,4,NULL),
(52,46,'Jurassic Park',1900,'en',NULL,13.5,1,4,NULL),
(53,47,'A Russian Journal',1900,'en',NULL,17.5,1,4,NULL),
(54,48,'Tales of Mystery and Imagination',1900,'en',NULL,19.5,1,4,NULL),
(55,10,'Freakonomics',1900,'en',NULL,19.99,1,4,NULL),
(56,39,'The Hidden Connections',1900,'en',NULL,15.98,1,4,NULL),
(57,51,'The Story of Philosophy',1900,'en',NULL,14.89,1,4,NULL),
(58,52,'Asami Asami',1900,'en',NULL,15.6,1,4,NULL),
(59,47,'Journal of a Novel',1900,'en',NULL,14.5,1,4,NULL),
(60,47,'Once There Was a War',1900,'en',NULL,14.6,1,4,NULL),
(61,47,'The Moon is Down',1900,'en',NULL,21.5,1,4,NULL),
(62,56,'The Brethren',1900,'en',NULL,22.6,1,4,NULL),
(63,57,'In a Free State',1900,'en',NULL,22.4,1,4,NULL),
(64,58,'Catch 22',1900,'en',NULL,20.5,1,4,NULL),
(65,59,'The Complete Mastermind',1900,'en',NULL,14.6,1,4,NULL),
(66,60,'Dylan on Dylan',1900,'en',NULL,13.8,1,4,NULL),
(67,61,'Soft Computing & Intelligent Systems',1900,'en',NULL,17.8,1,4,NULL),
(68,62,'Textbook of Economic Theory',1900,'en',NULL,17.4,1,4,NULL),
(69,63,'Econometric Analysis',1900,'en',NULL,18.9,1,4,NULL),
(70,64,'Learning OpenCV',1900,'en',NULL,18.54,1,4,NULL),
(71,65,'Data Structures Using C & C++',1900,'en',NULL,17.6,1,4,NULL),
(72,66,'A Modern Approach Computer Vision',1900,'en',NULL,13.5,1,4,NULL),
(73,67,'Principles of Communication Systems',1900,'en',NULL,15.4,1,4,NULL),
(74,68,'Let Us C',1900,'en',NULL,15.6,1,4,NULL),
(75,69,'The Amulet of Samarkand',1900,'en',NULL,14.6,1,4,NULL),
(76,70,'Crime and Punishment',1900,'en',NULL,17.5,1,4,NULL),
(77,71,'Angels & Demons',1900,'en',NULL,15.3,1,4,NULL),
(78,72,'The Argumentative Indian',1900,'en',NULL,18.9,1,4,NULL),
(79,73,'Sea of Poppies',1900,'en',NULL,24.5,1,4,NULL),
(80,72,'The Idea of Justice',1900,'en',NULL,26.3,1,4,NULL),
(81,75,'A Raisin in the Sun',1900,'en',NULL,27.8,1,4,NULL),
(82,76,'All the President\'s Men',1900,'en',NULL,29.5,1,4,NULL),
(83,43,'A Prisoner of Birth',1900,'en',NULL,28.7,1,4,NULL),
(84,78,'Scoop!',1900,'en',NULL,28.9,1,4,NULL),
(85,79,'Ahe Manohar Tari',1900,'en',NULL,24.1,1,4,NULL),
(86,80,'The Last Mughal',1900,'en',NULL,15.3,1,4,NULL),
(87,81,'Vol 39 No. 1 Social Choice & Welfare',1900,'en',NULL,13.6,1,4,NULL),
(88,52,'Radiowaril Bhashane & Shrutika',1900,'en',NULL,18.4,1,4,NULL),
(89,52,'Gun Gayin Awadi',1900,'en',NULL,24.1,1,4,NULL),
(90,52,'Aghal Paghal',1900,'en',NULL,26.68,1,4,NULL),
(91,85,'Maqta-e-Ghalib',1900,'en',NULL,25.3,1,4,NULL),
(92,86,'Manasa',1900,'en',NULL,24.3,1,4,NULL),
(93,87,'India from Midnight to Milennium',1900,'en',NULL,23.6,1,4,NULL),
(94,87,'The Great Indian Novel',1900,'en',NULL,21.0,1,4,NULL),
(95,89,'O Jerusalem!',1900,'en',NULL,20.20,1,4,NULL),
(96,89,'The City of Joy',1900,'en',NULL,20.0,1,4,NULL),
(97,89,'Freedom at Midnight',1900,'en',NULL,19.98,1,4,NULL),
(98,47,'The Winter of Our Discontent',1900,'en',NULL,27.0,1,4,NULL),
(99,93,'On Education',1900,'en',NULL,21.8,1,4,NULL),
(100,94,'Free Will',1900,'en',NULL,11.4,1,4,NULL),
(101,87,'Bookless in Baghdad',1900,'en',NULL,13.6,1,4,NULL),
(102,96,'The Case of the Lame Canary',1900,'en',NULL,15.6,1,4,NULL),
(103,9,'The Theory of Everything',1900,'en',NULL,14.6,1,4,NULL),
(104,98,'New Markets & Other Essays',1900,'en',NULL,13.5,1,4,NULL),
(105,99,'Electric Universe',1900,'en',NULL,18.5,1,4,NULL),
(106,100,'The Hunchback of Notre Dame',1900,'en',NULL,17.7,1,4,NULL),
(107,47,'Burning Bright',1900,'en',NULL,17.7,1,4,NULL),
(108,98,'The Age of Discontuinity',1900,'en',NULL,15.5,1,4,NULL),
(109,103,'Doctor in the Nude',1900,'en',NULL,24.1,1,4,NULL),
(110,104,'Down and Out in Paris & London',1900,'en',NULL,13.3,1,4,NULL),
(111,72,'Identity & Violence',1900,'en',NULL,16.65,1,4,NULL),
(112,80,'Beyond the Three Seas',1900,'en',NULL,15.21,1,4,NULL),
(113,107,'Talking Straight',1900,'en',NULL,17.5,1,4,NULL),
(114,108,'Vol 3 Maugham\'s Collected Short Stories',1900,'en',NULL,14.4,1,4,NULL),
(115,42,'The Phantom of Manhattan',1900,'en',NULL,14.23,1,4,NULL),
(116,108,'Ashenden of The British Agent',1900,'en',NULL,13.25,1,4,NULL),
(117,111,'Zen & The Art of Motorcycle Maintenance',1900,'en',NULL,17.8,1,4,NULL),
(118,112,'The Great War for Civilization',1900,'en',NULL,17.8,1,4,NULL),
(119,45,'We the Living',1900,'en',NULL,16.5,1,4,NULL),
(120,114,'The Artist and the Mathematician',1900,'en',NULL,12.21,1,4,NULL),
(121,93,'History of Western Philosophy',1900,'en',NULL,21.12,1,4,NULL),
(122,72,'Rationality & Freedom',1900,'en',NULL,8.6,1,4,NULL),
(123,117,'Clash of Civilizations and Remaking of the World Order',1900,'en',NULL,12.3,1,4,NULL),
(124,39,'Uncommon Wisdom',1900,'en',NULL,11.20,1,4,NULL),
(125,119,'One',1900,'en',NULL,11.01,1,4,NULL),
(126,120,'To Sir With Love',1900,'en',NULL,18.7,1,4,NULL),
(127,121,'Half A Life',1900,'en',NULL,24.42,1,4,NULL),
(128,122,'The Discovery of India',1900,'en',NULL,23.25,1,4,NULL),
(129,52,'Apulki',1900,'en',NULL,21.09,1,4,NULL),
(130,93,'Unpopular Essays',1900,'en',NULL,12.65,1,4,NULL),
(131,42,'The Deceiver',1900,'en',NULL,13.51,1,4,NULL),
(132,76,'Veil: Secret Wars of the CIA',1900,'en',NULL,41.20,1,4,NULL),
(133,52,'Char Shabda',1900,'en',NULL,14.32,1,4,NULL),
(134,128,'Rosy is My Relative',1900,'en',NULL,42.5,1,4,NULL),
(135,108,'The Moon and Sixpence',1900,'en',NULL,14.30,1,4,NULL),
(136,130,'A Short History of the World',1900,'en',NULL,18.68,1,4,NULL),
(137,108,'The Trembling of a Leaf',1900,'en',NULL,17.21,1,4,NULL),
(138,103,'Doctor on the Brain',1900,'en',NULL,21.10,1,4,NULL),
(139,133,'Simpsons & Their Mathematical Secrets',1900,'en',NULL,21.41,1,4,NULL),
(140,134,'Pattern Classification',1900,'en',NULL,21.4,1,4,NULL),
(141,135,'From Beirut to Jerusalem',1900,'en',NULL,22.32,1,4,NULL),
(142,133,'The Code Book',1900,'en',NULL,24.1,1,4,NULL),
(143,112,'The Age of the Warrior',1900,'en',NULL,10.62,1,4,NULL),
(144,138,'The Numbers Behind Numb3rs',1900,'en',NULL,11.56,1,4,NULL),
(145,47,'A Life in Letters',1900,'en',NULL,14.3,1,4,NULL),
(146,140,'The Information',1900,'en',NULL,16.15,1,4,NULL),
(147,141,'Elements of Information Theory',1900,'en',NULL,17.52,1,4,NULL),
(148,142,'Power Electronics - Rashid',1900,'en',NULL,14.10,1,4,NULL),
(149,143,'Power Electronics - Mohan',1900,'en',NULL,17.51,1,4,NULL),
(150,144,'Neural Networks',1900,'en',NULL,21.20,1,4,NULL),
(151,47,'The Grapes of Wrath',1900,'en',NULL,10.52,1,4,NULL),
(152,52,'Vyakti ani Valli',1900,'en',NULL,10.10,1,4,NULL),
(153,12,'Statistical Learning Theory',1900,'en',NULL,10.99,1,4,NULL),
(154,148,'Empire of the Mughal - The Tainted Throne',1900,'en',NULL,10.87,1,4,NULL),
(155,148,'Empire of the Mughal - Brothers at War',1900,'en',NULL,14.25,1,4,NULL),
(156,148,'Empire of the Mughal - Ruler of the World',1900,'en',NULL,18.58,1,4,NULL),
(157,148,'Empire of the Mughal - The Serpent\'s Tooth',1900,'en',NULL,14.65,1,4,NULL),
(158,148,'Empire of the Mughal - Raiders from the North',1900,'en',NULL,17.89,1,4,NULL),
(159,153,'Mossad',1900,'en',NULL,14.56,1,4,NULL),
(160,154,'Jim Corbett Omnibus',1900,'en',NULL,14.19,1,4,NULL),
(161,155,'20000 Leagues Under the Sea',1900,'en',NULL,19.41,1,4,NULL),
(162,156,'Batatyachi Chal',1900,'en',NULL,18.57,1,4,NULL),
(163,156,'Hafasavnuk',1900,'en',NULL,24.12,1,4,NULL),
(164,156,'Urlasurla',1900,'en',NULL,12.35,1,4,NULL),
(165,68,'Pointers in C',1900,'en',NULL,45.4,1,4,NULL),
(166,160,'The Cathedral and the Bazaar',1900,'en',NULL,14.25,1,4,NULL),
(167,161,'Design with OpAmps',1900,'en',NULL,14.21,1,4,NULL),
(168,162,'Think Complexity',1900,'en',NULL,12.63,1,4,NULL),
(169,163,'The Devil\'s Advocate',1900,'en',NULL,14.56,1,4,NULL),
(170,45,'Ayn Rand Answers',1900,'en',NULL,24.24,1,4,NULL),
(171,45,'Philosophy: Who Needs It',1900,'en',NULL,13.52,1,4,NULL),
(172,166,'Data Analysis with Open Source Tools',1900,'en',NULL,18.9,1,4,NULL),
(173,167,'Broca\'s Brain',1900,'en',NULL,18.98,1,4,NULL),
(174,168,'Men of Mathematics',1900,'en',NULL,17.54,1,4,NULL),
(175,169,'Oxford book of Modern Science Writing',1900,'en',NULL,17.58,1,4,NULL),
(176,170,'Judiciary and Democracy Justice',1900,'en',NULL,14.89,1,4,NULL),
(177,171,'The Arthashastra',1900,'en',NULL,15.87,1,4,NULL),
(178,172,'We the People',1900,'en',NULL,16.25,1,4,NULL),
(179,172,'We the Nation',1900,'en',NULL,11.145,1,4,NULL),
(180,174,'The Courtroom Genius',1900,'en',NULL,12.25,1,4,NULL),
(181,175,'Dongri to Dubai',1900,'en',NULL,14.00,1,4,NULL),
(182,176,'Foundation History of England',1900,'en',NULL,16.52,1,4,NULL),
(183,80,'City of Djinns',1900,'en',NULL,17.52,1,4,NULL),
(184,178,'India\'s Legal System',1900,'en',NULL,13.25,1,4,NULL),
(185,179,'More Tears to Cry',1900,'en',NULL,18.65,1,4,NULL),
(186,180,'The Ropemaker',1900,'en',NULL,17.85,1,4,NULL),
(188,182,'The Prince',1900,'en',NULL,19.52,1,4,NULL),
(189,183,'Eyeless in Gaza',1900,'en',NULL,13.25,1,4,NULL),
(190,184,'Tales of Beedle the Bard',1900,'en',NULL,25.63,1,4,NULL),
(191,185,'Girl with the Dragon Tattoo',1900,'en',NULL,18.58,1,4,NULL),
(192,185,'Girl who kicked the Hornet\'s Nest',1900,'en',NULL,17.56,1,4,NULL),
(193,185,'Girl who played with Fire',1900,'en',NULL,16.52,1,4,NULL),
(194,28,'Structure and Randomness',1900,'en',NULL,16.34,1,4,NULL),
(195,189,'Image Processing with MATLAB',1900,'en',NULL,13.28,1,4,NULL),
(196,104,'Animal Farm',1900,'en',NULL,24.24,1,4,NULL),
(197,70,'The Idiot',1900,'en',NULL,26.34,1,4,NULL),
(198,192,'A Christmas Carol',1900,'en',NULL,27.17,1,4,NULL);

Carlos Rodríguez Huerta

Hace 8 años

Pequeña observación de la primera línea para que funcione correctamente.

TRUNCATE TABLE `books`;

Luego ejecutar el script con lo enseñado por el profesor.

$ mysql -u root -p -D "nombre de la BD" < "nombre del script"

Importante encontrarse dentro de la carpeta que contiene el script para ejecutar, en la consola, el comando que escribí.

Muchas gracias por el aporte, me ahorró mucho tiempo.

Cristian Orozco Benjumea

Hace 8 años

Gracias, buen regalo

Introducción

MySQL directo en consola con Alberto

Instalación de MySQL Server en Windows

Instalando MySQL en Mac OS

Instalación local de un RDBMS (Ubuntu)

Conectar MySQL desde terminal con comandos seguros

Qué es una base de datos relacional

CREATE

Tipos de datos MySQL para tablas rápidas

Tipos de columnas / Creación de la tabla books

Crear tablas con relaciones lógicas en MySQL

Crear tabla clients: tipos de datos avanzados

INSERT

INSERT en MySQL: cómo evitar duplicados

ON DUPLICATE KEY en MySQL práctico

INSERT con subquery para authors

Bash y archivos SQL

Cómo importar archivos SQL con MySQL

SELECT

Funciones YEAR, WHERE y LIKE en MySQL SELECT

Comando JOIN

Inner vs left join en SQL

Tipos de JOIN

Traductor de preguntas de negocio a SQL

Continuación de casos de negocio

MySQL UPDATE y DELETE sin riesgos

Consultas en MySQL

Cómo crear matrices con SUM(IF) en MySQL

Modificar tablas con ALTER TABLE en MySQL

Contenido Bonus

MySQL en terminal: datos a decisiones

Continuación de casos de negocio