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 15. Generar y utilizar secuencias
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
15.0 Introducción
Una secuencia es un conjunto de números enteros (1, 2, 3, ...) generados en orden a petición de. Las secuencias se utilizan con frecuencia en las bases de datos porque muchas aplicaciones requieren que cada fila de una tabla contenga un valor único, y las secuencias proporcionan una forma sencilla de generarlos. Este capítulo describe cómo utilizar secuencias en MySQL de las cinco formas siguientes:
- Utilizando
AUTO_INCREMENTcolumnas La columna
AUTO_INCREMENTes el mecanismo de MySQL para generar una secuencia sobre un conjunto de filas. Cada vez que creas una fila en una tabla que contiene una columnaAUTO_INCREMENT, MySQL genera automáticamente el siguiente valor de la secuencia como valor de la columna. Este valor sirve como identificador único, por lo que las secuencias son una forma sencilla de crear elementos como números de identificación de cliente, números de albarán de envío de paquetes, números de factura u orden de compra, identificadores de informes de errores, números de ticket o números de serie de productos.- Recuperar valores de secuencia
Para muchas aplicaciones, no basta con crear valores de secuencia. También es necesario determinar el valor de secuencia de una fila recién insertada. Una aplicación web puede necesitar volver a mostrar a un usuario el contenido de una fila creada a partir del ...
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.