{"id":554,"date":"2023-10-20T12:51:48","date_gmt":"2023-10-20T10:51:48","guid":{"rendered":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/?page_id=554"},"modified":"2025-06-13T10:47:42","modified_gmt":"2025-06-13T08:47:42","slug":"1-12-altres-utilitats-de-mysql","status":"publish","type":"page","link":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/1-12-altres-utilitats-de-mysql\/","title":{"rendered":"1.12. Altres utilitats de MySQL"},"content":{"rendered":"<p>Juntament amb l\u2019inventari d\u2019ordres que interactuen amb la nostra base de dades emprant el llenguatge SQL, el SGBD MySQL proporciona un conjunt d\u2019aplicacions elementals per assistir-nos a l\u2019hora de treballar amb el sistema.<\/p>\n<p>Per exemple, l\u2019ordre <code>help<\/code> mostra per pantalla un breu manual d\u2019ajuda sobre cada instrucci\u00f3 de MySQL.<\/p>\n<p>Per poder paginar, pantalla a pantalla, sobre les entrades del manual hem d\u2019executar abans l\u2019aplicaci\u00f3 <strong>pager<\/strong>. Aquesta ordre ens permet vincular una aplicaci\u00f3 de paginaci\u00f3 del terminal de Linux amb l\u2019int\u00e8rpret de MySQL (per exemple, el programa <em>more<\/em>).<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">mysql&gt; pager more;\r\n\r\nPAGER set to 'more'\r\n\r\nmysql&gt; help DROP TABLE;\r\n\r\nName: 'DROP TABLE'\r\nDescription:\r\nSyntax:\r\nDROP [TEMPORARY] TABLE [IF EXISTS]\r\n    tbl_name [, tbl_name] ...\r\n    [RESTRICT | CASCADE]\r\n\r\nDROP TABLE removes one or more tables. You must have the DROP privilege for each table. \r\nAll table data and the table definition are removed, so be careful with this statement!\r\nIf any of the tables named in the argument list do not exist, MySQL returns an error \r\nindicating by name which nonexisting tables it was unable to drop, but it also drops \r\nall the tables in the list that do exist.\r\n-- More --<\/pre>\n<p>L\u2019ordre <code>source<\/code> permet executar fitxers de text que inclouen ordres MySQL amb la seq\u00fc\u00e8ncia d\u2019instruccions precises per realitzar una determinada tasca. Per exemple, podem editar un fitxer de text des del nostre terminal amb les primeres ordres que executem en entrar en el sistema:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">USE cataleg;\r\nSHOW TABLES;\r\nDESCRIBE gens;\r\n---------------------------------------------------------\r\nmysql&gt; source ordres.sql;\r\n\r\nDatabase changed\r\n\r\n+--------------------+\r\n| Tables_in_cataleg  |\r\n+--------------------+\r\n| anotacions         |\r\n| funcions           |\r\n| gens               |\r\n| genomes            |\r\n+--------------------+\r\n4 rows in set (0.00 sec)\r\n\r\n+--------------+------------------+------+-----+---------+-------+\r\n| Field        | Type             | Null | Key | Default | Extra |\r\n+--------------+------------------+------+-----+---------+-------+\r\n| nom          | varchar(20)      | NO   | PRI | NULL    |       |\r\n| cromosoma    | varchar(5)       | YES  |     | NULL    |       |\r\n| cadena       | varchar(1)       | YES  |     | NULL    |       |\r\n| inici        | int(11)          | YES  |     | NULL    |       |\r\n| final        | int(11)          | YES  |     | NULL    |       |\r\n| proteina     | varchar(20)      | YES  |     | NULL    |       |\r\n| especie      | varchar(100)     | YES  | MUL | NULL    |       |\r\n+--------------+------------------+------+-----+---------+-------+\r\n7 rows in set (0.00 sec)<\/pre>\n<p>L\u2019ordre <code>status<\/code> permet veure la configuraci\u00f3 del sistema:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">mysql&gt; status;\r\n\r\nmysql  Ver 14.14 Distrib 5.7.17, for Linux (i686) using EditLine wrapper\r\nConnection id:          7\r\nCurrent database:       cataleg\r\nCurrent user:           student@localhost\r\nSSL:                    Not in use\r\nCurrent pager:          more\r\nUsing outfile:          ''\r\nUsing delimiter:        ;\r\nServer version:         5.7.17-0ubuntu0.16.04.1 (Ubuntu)\r\nProtocol version:       10\r\nConnection:             Localhost via UNIX socket\r\nServer characterset:    latin1\r\nDb characterset:        latin1\r\nClient characterset:    utf8\r\nConn. characterset:     utf8\r\nUNIX socket:            \/var\/run\/mysqld\/mysqld.sock\r\nUptime:                 4 hours 14 min 12 sec\r\nThreads:                1  Questions: 101  Slow queries: 0  Opens: 129 \r\nFlush tables:           1  Open tables: 42  Queries per second avg: 0.006<\/pre>\n<p>Si en algun instant necessitem accedir al terminal de Linux, podem emprar l\u2019ordre <strong>system <\/strong>per invocar les seves ordres des de l\u2019interior de MySQL:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">mysql&gt; system (ls \/home\/student);\r\n\r\nDesktop  Documents  Downloads Music  Pictures  Public  Templates  Videos\r\n\r\nmysql&gt; system (cat ordres.sql);\r\n\r\nUSE cataleg;\r\n\r\nSHOW TABLES;\r\n\r\nDESCRIBE gens;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Juntament amb l\u2019inventari d\u2019ordres que interactuen amb la nostra base de dades emprant el llenguatge SQL, el SGBD MySQL proporciona un conjunt d\u2019aplicacions elementals per assistir-nos a l\u2019hora de treballar amb el sistema. Per exemple, l\u2019ordre help mostra per pantalla un breu manual d\u2019ajuda sobre cada instrucci\u00f3 de MySQL. Per poder paginar, pantalla a pantalla, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"acf":[],"_links":{"self":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/554"}],"collection":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/comments?post=554"}],"version-history":[{"count":9,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/554\/revisions"}],"predecessor-version":[{"id":966,"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/pages\/554\/revisions\/966"}],"wp:attachment":[{"href":"http:\/\/eines-informatiques.recursos.uoc.edu\/gestion-de-datos\/wp-json\/wp\/v2\/media?parent=554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}