{"id":19951,"date":"2026-11-12T14:58:08","date_gmt":"2026-11-12T12:58:08","guid":{"rendered":"https:\/\/www.beseit.net\/?p=19951"},"modified":"2026-11-22T10:01:21","modified_gmt":"2026-11-22T08:01:21","slug":"mut-esborrar","status":"publish","type":"post","link":"http:\/\/www.beseit.net\/?p=19951","title":{"rendered":"\u2b50Importar V\u00eddeos a BD convertir_ytllistes\/ytvideos.py per a Dbeaver"},"content":{"rendered":"\n<p class=\"has-large-font-size wp-block-paragraph\"><strong>Importar V\u00eddeos de la llista de reproducci\u00f3<\/strong> YT per a Dbeaver<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"271\" height=\"159\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-21.png\" alt=\"\" class=\"wp-image-20078\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\">Crear home\/Miquel\/onedrive\/localhost\/videosYT\/<mark style=\"background-color:rgba(0, 0, 0, 0);color:#fa0a0a\" class=\"has-inline-color\">geopolitica.htm<\/mark> salvat amb de libreoffice.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">-\/home\/Miquel\/onedrive\/localhost\/videosYT\/<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-medium-font-size\">fer corre l&#8217;escript<strong>:<\/strong> <mark style=\"background-color:rgba(0, 0, 0, 0);color:#e40c0c\" class=\"has-inline-color\">python3 videos_html_a_csv.py geopolitica.html<\/mark><\/li>\n\n\n\n<li class=\"has-medium-font-size\">geopol\u00edtica \u00e9s un nom &#8216;comod\u00ed&#8217; \u00e9s v\u00e0lid per qualsevol nom de llista, un cop tenim geopolitca.csv s&#8217;actualitza a &#8216;Congo Lubumba.csv&#8217; (per exemple). L&#8217;escript ha de ser al mateix directori que el fitxer html.<\/li>\n\n\n\n<li class=\"has-medium-font-size\"><strong>python3 videos_html_a_csv.py <\/strong>geopolitica<strong>.html -o videos.csv -n \u00ab<\/strong>5<\/li>\n\n\n\n<li class=\"has-medium-font-size\">Miquel@Miquel-PC:<del>\/onedrive\/localhost\/videosYT$ python3 videos_html_a_csv.py geopolitica.html<\/del><\/li>\n\n\n\n<li><del>5 v\u00eddeos escrits a geopolitica.csv<\/del><\/li>\n\n\n\n<li class=\"has-medium-font-size\"><mark style=\"background-color:rgba(0, 0, 0, 0);color:#f31616\" class=\"has-inline-color\"><strong>Carrega de Congo Lubumba.csv<\/strong> a llistes_recarrega de Dbeaver<\/mark><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>entrada<\/strong> :\/home\/Miquel\/dropbox\/llistes de reproducci\u00f3 youtube\/llista\/llista_YT_1-50.html<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>sortida:<\/strong>\/home\/Miquel\/dropbox\/llistes de reproducci\u00f3 youtube\/llista\/llista_YT_1-50.csv<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">id,nom_llista,num_videos,data_entrada<br>1,UVL,1,01-11-26<br>2,Congo lubumba,10,05-09-26<br>3,Parquet,5,18-06-26<br>4,Linux,3,17-06-26<br>5,Eines: fusta,6,10-06-26<br>6,Bitcoin,5,07-06-26<br>&#8212;&#8211;<br>35,extractors aire,1,12-02-26<br>36,Disc de tall,1,10-02-26<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Llan\u00e7ament:<\/p>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code> <mark style=\"background-color:rgba(0, 0, 0, 0);color:#f51919\" class=\"has-inline-color\">python3 \/home\/Miquel\/dropbox\/apps_mut\/convertir_ytllistes.py \"\/home\/Miquel\/dropbox\/llistes de reproducci\u00f3 youtube\/llista\/llista_YT_1-50.html\"<\/mark><\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"746\" height=\"468\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-12.png\" alt=\"\" class=\"wp-image-19971\" srcset=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-12.png 746w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-12-300x188.png 300w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-12-478x300.png 478w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">Assignar la propietat <strong>UNIQUE<\/strong> (Valor \u00danic) a un camp<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">La imatge que mostres \u00e9s el panell de <strong>\u00abPropietats del camp\u00bb<\/strong> (probablement de <strong>phpMyAdmin<\/strong>). Aquest panell <strong>no inclou directament<\/strong> l&#8217;opci\u00f3 de marcar un camp com a <code>UNIQUE<\/code>. Per fer-ho, tens diverses opcions:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Opci\u00f3 1: Des de l&#8217;estructura de la taula (phpMyAdmin)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ves a la pestanya <strong>\u00abEstructura\u00bb<\/strong> de la taula.<\/li>\n\n\n\n<li>A la llista de camps, localitza el camp que vols fer \u00fanic.<\/li>\n\n\n\n<li>Fes clic a la icona de <strong>clau amb un \u00abU\u00bb<\/strong> (\ud83d\udd11 U) a la columna d&#8217;\u00edndexs, o b\u00e9:<\/li>\n\n\n\n<li>A la part inferior de la llista de camps, hi ha la secci\u00f3 <strong>\u00ab\u00cdndexs\u00bb<\/strong> \u2192 fes clic a <strong>\u00abAfegir \u00edndex\u00bb<\/strong> i selecciona <strong>UNIQUE<\/strong>.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Opci\u00f3 2: Mitjan\u00e7ant SQL (recomanat)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Executa una consulta SQL directament:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER TABLE `nom_taula` ADD UNIQUE (`nom_camp`);<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Si vols que el camp \u00fanic tingui un nom d&#8217;\u00edndex personalitzat:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER TABLE `nom_taula` ADD UNIQUE INDEX `idx_nom_camp` (`nom_camp`);<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Opci\u00f3 3: En crear la taula des de zero<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE `nom_taula` (\n    `id` INT AUTO_INCREMENT PRIMARY KEY,\n    `email` VARCHAR(255) UNIQUE,\n    `nom` VARCHAR(255)\n);<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Opci\u00f3 4: Des del dissenyador de phpMyAdmin<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ves a la pestanya <strong>\u00abRelacions\u00bb<\/strong> o <strong>\u00abDesigner\u00bb<\/strong>.<\/li>\n\n\n\n<li>Selecciona el camp i assigna-li la restricci\u00f3 <strong>UNIQUE<\/strong> des del men\u00fa d&#8217;\u00edndexs.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u26a0\ufe0f Important<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un camp <code>UNIQUE<\/code> <strong>no permet valors duplicats<\/strong>.<\/li>\n\n\n\n<li>Si la taula <strong>ja cont\u00e9 dades duplicades<\/strong> al camp, l&#8217;operaci\u00f3 fallar\u00e0. Primer haur\u00e0s d&#8217;eliminar els duplicats:<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Veure duplicats\nSELECT `nom_camp`, COUNT(*) \nFROM `nom_taula` \nGROUP BY `nom_camp` \nHAVING COUNT(*) > 1;<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un camp <code>UNIQUE<\/code> <strong>s\u00ed que permet valors NULL<\/strong> (varis registres poden tenir NULL), a difer\u00e8ncia del <code>PRIMARY KEY<\/code>.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Si necessites ajuda amb un cas concret (nom de taula, camp, etc.), indica&#8217;m-ho i t&#8217;ajudo amb la consulta exacta! \ud83d\ude0a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">aqueste propietar on s&#8217;ha de posar? Longitud 150, obligatori, \u00fanic<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importar V\u00eddeos de la llista de reproducci\u00f3 YT per a Dbeaver -\/home\/Miquel\/onedrive\/localhost\/videosYT\/ entrada :\/home\/Miquel\/dropbox\/llistes de reproducci\u00f3 youtube\/llista\/llista_YT_1-50.html sortida:\/home\/Miquel\/dropbox\/llistes de reproducci\u00f3 youtube\/llista\/llista_YT_1-50.csv id,nom_llista,num_videos,data_entrada1,UVL,1,01-11-262,Congo lubumba,10,05-09-263,Parquet,5,18-06-264,Linux,3,17-06-265,Eines: fusta,6,10-06-266,Bitcoin,5,07-06-26&#8212;&#8211;35,extractors aire,1,12-02-2636,Disc de tall,1,10-02-26 Llan\u00e7ament: Assignar la propietat UNIQUE (Valor \u00danic) a un camp La imatge que &hellip; <a href=\"http:\/\/www.beseit.net\/?p=19951\">Continua llegint <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":3167,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[209,207,1],"tags":[],"class_list":["post-19951","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-libreoffice","category-deepin-linux","category-bloc-de-notes"],"_links":{"self":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/19951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19951"}],"version-history":[{"count":25,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/19951\/revisions"}],"predecessor-version":[{"id":20098,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/19951\/revisions\/20098"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/media\/3167"}],"wp:attachment":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19951"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}