{"id":10572,"date":"2022-03-22T23:08:44","date_gmt":"2022-03-22T20:08:44","guid":{"rendered":"https:\/\/flatlogic.com\/blog\/?p=10572"},"modified":"2022-04-06T15:11:10","modified_gmt":"2022-04-06T12:11:10","slug":"what-is-mysql","status":"publish","type":"post","link":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/","title":{"rendered":"What is MySQL?"},"content":{"rendered":"<h2 class=\"wp-block-heading\"><strong>MySQL: <\/strong>What is it?<\/h2><p><a href=\"https:\/\/www.mysql.com\/\">MySQL<\/a> is an open-source relational database management system that allows you to manage relational databases based on Structured Query Language (SQL) queries.&nbsp;It supports multiple platforms such as Windows, Ubuntu, Linux, macOS, etc. It was developed by Swedish company MySQL AB in 1994, which was acquired in 2008 by American tech company Sun Microsystems. Afterwards, in 2010 the American giant Oracle acquired Sun Microsystems, and since then MySQL de-facto belongs to Oracle.<\/p><p>The database is a structured set of data, for example, a straightforward shopping list or places to store massive quantities of information throughout a business network. The relational database is a digital repository that collects data and organizes it according to a relational model, where tables consist of rows and columns and the relationships between data items follow a strict logical structure.&nbsp;MySQL is a simple software toolkit we can use to perform, manage, and execute queries on such a database.&nbsp;<\/p><h2 class=\"wp-block-heading\"><strong>Why use MySQL?<\/strong><\/h2><p>MySQL is the most popular <a href=\"https:\/\/en.wikipedia.org\/wiki\/Relational_database\">RDBMS<\/a>, let&#8217;s look at why this is like that:<\/p><ul class=\"wp-block-list\"><li><strong>Easy-to-use. <\/strong>The only thing you should learn before using MySQL is a basic knowledge of SQL (Structured Query Language).<\/li><li><strong>Open-source. <\/strong>Virtually anyone can install, modify, and use MySQL because of its incredible ease of use. The source code uses the GPL, that is, the GNU General Public License, which specifies guidelines for what you can and can&#8217;t do with this application.<\/li><li><strong>High Productivity. <\/strong>MySQL is possibly the fastest database language, according to a multitude of standard tests.<\/li><li><strong>Scalability.<\/strong> MySQL supports multi-threading, meaning the ability of systems to easily operate on small and large quantities of data, clusters of machines, etc.&nbsp;<\/li><li><strong>Security.<\/strong> MySQL is composed of a strong security level of data that protects confidential data from attackers. The interface is also secure because it has a versatile password system and guarantees host-based validation before accessing the database.&nbsp;<\/li><li><strong>Multiple data types. <\/strong>MySQL contains many data types, like integers, float, double, char, varchar, text, blob, date, time, DateTime, timestamp, etc.<\/li><li><strong>Community.<\/strong> The community is very large, so if you get stuck anywhere then you can get help from the community.<\/li><li><strong>Client-Server Architecture. <\/strong>MySQL is a client-server based architecture and accessible from anywhere through networking, i.e. each machine communicates with the server via an Internet connection. The server handles requests from the client and returns the result to the client machine. Clients can send queries to remote servers using an Internet connection, but the main requirement is keeping the server active at the time.<\/li><\/ul> <a href=\"https:\/\/flatlogic.com\/generator\"><img decoding=\"async\" data-src=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding.png\" alt=\"Professional Vibe Coding\" class=\"banner-img lazyload\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 2560px; --smush-placeholder-aspect-ratio: 2560\/640;\" data-srcset=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding.png 2560w, https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding-600x150.png 600w, https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding-1024x256.png 1024w, https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding-768x192.png 768w, https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding-1536x384.png 1536w, https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/Introducing-professional-vibe-coding-2048x512.png 2048w\" data-sizes=\"auto\" data-original-sizes=\"(max-width: 2560px) 100vw, 2560px\"> <\/a><h2 class=\"wp-block-heading\"><strong>Who uses MySQL<\/strong><\/h2><p>MySQL is the most popular and useful database system, the largest and most important companies are probably choosing it such as:<\/p><ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.uber.com\/\">Uber<\/a><\/li><li><a href=\"https:\/\/twitter.com\/?lang=en\">Twitter<\/a><\/li><li><a href=\"https:\/\/slack.com\/\">Slack<\/a><\/li><li><a href=\"https:\/\/airbnb.com\/\">Airbnb<\/a><\/li><li><a href=\"https:\/\/www.pinterest.com\/\">Pinterest<\/a><\/li><li><a href=\"https:\/\/www.amazon.com\/\">Amazon<\/a><\/li><\/ul><p>Using the <a href=\"https:\/\/flatlogic.com\/projects\/new\">Flatlogic Platform<\/a> you can also generate an application with a MySQL database system.<\/p><h2 class=\"wp-block-heading\"><strong>How to create your app with Flatlogic Platform<\/strong><\/h2><h3 class=\"wp-block-heading\"><strong><em>Step 1. Choosing the Tech Stack<\/em><\/strong><\/h3><p>In this step, you&#8217;re setting the name of your application and choosing the stack: Frontend, Backend, and Database.<\/p><figure class=\"wp-block-image\"><img decoding=\"async\" data-src=\"https:\/\/lh6.googleusercontent.com\/U-RCWmWFykQdYBeGLar48dIq8ngI4UeJksGDiY358QWysshiGOmbFRH6_ESuha60QCKJ1LaJl1fEgFeQ51etmLJ2D7qirPaBvO1-sVUPyp5e-wXE7YEZpsAEREMmqQrZsoiqR3hh\" alt=\"What is MySQL: creating MySQL apps with Flatlogic Platform\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure><h3 class=\"wp-block-heading\"><strong><em>Step 2. Choosing the Starter Template<\/em><\/strong><\/h3><p>In this step, you&#8217;re choosing the design of the <a  data-ilj-link-preview=\"true\"  data-featured-image=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/06\/Post-Dark-11-600x600.png\"  data-excerpt=\"We are finally happy to share with you the results of the world&#039;s first study on how developers start a web application in 2022.\" href=\"https:\/\/flatlogic.com\/blog\/starting-a-web-app-in-2022\/\">web app<\/a>.<\/p><figure class=\"wp-block-image\"><img decoding=\"async\" data-src=\"https:\/\/lh4.googleusercontent.com\/1zr7CoMOZLGhTueMwpj4wK3SbF1ykg_6NX1FaxbezNAnZPEl1epUwtYWtxdhzk6KVuK77n02Xi7FBG4Sjbwu8fMqKEUZFvsOGcFbLsKeoTKZETq28zY06EpUGoyalqpqYzDiewvM\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure><h3 class=\"wp-block-heading\"><strong><em>Step 3. Schema Editor<\/em><\/strong><\/h3><p>In this part you will need to know which application you want to build, that is, <a href='https:\/\/flatlogic.com\/custom-crm'>CRM<\/a> or <a  data-ilj-link-preview=\"true\"  data-featured-image=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2021\/01\/Frame-158uypaP-600x450.png\"  data-excerpt=\"A list of ready-made e-commerce solutions to make an online store. Check the alternatives to Shopify, Magento, and other wll-known giants.\" href=\"https:\/\/flatlogic.com\/blog\/14-great-admin-panel-themes-for-e-commerce\/\">E-commerce<\/a>, also in this part you build a <a href=\"https:\/\/en.wikipedia.org\/wiki\/Entity%E2%80%93relationship_model\">database schema<\/a> i.e. tables and relationships between them.<\/p><p>If you are not familiar with database design and it is difficult for you to understand what tables are, we have prepared several ready-made example schemas of real-world apps that you can build your app upon modification:<\/p><ul class=\"wp-block-list\"><li>E-commerce app;<\/li><li>Time tracking app;<\/li><li>Books store;<\/li><li>Chat (messaging) app;<\/li><li>Blog.<\/li><\/ul><p>Like all databases in MySQL, there are such types of table relationships as relation_one, relation_many. You can enforce the relationships by defining the right foreign key constraints on the columns.<\/p><ul class=\"wp-block-list\"><li>Relation (one) &#8211; one-sided relation capable of storing one or another entity, for example, Employee: [{ name: &#8216;John&#8217;}].<\/li><li>Relation (many) &#8211; two-sided relation capable of storing any number of other entities, for example, Employee: [{ name: &#8216;John&#8217; }, { name: &#8216;Joe&#8217; }].<\/li><\/ul><figure class=\"wp-block-image\"><img decoding=\"async\" data-src=\"https:\/\/lh3.googleusercontent.com\/ocO_YUmTbpHo2XdbFbfHB-YtfB5E3Tik9wb5Zu52I-RaI8OjNaVqe4yptJPxE6tNrNm6PhE3F9jr5tc_KGsxUXxu4XWC76KT32FNF1kfbBmQRkK7ODBf_a_cXsSr1mvkzrQRdxGq\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure><p>Afterwards, you can deploy your application and in a few minutes, you will get a fully functional CMS application with a MySQL database system.<\/p>","protected":false},"excerpt":{"rendered":"<p>MySQL is a relational database management system. It&#8217;s an open-source product frequently used for managing relational databases on SQL queries. It supports a multitude of platforms such as Windows, Ubuntu, MacOS, and more. This article gives a brief overview of MySQL and some nuances you&#8217;ll want to keep in mind for building MySQL-based apps.<\/p>\n","protected":false},"author":24,"featured_media":10573,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"flatlogic_tldr":"Open-source RDBMS using SQL; supports Windows, Ubuntu, Linux, and macOS.\nDeveloped by MySQL AB (1994), acquired by Sun (2008), then Oracle via Sun (2010).\nChosen for ease, GPL licensing, performance, scalability, security, and rich data types.\nFlatlogic Platform generates and deploys MySQL-backed apps; a CMS can be live in minutes.","flatlogic_facts":[{"text":"MySQL supports Windows, Ubuntu, Linux, and macOS.","source":""},{"text":"MySQL was developed by MySQL AB in 1994.","source":""},{"text":"Sun Microsystems acquired MySQL AB in 2008.","source":""},{"text":"Oracle acquired Sun Microsystems in 2010; since then MySQL belongs to Oracle.","source":""},{"text":"Using Flatlogic Platform, you can deploy a CMS app with a MySQL database in a few minutes.","source":""}],"footnotes":""},"categories":[28],"tags":[268,117,102,79],"class_list":["post-10572","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guides","tag-flatlogic-generator","tag-mysql","tag-tutorial","tag-web-development"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.2 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is MySQL? - Flatlogic Blog<\/title>\n<meta name=\"description\" content=\"This article briefly explains what is MySQL, how to use it, where it fits the best, and a few ways to create an application with MySQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/flatlogic.com\/blog\/what-is-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is MySQL?\" \/>\n<meta property=\"og:description\" content=\"This article briefly explains what is MySQL, how to use it, where it fits the best, and a few ways to create an application with MySQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/flatlogic.com\/blog\/what-is-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Flatlogic Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/flatlogic\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-22T20:08:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-06T12:11:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1088\" \/>\n\t<meta property=\"og:image:height\" content=\"1088\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alesia S.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png\" \/>\n<meta name=\"twitter:creator\" content=\"@flatlogic\" \/>\n<meta name=\"twitter:site\" content=\"@flatlogic\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alesia S.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is MySQL? - Flatlogic Blog","description":"This article briefly explains what is MySQL, how to use it, where it fits the best, and a few ways to create an application with MySQL.","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:\/\/flatlogic.com\/blog\/what-is-mysql\/","og_locale":"en_US","og_type":"article","og_title":"What is MySQL?","og_description":"This article briefly explains what is MySQL, how to use it, where it fits the best, and a few ways to create an application with MySQL.","og_url":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/","og_site_name":"Flatlogic Blog","article_publisher":"https:\/\/www.facebook.com\/flatlogic","article_published_time":"2022-03-22T20:08:44+00:00","article_modified_time":"2022-04-06T12:11:10+00:00","og_image":[{"width":1088,"height":1088,"url":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png","type":"image\/png"}],"author":"Alesia S.","twitter_card":"summary_large_image","twitter_image":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png","twitter_creator":"@flatlogic","twitter_site":"@flatlogic","twitter_misc":{"Written by":"Alesia S.","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#article","isPartOf":{"@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/"},"author":{"name":"Alesia S.","@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/person\/4ea8cd13c3b9919c455be1f34183a0c9"},"headline":"What is MySQL?","datePublished":"2022-03-22T20:08:44+00:00","dateModified":"2022-04-06T12:11:10+00:00","mainEntityOfPage":{"@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/"},"wordCount":692,"commentCount":0,"publisher":{"@id":"https:\/\/flatlogic.com\/blog\/#organization"},"image":{"@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png","keywords":["Flatlogic Generator","MySQL","Tutorial","Web Development"],"articleSection":["Guides"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/flatlogic.com\/blog\/what-is-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/","url":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/","name":"What is MySQL? - Flatlogic Blog","isPartOf":{"@id":"https:\/\/flatlogic.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#primaryimage"},"image":{"@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png","datePublished":"2022-03-22T20:08:44+00:00","dateModified":"2022-04-06T12:11:10+00:00","description":"This article briefly explains what is MySQL, how to use it, where it fits the best, and a few ways to create an application with MySQL.","breadcrumb":{"@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/flatlogic.com\/blog\/what-is-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#primaryimage","url":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png","contentUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/03\/post_dark_1.png","width":1088,"height":1088,"caption":"What is MySQL - a detailed review by Flatlogic"},{"@type":"BreadcrumbList","@id":"https:\/\/flatlogic.com\/blog\/what-is-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/flatlogic.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is MySQL?"}]},{"@type":"WebSite","@id":"https:\/\/flatlogic.com\/blog\/#website","url":"https:\/\/flatlogic.com\/blog\/","name":"Flatlogic Blog","description":"Vibe-coding, AI Agents, Professional Software Development Services, Case Studies and More","publisher":{"@id":"https:\/\/flatlogic.com\/blog\/#organization"},"alternateName":"Flatlogic Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/flatlogic.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/flatlogic.com\/blog\/#organization","name":"Flatlogic","url":"https:\/\/flatlogic.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/62ea6de0b3469aa3d6ebb528-1.png","contentUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/62ea6de0b3469aa3d6ebb528-1.png","width":970,"height":257,"caption":"Flatlogic"},"image":{"@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/flatlogic","https:\/\/x.com\/flatlogic","https:\/\/www.instagram.com\/flatlogiccom\/","https:\/\/www.linkedin.com\/company\/flatlogic\/"]},{"@type":"Person","@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/person\/4ea8cd13c3b9919c455be1f34183a0c9","name":"Alesia S.","url":"https:\/\/flatlogic.com\/blog\/author\/alesya\/"}]}},"_links":{"self":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts\/10572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/comments?post=10572"}],"version-history":[{"count":5,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts\/10572\/revisions"}],"predecessor-version":[{"id":10589,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts\/10572\/revisions\/10589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/media\/10573"}],"wp:attachment":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/media?parent=10572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/categories?post=10572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/tags?post=10572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}