MySQL \u00e4r ett relationellt databassystem som anv\u00e4nds \u00f6ver hela v\u00e4rlden och \u00e4r f\u00f6rmodligen det mest anv\u00e4nda programmet i den h\u00e4r kategorin. Programvaran finns som en gratis version med \u00f6ppen k\u00e4llkod och som en kommersiell version f\u00f6r olika operativsystem. M\u00e5nga webbhotell erbjuder m\u00f6jligheten att integrera MySQL som en del av sina paket. M\u00e5nga dynamiska webbplatser anv\u00e4nder programvaran som grund.<\/p>\n
MySQL utvecklades 1994 av det svenska f\u00f6retaget MySQL AB, som 2008 f\u00f6rv\u00e4rvades av Sun Microsystems. Sedan 2010 tillh\u00f6r dessa tv\u00e5 f\u00f6retag det kaliforniska Oracle Corporation. Namnet \u00e4r ett f\u00f6rnamn p\u00e5 dottern till Michael Wildenius, en av f\u00f6retagets grundare. Wildenius och Axmark b\u00f6rjade utveckla databassystemet 1994. Ursprungligen var det en klon av MySQL och var t\u00e4nkt att tillhandah\u00e5lla databaser f\u00f6r UNIREG-programvara f\u00f6r webbapplikationer. 1995 gjordes en intern version och 1997 sl\u00e4pptes programmet i version 3.1. Detta var en signal om att MySQL:s k\u00e4rna redan hade en l\u00e5ng historia. Redan fr\u00e5n b\u00f6rjan kunde programvaran bearbeta stora datam\u00e4ngder och var utformad f\u00f6r utm\u00e4rkt prestanda. Detta skedde delvis p\u00e5 bekostnad av tillg\u00e4nglighet och stabilitet. I b\u00f6rjan var funktionaliteten begr\u00e4nsad, endast n\u00e5gra f\u00e5 tabelltyper och inga transaktioner var m\u00f6jliga. I januari 2001 sl\u00e4pptes version 3.23, som till\u00e5ter transaktioner och har tv\u00e5 tabelltyper. Version 4.0 f\u00f6ljde i mars 2003, 4.1 i slutet av 2004 och MySQL 5.0 sl\u00e4pptes i oktober 2005, alla med f\u00f6rb\u00e4ttrade funktioner. Version 5.1 sl\u00e4pptes i november 2008, f\u00f6ljt av MySQL 5.6 2012. 5.7 f\u00f6ljde i oktober och version 5.7.17 sl\u00e4pptes i mitten av december 2016.<\/p>\n
Det relationella databassystemet finns b\u00e5de gratis i en \u00f6ppen k\u00e4llkod och i en kommersiell variant f\u00f6r olika operativsystem. MySQL best\u00e5r av flera administrationsprogram, en databas, anv\u00e4ndargr\u00e4nssnitt och bibliotek. I kombination med PHP och Apache utg\u00f6r den grunden f\u00f6r m\u00e5nga dynamiska webbplatser. Det har installerats p\u00e5 mer \u00e4n 50 miljoner servrar v\u00e4rlden \u00f6ver. Google, Twitter, Facebook<\/a> & Co. anv\u00e4nder dess arkitektur och driver ett stort antal MySQL-servrar. Systemet fungerar p\u00e5 Windows, Linux, Unix, Mac OSX, i5\/Os, Open VMS och mer \u00e4n 20 andra plattformar. M\u00e5nga webbhotell erbjuder MySQL som en del av sina programpaket. Det finns en officiell handbok, och gratis support erbjuds i m\u00e5nga forum och anv\u00e4ndargrupper. Oracle erbjuder supportlicenser med olika prestandaniv\u00e5er f\u00f6r sin Enterprise Edition, men mot en avgift. Den kombineras ofta med andra program eller milj\u00f6er f\u00f6r att tillhandah\u00e5lla dynamiska webbplatser.<\/p>\n Databassystemet skrevs i programmeringsspr\u00e5ken C och C++. Den anv\u00e4nder k\u00e4rnor som g\u00f6r det m\u00f6jligt att anv\u00e4nda flera tr\u00e5dar. Programvaran kan d\u00e4rf\u00f6r utnyttja f\u00f6rdelarna med flera CPU:er, om de finns tillg\u00e4ngliga. H\u00f6g bearbetningshastighet och optimal minneshantering garanteras. Samtidigt kan du skapa och hantera flera databaser p\u00e5 en MySQL-server. Antalet tabeller som anv\u00e4nds varierar beroende p\u00e5 operativsystemet. Programvaran g\u00f6r det m\u00f6jligt att f\u00e5 tillg\u00e5ng till register, samt att radera, \u00e4ndra eller l\u00e4gga till uppgifter. Enskilda databaser kan delas upp s\u00e5 att arbetshastigheten kan f\u00f6rb\u00e4ttras. Inneh\u00e5llshanteringssystem kan anv\u00e4nda MySQL som en tillf\u00f6rlitlig och kraftfull databas (t.ex. WordPress<\/a>, TYPO3, Drupal eller Joomla<\/a>).<\/p>\n MySQL lagrar, hanterar, visar och \u00e4ndrar data i tabeller och fungerar samtidigt som en klient-server. Detta inneb\u00e4r att respektive databas fungerar som en server. Databassystemet fungerar snabbt, anv\u00e4ndarv\u00e4nligt och stabilt. En f\u00f6rdel \u00e4r ocks\u00e5 att den kan anv\u00e4ndas av flera tr\u00e5dar och anv\u00e4ndare, att den \u00e4r l\u00e4tt att hantera beh\u00f6righeter och att den har optimal prestanda. Dessutom \u00e4r den mycket flexibel eftersom den \u00e4r kompatibel med mer \u00e4n tjugo olika plattformar.<\/p>","protected":false},"excerpt":{"rendered":" MySQL ist ein weltweit verbreitetes relationales Datenbanksystem und die wohl am h\u00e4ufigsten genutzte Anwendung in dieser Kategorie. Erh\u00e4ltlich ist die Software als kostenlose Open-Source-Version sowie als kommerzielle Version f\u00fcr verschiedene Betriebssysteme. Zahlreiche Webhosting-Anbieter bieten die M\u00f6glichkeit, MySQL als Teil ihrer Pakete zu integrieren. Zahlreiche dynamische Webauftritte nutzen die Software als Grundlage. Die Geschichte und Entstehung […]<\/p>\n","protected":false},"author":1,"featured_media":898,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","inline_featured_image":false,"footnotes":""},"categories":[732],"tags":[83],"class_list":["post-4311","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lexikon","tag-mysql"],"acf":[],"_wp_attached_file":null,"_wp_attachment_metadata":null,"litespeed-optimize-size":null,"litespeed-optimize-set":null,"_elementor_source_image_hash":null,"_wp_attachment_image_alt":null,"stockpack_author_name":null,"stockpack_author_url":null,"stockpack_provider":null,"stockpack_image_url":null,"stockpack_license":null,"stockpack_license_url":null,"stockpack_modification":null,"color":null,"original_id":null,"original_url":null,"original_link":null,"unsplash_location":null,"unsplash_sponsor":null,"unsplash_exif":null,"unsplash_attachment_metadata":null,"_elementor_is_screenshot":null,"surfer_file_name":null,"surfer_file_original_url":null,"envato_tk_source_kit":null,"envato_tk_source_index":null,"envato_tk_manifest":null,"envato_tk_folder_name":null,"envato_tk_builder":null,"envato_elements_download_event":null,"_menu_item_type":null,"_menu_item_menu_item_parent":null,"_menu_item_object_id":null,"_menu_item_object":null,"_menu_item_target":null,"_menu_item_classes":null,"_menu_item_xfn":null,"_menu_item_url":null,"_trp_menu_languages":null,"rank_math_primary_category":null,"rank_math_title":null,"inline_featured_image":null,"_yoast_wpseo_primary_category":null,"rank_math_schema_blogposting":null,"rank_math_schema_videoobject":null,"_oembed_049c719bc4a9f89deaead66a7da9fddc":null,"_oembed_time_049c719bc4a9f89deaead66a7da9fddc":null,"_yoast_wpseo_focuskw":"mysql","_yoast_wpseo_linkdex":null,"_oembed_27e3473bf8bec795fbeb3a9d38489348":null,"_oembed_c3b0f6959478faf92a1f343d8f96b19e":null,"_trp_translated_slug_en_us":null,"_wp_desired_post_slug":null,"_yoast_wpseo_title":null,"tldname":null,"tldpreis":null,"tldrubrik":null,"tldpolicylink":null,"tldsize":null,"tldregistrierungsdauer":null,"tldtransfer":null,"tldwhoisprivacy":null,"tldregistrarchange":null,"tldregistrantchange":null,"tldwhoisupdate":null,"tldnameserverupdate":null,"tlddeletesofort":null,"tlddeleteexpire":null,"tldumlaute":null,"tldrestore":null,"tldsubcategory":null,"tldbildname":null,"tldbildurl":null,"tldclean":null,"tldcategory":null,"tldpolicy":null,"tldbesonderheiten":null,"tld_bedeutung":null,"_oembed_d167040d816d8f94c072940c8009f5f8":null,"_oembed_b0a0fa59ef14f8870da2c63f2027d064":null,"_oembed_4792fa4dfb2a8f09ab950a73b7f313ba":null,"_oembed_33ceb1fe54a8ab775d9410abf699878d":null,"_oembed_fd7014d14d919b45ec004937c0db9335":null,"_oembed_21a029d076783ec3e8042698c351bd7e":null,"_oembed_be5ea8a0c7b18e658f08cc571a909452":null,"_oembed_a9ca7a298b19f9b48ec5914e010294d2":null,"_oembed_f8db6b27d08a2bb1f920e7647808899a":null,"_oembed_168ebde5096e77d8a89326519af9e022":null,"_oembed_cdb76f1b345b42743edfe25481b6f98f":null,"_oembed_87b0613611ae54e86e8864265404b0a1":null,"_oembed_27aa0e5cf3f1bb4bc416a4641a5ac273":null,"_oembed_time_27aa0e5cf3f1bb4bc416a4641a5ac273":null,"_tldname":null,"_tldclean":null,"_tldpreis":null,"_tldcategory":null,"_tldsubcategory":null,"_tldpolicy":null,"_tldpolicylink":null,"_tldsize":null,"_tldregistrierungsdauer":null,"_tldtransfer":null,"_tldwhoisprivacy":null,"_tldregistrarchange":null,"_tldregistrantchange":null,"_tldwhoisupdate":null,"_tldnameserverupdate":null,"_tlddeletesofort":null,"_tlddeleteexpire":null,"_tldumlaute":null,"_tldrestore":null,"_tldbildname":null,"_tldbildurl":null,"_tld_bedeutung":null,"_tldbesonderheiten":null,"_oembed_ad96e4112edb9f8ffa35731d4098bc6b":null,"_oembed_8357e2b8a2575c74ed5978f262a10126":null,"_oembed_3d5fea5103dd0d22ec5d6a33eff7f863":null,"_eael_widget_elements":null,"_oembed_0d8a206f09633e3d62b95a15a4dd0487":null,"_oembed_time_0d8a206f09633e3d62b95a15a4dd0487":null,"_aioseo_description":null,"_eb_attr":null,"_eb_data_table":null,"_oembed_819a879e7da16dd629cfd15a97334c8a":null,"_oembed_time_819a879e7da16dd629cfd15a97334c8a":null,"_acf_changed":null,"_wpcode_auto_insert":null,"_edit_last":null,"_edit_lock":null,"_oembed_e7b913c6c84084ed9702cb4feb012ddd":null,"_oembed_bfde9e10f59a17b85fc8917fa7edf782":null,"_oembed_time_bfde9e10f59a17b85fc8917fa7edf782":null,"_oembed_03514b67990db061d7c4672de26dc514":null,"_oembed_time_03514b67990db061d7c4672de26dc514":null,"rank_math_news_sitemap_robots":"index","rank_math_robots":["index"],"_eael_post_view_count":"5033","_trp_automatically_translated_slug_ru_ru":null,"_trp_automatically_translated_slug_et":"mysql","_trp_automatically_translated_slug_lv":"mysql","_trp_automatically_translated_slug_fr_fr":null,"_trp_automatically_translated_slug_en_us":null,"_wp_old_slug":null,"_trp_automatically_translated_slug_da_dk":null,"_trp_automatically_translated_slug_pl_pl":null,"_trp_automatically_translated_slug_es_es":null,"_trp_automatically_translated_slug_hu_hu":null,"_trp_automatically_translated_slug_fi":"mysql","_trp_automatically_translated_slug_ja":"%e5%b7%ab%e5%a5%b3","_trp_automatically_translated_slug_lt_lt":null,"_elementor_edit_mode":null,"_elementor_template_type":null,"_elementor_version":null,"_elementor_pro_version":null,"_wp_page_template":"default","_elementor_page_settings":null,"_elementor_data":null,"_elementor_css":null,"_elementor_conditions":null,"_happyaddons_elements_cache":null,"_oembed_75446120c39305f0da0ccd147f6de9cb":null,"_oembed_time_75446120c39305f0da0ccd147f6de9cb":null,"_oembed_3efb2c3e76a18143e7207993a2a6939a":null,"_oembed_time_3efb2c3e76a18143e7207993a2a6939a":null,"_oembed_59808117857ddf57e478a31d79f76e4d":null,"_oembed_time_59808117857ddf57e478a31d79f76e4d":null,"_oembed_965c5b49aa8d22ce37dfb3bde0268600":null,"_oembed_time_965c5b49aa8d22ce37dfb3bde0268600":null,"_oembed_81002f7ee3604f645db4ebcfd1912acf":null,"_oembed_time_81002f7ee3604f645db4ebcfd1912acf":null,"_elementor_screenshot":null,"_oembed_7ea3429961cf98fa85da9747683af827":null,"_oembed_time_7ea3429961cf98fa85da9747683af827":null,"_elementor_controls_usage":null,"_elementor_page_assets":[],"_elementor_screenshot_failed":null,"theplus_transient_widgets":["tp-video-player"],"_eael_custom_js":null,"_wp_old_date":null,"_trp_automatically_translated_slug_it_it":null,"_trp_automatically_translated_slug_pt_pt":null,"_trp_automatically_translated_slug_zh_cn":null,"_trp_automatically_translated_slug_nl_nl":null,"_trp_automatically_translated_slug_pt_br":null,"_trp_automatically_translated_slug_sv_se":null,"rank_math_analytic_object_id":"719","rank_math_internal_links_processed":null,"_trp_automatically_translated_slug_ro_ro":null,"_trp_automatically_translated_slug_sk_sk":null,"_trp_automatically_translated_slug_bg_bg":null,"_trp_automatically_translated_slug_sl_si":null,"litespeed_vpi_list":["webhostinglogo.png"],"litespeed_vpi_list_mobile":["webhostinglogo.png"],"rank_math_seo_score":null,"rank_math_contentai_score":null,"ilj_limitincominglinks":null,"ilj_maxincominglinks":null,"ilj_limitoutgoinglinks":null,"ilj_maxoutgoinglinks":null,"ilj_limitlinksperparagraph":null,"ilj_linksperparagraph":null,"ilj_blacklistdefinition":null,"ilj_linkdefinition":["mysql"],"_eb_reusable_block_ids":null,"rank_math_focus_keyword":"mysql","rank_math_og_content_image":null,"_yoast_wpseo_metadesc":"MySQL ist ein weltweit verbreitetes relationales Datenbanksystem und die wohl am h\u00e4ufigsten genutzte Anwendung in dieser Kategorie.","_yoast_wpseo_content_score":null,"_yoast_wpseo_focuskeywords":null,"_yoast_wpseo_keywordsynonyms":null,"_yoast_wpseo_estimated-reading-time-minutes":null,"rank_math_description":"MySQL ist ein weltweit verbreitetes relationales Datenbanksystem und die wohl am h\u00e4ufigsten genutzte Anwendung in dieser Kategorie.","surfer_last_post_update":null,"surfer_last_post_update_direction":null,"surfer_keywords":null,"surfer_location":null,"surfer_draft_id":null,"surfer_permalink_hash":null,"surfer_scrape_ready":null,"_thumbnail_id":"898","footnotes":null,"_links":{"self":[{"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/posts\/4311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/comments?post=4311"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/posts\/4311\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/media\/898"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/media?parent=4311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/categories?post=4311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/sv\/wp-json\/wp\/v2\/tags?post=4311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Funktionerna i MySQL<\/h3>\n
F\u00f6rdelarna med MySQL<\/h3>\n