{"id":260,"date":"2026-06-17T06:57:01","date_gmt":"2026-06-17T06:57:01","guid":{"rendered":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/"},"modified":"2026-07-28T09:21:09","modified_gmt":"2026-07-28T07:21:09","password":"","slug":"ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti","status":"publish","type":"docs","link":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/","title":{"rendered":"Ce sunt trigger-ele MySQL \u0219i cum le folosesc?"},"content":{"rendered":"<p>Un <strong>trigger<\/strong> MySQL este un obiect asociat unei tabele, care se execut\u0103 automat c\u00e2nd are loc o anumit\u0103 ac\u021biune (<code>INSERT<\/code>, <code>UPDATE<\/code> sau <code>DELETE<\/code>), \u00eenainte sau dup\u0103 acea ac\u021biune.<\/p>\n<p>Pentru a crea trigger-e ai nevoie de privilegiul <code>TRIGGER<\/code> pe baza de date (pe g\u0103zduirea shared, acesta este de regul\u0103 disponibil pentru utilizatorul bazei tale).<\/p>\n<h3>Exemplu<\/h3>\n<pre><code>-- creeaz\u0103 o tabel\u0103\r\nCREATE TABLE people (age INT, name VARCHAR(150));\r\n\r\n-- trigger care corecteaz\u0103 v\u00e2rstele negative la 0, \u00eenainte de INSERT\r\nDELIMITER \/\/\r\nCREATE TRIGGER agecheck BEFORE INSERT ON people\r\nFOR EACH ROW\r\nBEGIN\r\n  IF NEW.age &lt; 0 THEN SET NEW.age = 0; END IF;\r\nEND\/\/\r\nDELIMITER ;\r\n\r\n-- test\r\nINSERT INTO people VALUES (-20, 'Sid'), (30, 'Josh');\r\nSELECT * FROM people;\r\n-- age: 0 (Sid), 30 (Josh)<\/code><\/pre>\n<p>Po\u021bi administra trigger-ele \u0219i din phpMyAdmin, tab-ul <strong>Triggers<\/strong> al bazei de date.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Un trigger MySQL este un obiect asociat unei tabele, care se execut\u0103 automat c\u00e2nd are loc o anumit\u0103 ac\u021biune (INSERT, UPDATE sau DELETE), \u00eenainte sau dup\u0103 acea ac\u021biune. Pentru a crea trigger-e ai nevoie de privilegiul TRIGGER pe baza de date (pe g\u0103zduirea shared, acesta este de regul\u0103 disponibil pentru utilizatorul bazei tale). Exemplu &#8211; &#8230; <a title=\"Ce sunt trigger-ele MySQL \u0219i cum le folosesc?\" class=\"read-more\" href=\"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/\" aria-label=\"Cite\u0219te mai multe despre Ce sunt trigger-ele MySQL \u0219i cum le folosesc?\">Cite\u0219te mai mult<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"whmcs_kb_id":591,"footnotes":""},"doc_category":[112],"doc_tag":[234,231,235,273],"class_list":["post-260","docs","type-docs","status-publish","hentry","doc_category-mysql-cpanel-whm","doc_tag-administrare","doc_tag-baza-de-date","doc_tag-mysql","doc_tag-phpmyadmin"],"year_month":"2026-07","word_count":133,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Adrian Firican","author_nicename":"techeditor1","author_url":"https:\/\/www.hostx.ro\/kb\/author\/techeditor1\/"},"doc_category_info":[{"term_name":"MySQL","term_url":"https:\/\/www.hostx.ro\/kb\/docs-category\/mysql-cpanel-whm\/"}],"doc_tag_info":[{"term_name":"administrare","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/administrare\/"},{"term_name":"baz\u0103 de date","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/baza-de-date\/"},{"term_name":"MySQL","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/mysql\/"},{"term_name":"phpMyAdmin","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/phpmyadmin\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Ce sunt trigger-ele MySQL \u0219i cum le folosesc? - Centrul de suport HostX<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/\" \/>\n<meta property=\"og:locale\" content=\"ro_RO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ce sunt trigger-ele MySQL \u0219i cum le folosesc? - Centrul de suport HostX\" \/>\n<meta property=\"og:description\" content=\"Un trigger MySQL este un obiect asociat unei tabele, care se execut\u0103 automat c\u00e2nd are loc o anumit\u0103 ac\u021biune (INSERT, UPDATE sau DELETE), \u00eenainte sau dup\u0103 acea ac\u021biune. Pentru a crea trigger-e ai nevoie de privilegiul TRIGGER pe baza de date (pe g\u0103zduirea shared, acesta este de regul\u0103 disponibil pentru utilizatorul bazei tale). Exemplu -- ... Cite\u0219te mai mult\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/\" \/>\n<meta property=\"og:site_name\" content=\"Centrul de suport HostX\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-28T07:21:09+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Timp estimat pentru citire\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\\\/\",\"url\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\\\/\",\"name\":\"Ce sunt trigger-ele MySQL \u0219i cum le folosesc? - Centrul de suport HostX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/#website\"},\"datePublished\":\"2026-06-17T06:57:01+00:00\",\"dateModified\":\"2026-07-28T07:21:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\\\/#breadcrumb\"},\"inLanguage\":\"ro-RO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Prima pagin\u0103\",\"item\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"InfoCentru\",\"item\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Ce sunt trigger-ele MySQL \u0219i cum le folosesc?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/\",\"name\":\"Centrul de suport HostX\",\"description\":\"tutoriale gazduire web, domenii web \u0219i servere\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ro-RO\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ce sunt trigger-ele MySQL \u0219i cum le folosesc? - Centrul de suport HostX","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/","og_locale":"ro_RO","og_type":"article","og_title":"Ce sunt trigger-ele MySQL \u0219i cum le folosesc? - Centrul de suport HostX","og_description":"Un trigger MySQL este un obiect asociat unei tabele, care se execut\u0103 automat c\u00e2nd are loc o anumit\u0103 ac\u021biune (INSERT, UPDATE sau DELETE), \u00eenainte sau dup\u0103 acea ac\u021biune. Pentru a crea trigger-e ai nevoie de privilegiul TRIGGER pe baza de date (pe g\u0103zduirea shared, acesta este de regul\u0103 disponibil pentru utilizatorul bazei tale). Exemplu -- ... Cite\u0219te mai mult","og_url":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/","og_site_name":"Centrul de suport HostX","article_modified_time":"2026-07-28T07:21:09+00:00","twitter_card":"summary_large_image","twitter_misc":{"Timp estimat pentru citire":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/","url":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/","name":"Ce sunt trigger-ele MySQL \u0219i cum le folosesc? - Centrul de suport HostX","isPartOf":{"@id":"https:\/\/www.hostx.ro\/kb\/#website"},"datePublished":"2026-06-17T06:57:01+00:00","dateModified":"2026-07-28T07:21:09+00:00","breadcrumb":{"@id":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/#breadcrumb"},"inLanguage":"ro-RO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostx.ro\/kb\/ce-sunt-triggerele-mysql-si-cum-sa-le-folosesti\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Prima pagin\u0103","item":"https:\/\/www.hostx.ro\/kb\/"},{"@type":"ListItem","position":2,"name":"InfoCentru","item":"https:\/\/www.hostx.ro\/kb\/docs\/"},{"@type":"ListItem","position":3,"name":"Ce sunt trigger-ele MySQL \u0219i cum le folosesc?"}]},{"@type":"WebSite","@id":"https:\/\/www.hostx.ro\/kb\/#website","url":"https:\/\/www.hostx.ro\/kb\/","name":"Centrul de suport HostX","description":"tutoriale gazduire web, domenii web \u0219i servere","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostx.ro\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ro-RO"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":3,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs\/260\/revisions"}],"predecessor-version":[{"id":6323,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs\/260\/revisions\/6323"}],"wp:attachment":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/doc_category?post=260"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/doc_tag?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}