In this article, you will know what is Database? What is SQL? What is MySQL Database? And how wordpress and mysql database work together. With this, you will find a lot of new things about WordPress and after knowing all this, you will see it from a new perspective.
What is SQL?
The full form of SQL is Structured Query Language. This language is used to perform any operations on the database. To understand it well, you must first understand the database and queries.
What is a database?
First of all, you have to know what is Database:
In the words of Wikipedia, “The data stored on a computer system is called a computer database. These data are collected by following a particular method. Based on these figures, a question (curiosity) can be resolved quickly. A special computer language is used to ask questions. The data obtained as a solution to curiosity helps in making the right decisions. Computer programs that are used to store data on a computer, manage them (add data, modify, modify, etc.) and ask data-based questions are called database management systems (DBMS). "
- note: The word curiosity is called Query in Hindi.
So in this way a database is a system in which different types of data can be saved in the form of rows and columns in different tables, which can be fetched and also store data if needed in webpages. is. Now there are different types of Database, such as MySQL Database, MS Access, Oracle, Sybase etc.
Query is a very important thing associated with database, Query which will be very important for you to know, that is Query.
What is Query in Database Systems?
When we perform any operations in the database, we can see the database in instructions form of queries. For example, when we have to store a data in the database, queries are done for it and when a data is to be fetched, from the database it also gets queries.
A great example of this in the words of Wikipedia:
Query can be done on the database of employees of an organization, which employees are below 30 years of age and whose income is more than Rs 3 lakhs yearly.
The language of these queries is SQL. That is, we have to write queries in SQL language.
You may find all these things complicated right now, but all these things are very simple. I would recommend that you watch the video below to understand database and queries well.
What is MySQL? What is work in wordpress?
MySQL is a relational database management system so that we can create and manage databases. WordPress uses MySQL for database because MySQL is free and open-source software just like WordPress.
If you look at the classical way of installing WordPress on your web server or web hosting, in that first you have to create the database by going to the phpMyAdmin interface of MySQL and only then you can install WordPress.
Nowadays all the web hosting companies offer all the work in backend by offering one click wordpress installation in automated methods and you don't even know. If you want to see this process, you can watch the video below uploaded by us on our YouTube channel ShoutMeHindi:
To learn MySQL you can follow the below video series:
The WordPress database looks like the following screenshot in MySQL's phpMyAdmin interface:
In this case the MySQL database named shoutmehindi has been created by a fresh WordPress installation. This database has by default 12 tables as you can see in the screenshot. Each of these tables stores different information of WordPress.
For example I have given another screenshot below which is of a table named wp_posts, it contains data of all the posts you have written in wordpress.
To see this image well, click on it.
You will see that every post written on your WordPress blog will be in it, one by one in a row. If you look carefully, you will understand the meaning of each column and field. Like post_title has the title of your post and in post_content all the content of the post is in html form.
Similarly, if you store values of different things in different fields. If you install additional plugins, they also create their own separate tables. This is why the count of tables in the database of different WordPress blogs varies.
In the root directory of WordPress, all php files in the folder wp-admin contain instructions on how to fetch the data from the database and finally how to display it as a webpage. In WordPress, images and other media based data databases do not have a store, instead a wp-content folder contains a folder named uploads.
I hope you have learned a lot about WordPress and its database systems from this article. If you have interest about database systems, this is a very good thing, you can master this field by looking at the above video tutorials.
Let me know if you have any questions related to this post?
To show your happiness and excitement about our post, please post this post like Social Networks Facebook, Google+ and Twitter Share on etc.
By reading the first post below, you know about many other ways to put ads in your blog.
Subscribe to keep reading more similar informational posts and to get notifications about new blog posts.
Comment below to ask any kind of question related to this blog post.
Subscribe for more such videos