{"id":847,"date":"2025-12-19T10:00:06","date_gmt":"2025-12-19T09:00:06","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=847"},"modified":"2026-02-16T14:01:41","modified_gmt":"2026-02-16T13:01:41","slug":"exemple-de-comenzi-mysql","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/","title":{"rendered":"Exemple de comenzi MySQL"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">MySQL este un sistem popular de gestionare a bazelor de date, utilizat pe scar\u0103 larg\u0103 pentru stocarea \u0219i gestionarea datelor \u00een diverse aplica\u021bii \u0219i site-uri web. \u00cen acest articol, vom discuta c\u00e2teva exemple cheie de comenzi MySQL care sunt esen\u021biale pentru crearea, gestionarea \u0219i executarea interog\u0103rilor \u00een bazele de date.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Cuprins<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#1_Creating_a_database\">1. Crearea unei baze de date<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#2_Choosing_a_database\">2. Alegerea unei baze de date<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#3_Create_a_table\">3. Crearea unui tabel<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#4_Inserting_data\">4. Introducerea datelor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#5_Update_data\">5. Actualizarea datelor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#6_Deletion_of_data\">6. \u0218tergerea datelor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#7_SELECT_Queries\">7. Interog\u0103ri SELECT<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#8_Creating_Indexes\">8. Crearea indexurilor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#9_Deleting_Tables_and_Databases\">9. \u0218tergerea tabelelor \u0219i a bazelor de date<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/sample-mysql-commands\/#Summary\">Rezumat<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Creating_a_database\"><\/span>1. Crearea unei baze de date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Primul pas \u00een lucrul cu MySQL este crearea unei baze de date care va stoca datele pentru aplica\u021bia noastr\u0103. Putem face acest lucru cu comanda <code>CREATE DATABASE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE nume_bazei_de_date;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Alegerea_unei_baze_de_date\"><\/span>2. Alegerea unei baze de date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<\/div>\n\n<div id=\"mybox-3192951817\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">Pentru a \u00eencepe s\u0103 lucr\u0103m cu o anumit\u0103 baz\u0103 de date, trebuie s\u0103 o select\u0103m. Comanda <code>USE<\/code> ne permite s\u0103:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE nume_bazei_de_date;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Create_a_table\"><\/span>3. Crearea unui tabel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Tabelele reprezint\u0103 principala modalitate de stocare a datelor \u00eentr-o baz\u0103 de date. Putem crea un tabel folosind comanda . Exemplu:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE employees (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    first name VARCHAR(50),\n    surname VARCHAR(50),\n    age INT\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Inserting_data\"><\/span>4. Introducerea datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a introduce date \u00eentr-un tabel, folosim comanda <code>INSERT INTO<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO angaja\u021bi (prenume, nume, v\u00e2rst\u0103) VALUES ('John', 'Smith', 30);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Update_data\"><\/span>5. Actualizarea datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 trebuie s\u0103 actualiz\u0103m datele existente din tabel, folosim comanda <code>UPDATE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE employees SET age = 31 WHERE id = 1;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_Deletion_of_data\"><\/span>6. \u0218tergerea datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Comanda <code>DELETE<\/code> este utilizat\u0103 pentru a \u0219terge date dintr-un tabel. De exemplu:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM employees WHERE id = 2;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_SELECT_Queries\"><\/span>7. Interog\u0103ri SELECT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a prelua date dintr-un tabel, folosim comanda <code>SELECT<\/code>. Mai jos este un exemplu de interogare:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM employees WHERE age &gt; 25;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Acest exemplu va returna toate \u00eenregistr\u0103rile din tabelul \u201cemployees\u201d \u00een care v\u00e2rsta este mai mare de 25 de ani.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_Creating_Indexes\"><\/span>8. Crearea indexurilor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Indexurile v\u0103 permit s\u0103 accelera\u021bi interog\u0103rile bazei de date. Putem crea un index folosind comanda <code>CREATE INDEX<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE INDEX idx_age ON employees (age);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9_\u0218tergerea_tabelelor_\u0219i_bazelor_de_date\"><\/span>9. \u0218tergerea tabelelor \u0219i a bazelor de date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a \u0219terge o tabel\u0103, folosim comanda <code>DROP TABLE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP TABLE employees;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a \u0219terge o baz\u0103 de date, folosim comanda <code>DROP DATABASE<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP DATABASE database_name;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Rezumat<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL ofer\u0103 numeroase comenzi utile pentru gestionarea bazelor de date. Merit\u0103 s\u0103 le cunoa\u0219te\u021bi pe cele de baz\u0103 pentru a crea, actualiza \u0219i extrage date din baza de date \u00een mod eficient. Pe m\u0103sur\u0103 ce acumula\u021bi experien\u021b\u0103, pute\u021bi \u00eenv\u0103\u021ba opera\u021bii mai avansate \u0219i optimizarea interog\u0103rilor. MySQL este un instrument puternic pentru lucrul cu date, utilizat \u00een multe domenii ale informaticii \u0219i afacerilor.<\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[1108,1656,1641,1657,1642,1658,1643,1659,1644,1660,1645,1646,1647,1648,1649,1650,214,1651,801,1652,802,1653,808,1654,968,1655],"class_list":["post-847","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-database","manual_kb_tag-sql-examples","manual_kb_tag-mysql-commands","manual_kb_tag-crud-operations","manual_kb_tag-mysql-tutorial","manual_kb_tag-employees-table","manual_kb_tag-database-management","manual_kb_tag-sql-commands","manual_kb_tag-select-database","manual_kb_tag-table-creation","manual_kb_tag-create-table","manual_kb_tag-insert-data","manual_kb_tag-update-data","manual_kb_tag-delete-data","manual_kb_tag-select-queries","manual_kb_tag-sql-queries","manual_kb_tag-create-database","manual_kb_tag-database-queries","manual_kb_tag-mysql","manual_kb_tag-create-index","manual_kb_tag-database-management-system","manual_kb_tag-drop-table","manual_kb_tag-query-optimization","manual_kb_tag-drop-database","manual_kb_tag-databases","manual_kb_tag-database-administration"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/847\/revisions"}],"predecessor-version":[{"id":5983,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/847\/revisions\/5983"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=847"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=847"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}