__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Valores generados</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores del módulo elegido" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript>
<a id="bm_id521623154765032"></a> <meta itemprop="keywords" content="propiedades avanzadas de la base de datos,valores que se autoincrementan"> <meta itemprop="keywords" content="propiedades avanzadas de la base de datos,generación automática de valores"> <meta itemprop="keywords" content="propiedades avanzadas de la base de datos,recuperación de valores generados"> <meta itemprop="keywords" content="propiedades avanzadas de la base de datos,valores generados por consultas">
<a id="generated"></a>
<h1 id="par_idN10553" dir="auto">Valores generados</h1>
<p id="par_idN10563" class="paragraph" dir="auto">Permite especificar las opciones de los valores generados automáticamente para los registros de datos nuevos.</p>
<p id="par_idN10578" class="paragraph" dir="auto"></p>
<p id="par_id7684560" class="paragraph" dir="auto">La disponibilidad de los controles siguientes depende del tipo de base de datos:</p>
<h2 id="par_idN1058C" dir="auto">Recuperar valores generados</h2>
<p id="par_idN10590" class="paragraph" dir="auto"><span class="avis">Habilita la compatibilidad con LibreOffice para los campos de datos con incremento automático en el actual origen de datos, ODBC o JDBC. Seleccione esta opción si no se admite la función de incremento automático en la capa SDBCX de la base de datos. En general, el incremento automático se selecciona para el campo de clave principal.</span></p>
<h2 id="par_idN10593" dir="auto">Instrucción de incremento automático</h2>
<p id="par_idN10597" class="paragraph" dir="auto"><span class="avis">Ingrese el especificador de la instrucción SQL que le indicará al origen de datos que incremente automáticamente un específico campo de datos Entero [INTEGER].</span> Por ejemplo, la siguiente instrucción de MySQL usa la declaración AUTO_INCREMENT para incrementar el valor del campo "id" cada vez que la declaración crea un campo de datos:</p>
<p id="par_idN105A0" class="code" dir="auto">CREATE TABLE "tabla1" ("id" INTEGER AUTO_INCREMENT)</p>
<p id="par_idN10634" class="paragraph" dir="auto">Para este ejemplo, debe ingresar AUTO_INCREMENT en el cuadro <span class="emph">Instrucción de incremento automático</span>.</p>
<h2 id="par_idN105AA" dir="auto">Consulta de valores generados</h2>
<p id="par_idN10645" class="paragraph" dir="auto"><span class="avis">Ingrese una instrucción SQL que devuelva el último valor incrementado automáticamente para el campo de datos de la clave principal.</span> Por ejemplo:</p>
<p id="par_idN105B1" class="code" dir="auto">SELECT LAST_INSERT_D();</p>
</div>
<div id="DonationFrame"></div>
<footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2>
<div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;">
<img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;">
</div>
<div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/sdatabase/dabaadvpropgen.xhp" target="_blank">/text/sdatabase/dabaadvpropgen.xhp</a></p>
<p dir="auto">Title is: Valores generados</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| 02000000.html | File | 9.24 KB | 0644 |
|
| 02000002.html | File | 6.81 KB | 0644 |
|
| 02010100.html | File | 65.17 KB | 0644 |
|
| 02010101.html | File | 8.05 KB | 0644 |
|
| 04000000.html | File | 5.94 KB | 0644 |
|
| 04030000.html | File | 6.22 KB | 0644 |
|
| 05000000.html | File | 5.66 KB | 0644 |
|
| 05000001.html | File | 6.27 KB | 0644 |
|
| 05000003.html | File | 4.88 KB | 0644 |
|
| 05010000.html | File | 9.15 KB | 0644 |
|
| 05010100.html | File | 7.73 KB | 0644 |
|
| 05020000.html | File | 10.17 KB | 0644 |
|
| 05020100.html | File | 9.21 KB | 0644 |
|
| 05030000.html | File | 6.8 KB | 0644 |
|
| 05030100.html | File | 7.81 KB | 0644 |
|
| 05030200.html | File | 5.26 KB | 0644 |
|
| 05030300.html | File | 6.22 KB | 0644 |
|
| 05030400.html | File | 6.13 KB | 0644 |
|
| 05040000.html | File | 4.21 KB | 0644 |
|
| 05040100.html | File | 6.05 KB | 0644 |
|
| 05040200.html | File | 3.9 KB | 0644 |
|
| 11000002.html | File | 6.02 KB | 0644 |
|
| 11020000.html | File | 8.23 KB | 0644 |
|
| 11030000.html | File | 6.54 KB | 0644 |
|
| 11030100.html | File | 6.4 KB | 0644 |
|
| 11080000.html | File | 8.07 KB | 0644 |
|
| 11090000.html | File | 3.8 KB | 0644 |
|
| SortDown.html | File | 3.89 KB | 0644 |
|
| SortUp.html | File | 3.88 KB | 0644 |
|
| dabaadvprop.html | File | 4.91 KB | 0644 |
|
| dabaadvpropdat.html | File | 13.44 KB | 0644 |
|
| dabaadvpropgen.html | File | 6.16 KB | 0644 |
|
| dabadoc.html | File | 4.37 KB | 0644 |
|
| dabaprop.html | File | 4.84 KB | 0644 |
|
| dabapropadd.html | File | 9.91 KB | 0644 |
|
| dabapropcon.html | File | 5.49 KB | 0644 |
|
| dabapropgen.html | File | 8.71 KB | 0644 |
|
| dabawiz00.html | File | 9.32 KB | 0644 |
|
| dabawiz01.html | File | 8.8 KB | 0644 |
|
| dabawiz02.html | File | 5.58 KB | 0644 |
|
| dabawiz02access.html | File | 4.94 KB | 0644 |
|
| dabawiz02ado.html | File | 6.66 KB | 0644 |
|
| dabawiz02connection.html | File | 7.78 KB | 0644 |
|
| dabawiz02dbase.html | File | 4.28 KB | 0644 |
|
| dabawiz02firebird.html | File | 11.72 KB | 0644 |
|
| dabawiz02jdbc.html | File | 11.02 KB | 0644 |
|
| dabawiz02mysql.html | File | 7.41 KB | 0644 |
|
| dabawiz02odbc.html | File | 6.64 KB | 0644 |
|
| dabawiz02oracle.html | File | 6.54 KB | 0644 |
|
| dabawiz02pgsql.html | File | 9.19 KB | 0644 |
|
| dabawiz02spreadsheet.html | File | 4.68 KB | 0644 |
|
| dabawiz02text.html | File | 7.18 KB | 0644 |
|
| dabawiz03auth.html | File | 4.92 KB | 0644 |
|
| main.html | File | 10.53 KB | 0644 |
|
| menubar.html | File | 4.65 KB | 0644 |
|
| menuedit.html | File | 8.93 KB | 0644 |
|
| menufile.html | File | 6.22 KB | 0644 |
|
| menufilesave.html | File | 4.89 KB | 0644 |
|
| menuinsert.html | File | 5.51 KB | 0644 |
|
| menutools.html | File | 5.4 KB | 0644 |
|
| menuview.html | File | 6.72 KB | 0644 |
|
| migrate_macros.html | File | 8.32 KB | 0644 |
|
| password.html | File | 4.6 KB | 0644 |
|
| querywizard00.html | File | 8.82 KB | 0644 |
|
| querywizard01.html | File | 6.67 KB | 0644 |
|
| querywizard02.html | File | 5.26 KB | 0644 |
|
| querywizard03.html | File | 5.44 KB | 0644 |
|
| querywizard04.html | File | 5.77 KB | 0644 |
|
| querywizard05.html | File | 6 KB | 0644 |
|
| querywizard06.html | File | 5.57 KB | 0644 |
|
| querywizard07.html | File | 4.45 KB | 0644 |
|
| querywizard08.html | File | 4.97 KB | 0644 |
|
| rep_datetime.html | File | 5.42 KB | 0644 |
|
| rep_insertfield.html | File | 9.95 KB | 0644 |
|
| rep_main.html | File | 23.34 KB | 0644 |
|
| rep_navigator.html | File | 8.16 KB | 0644 |
|
| rep_pagenumbers.html | File | 6.53 KB | 0644 |
|
| rep_prop.html | File | 9.39 KB | 0644 |
|
| rep_sort.html | File | 8.24 KB | 0644 |
|
| tablewizard00.html | File | 6.91 KB | 0644 |
|
| tablewizard01.html | File | 7.27 KB | 0644 |
|
| tablewizard02.html | File | 7.52 KB | 0644 |
|
| tablewizard03.html | File | 7.11 KB | 0644 |
|
| tablewizard04.html | File | 5.71 KB | 0644 |
|
| toolbar_form.html | File | 13.08 KB | 0644 |
|
| toolbar_query.html | File | 13.75 KB | 0644 |
|
| toolbar_report.html | File | 13.85 KB | 0644 |
|
| toolbar_table.html | File | 12.97 KB | 0644 |
|
| toolbars.html | File | 4.52 KB | 0644 |
|