MySQL er et relationelt databasesystem, der anvendes verden over og er sandsynligvis det mest anvendte program i denne kategori. Softwaren er tilg\u00e6ngelig som en gratis open source-version og som en kommerciel version til forskellige operativsystemer. Mange webhostingudbydere tilbyder muligheden for at integrere MySQL som en del af deres pakker. Talrige dynamiske websteder bruger softwaren som grundlag.<\/p>\n
MySQL blev udviklet i 1994 af det svenske firma MySQL AB, som blev overtaget af Sun Microsystems i 2008. Siden 2010 har disse to virksomheder tilh\u00f8rt den californiske Oracle Corporation. Navnet er afledt af fornavnet p\u00e5 datteren af Michael Wildenius, en af virksomhedens grundl\u00e6ggere, som er datter af Michael Wildenius. Wildenius og Axmark begyndte at udvikle databasesystemet i 1994. Oprindeligt fungerede det som en klon til MySQL og var beregnet til at levere databaser af UNIREG-softwaren til webapplikationer. I 1995 blev der foretaget en intern udgivelse, og i 1997 blev programmet offentliggjort i version 3.1. Dette skulle signalere, at MySQL's kerne allerede havde en lang historie. Lige fra starten var softwaren i stand til at behandle store datam\u00e6ngder og var designet med henblik p\u00e5 fremragende ydeevne. Dette skete til dels p\u00e5 bekostning af tilg\u00e6ngelighed og stabilitet. I begyndelsen var funktionsudbuddet begr\u00e6nset, kun nogle f\u00e5 tabeltyper og ingen transaktioner var mulige. I januar 2001 kom version 3.23 p\u00e5 markedet, som muliggjorde transaktioner og havde to tabeltyper. Version 4.0 fulgte i marts 2003, 4.1 i slutningen af 2004 og MySQL 5.0 i oktober 2005, hver med udvidede funktioner. Version 5.1 blev udgivet i november 2008, efterfulgt af MySQL 5.6 i 2012. 5.7 fulgte i oktober, og version 5.7.17 blev udgivet i midten af december 2016.<\/p>\n
Det relationelle databasesystem er tilg\u00e6ngeligt b\u00e5de gratis som open source-version og som kommerciel version til forskellige operativsystemer. MySQL best\u00e5r af flere administrationsprogrammer, en database, brugergr\u00e6nseflader og biblioteker. I kombination med PHP og Apache danner det grundlaget for mange dynamiske websteder. Det er blevet installeret p\u00e5 mere end 50 millioner servere verden over. Google, Twitter, Facebook<\/a> & Co. bruger denne arkitektur og driver et stort antal MySQL-servere. Systemet k\u00f8rer p\u00e5 Windows, Linux, Unix, Mac OSX, i5\/Os, Open VMS og mere end 20 andre platforme. Mange webhostingudbydere tilbyder MySQL som en del af deres softwarepakker. Der findes en officiel manual, og der tilbydes gratis support i mange fora og brugergrupper. Oracle tilbyder supportlicenser p\u00e5 forskellige ydelsesniveauer til sin Enterprise Edition, men mod betaling. Det kombineres ofte med andre softwareapplikationer eller milj\u00f8er til hosting af dynamiske websteder.<\/p>\n Databasesystemet blev skrevet i programmeringssprogene C og C++. Den bruger kerner, der g\u00f8r det muligt at anvende flere tr\u00e5de. Softwaren kan derfor udnytte fordelene ved flere CPU'er, hvis de er til r\u00e5dighed. Der er garanti for h\u00f8j behandlingshastighed og optimal hukommelsesstyring. Samtidig kan du oprette og administrere flere databaser p\u00e5 \u00e9n MySQL-server. Antallet af tabeller varierer afh\u00e6ngigt af operativsystemet. Softwaren g\u00f8r det muligt at f\u00e5 adgang til dataposter samt at slette, \u00e6ndre eller tilf\u00f8je data. Individuelle databaser kan opdeles, hvilket kan forbedre arbejdshastigheden. Indholdsstyringssystemer kan bruge MySQL som en p\u00e5lidelig og kraftfuld database (f.eks. WordPress<\/a>, TYPO3, Drupal eller Joomla<\/a>).<\/p>\n MySQL lagrer, administrerer, viser og \u00e6ndrer data i tabeller, samtidig med at den fungerer som en klient-server. Det betyder, at den p\u00e5g\u00e6ldende database fungerer som en server. Databasesystemet fungerer hurtigt, er brugervenligt og stabilt. En anden fordel er dens mulighed for flere tr\u00e5de og flere brugere, nem autorisationsstyring og optimal ydeevne. Desuden er det meget fleksibelt, da det er kompatibelt med mere end tyve forskellige platforme.<\/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":"5037","_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\/da\/wp-json\/wp\/v2\/posts\/4311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/comments?post=4311"}],"version-history":[{"count":0,"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/posts\/4311\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/media\/898"}],"wp:attachment":[{"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/media?parent=4311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/categories?post=4311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhosting.de\/da\/wp-json\/wp\/v2\/tags?post=4311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Funktionerne i MySQL<\/h3>\n
Fordelene ved MySQL<\/h3>\n