It is very easy to create a table in MySQL. You need to use the Create table statement to create a table in MySQL. Please check below example There are three main elements in creating a table: 1. Table name: Name you want to give to your table. You can select any name. 2. column: Column name in your table. 3. datatype: Type of data you are going to store in that column. But we can add more elements to a table. let's do a live example with a brief explanation: Let's explain these above statements: Table name: students columns: roll_no, student_name, student_address datatype: int, varchar Not Null: NOT NULL is used to prevent a user to create a record with a NULL value. If a user will try to create a record with NULL value then MySQL will display an error message. AUTO_INCREMENT: Field Attribute AUTO_INCREMENT tells MySQL to go ahead and add the next available number to the id field. PRIMARY KEY: Keyword PRIMARY KEY is used to define a column as a primary key.
Google Analytics (GA) is a free and powerful tool from Google that is used to monitor your website traffic. Once you will add your website to Google Analytics, you can view all insights of your site, in google analytics dashboard. But if you have created a WordPress website then you can easily integrate Google Analytics with your website dashboard. This means you can view all insights of your site, under your WordPress dashboard. Below is the list of top 5 google analytics wordpress plugins through which you can integrate Google Analytics with your WordPress website. Google Analytics Dashboard for WP by ExactMetrics (GADWP) GADWP is defined as one of the most popular plugins, with the highest number of active installations. Google Analytics Dashboard for WP enables you to track your sites using the latest GA tracking code and allows you to view key GA statistics in your WordPress dashboard. This plugin also helps you track specific events on your site. Some of these include emails, downloads, page scrolling depth, and affiliate links. You can even create HTML elements that allow you to track custom events and actions. One of the key features of Google Analytics Dashboard for WP is the
If you have a website, a blog, or an E-commerce website, you have probably heard about SSL Certificate. This is very important for your Business’s security! It’s very easy to find an SSL Certificate, but difficult to find the right one. Later on, understand what you are exactly paying for. This is because they have flooded the market. Most of the website owners/bloggers don’t have it easy finding the right SSL certificates either. Don’t you worry; I am here to help you. What is an SSL Certificate? First and foremost, let’s start with the basics. SSL stands for Secure Sockets Layer. This is also known as Digital Certificate. It acts like a PADLOCK, securing links between websites and web visitor’s browser. It ensures that any data that is passed between, remains secure and private. SSL is well known for preventing hackers from stealing private and personal information like names, phone numbers, credit cards numbers, addresses etc. It also prevents theft of money transactions, data transfers and logins. In simple terms, an SSL Certificate ensures that your content is safe! How does SSL Certificate work? It works by checking data trustworthiness in a server or a browser. It sends information to your
Tables provide a great way to display or present data in an easily understandable format. So many website owners want to add tables in WordPress. So without wasting any time, I will show you the best method to create a table in WordPress. Create a table in WordPress There are multiple ways to create a table in WordPress but in this article, I will show you the easiest way to create a responsive table in WordPress. We will use the Ninja tables plugin to create a table in WordPress. With this WordPress table plugin, you can create a responsive table in WordPress. So Let's start Step 1: Firstly we will install this plugin by going to Plugins >> Add new from WordPress dashboard. Then search for Ninja tables. Install and activate this plugin. Step 2: After installing the Ninja table plugin it’s time to create our first table. So go to NinjaTables >> All tables. Click on "create your first table" button. Step 3: After clicking the "create table" button, you will be redirected to a page where you need to enter the table title (table name) and table description. So please enter both table name and description as written
Do you want to create a WordPress Child theme? As a beginner, you might find it a bit difficult but after reading this article you will be able to create child theme very easily. In this article, you will get to know What is a child theme, Why it is important and How To Create WordPress Child Themes easily (With or without plugin). What is a child theme? As the name suggests child theme is directly related to its parent. WordPress child themes inherit all of the features & design elements from its parent theme. It helps you to fully customize your WordPress theme. Whatever changes you make in your child theme will not affect your base or parent theme but when you make changes in the parent theme, it will reflect in the child theme. Why you need a WordPress child theme? Whenever you update your parent theme, your customized code which you have written will be deleted automatically because all the files of the theme will be updated. so it would be better to always write your customized code in a child theme. I will give you one more example of the importance of a WordPress child theme.
In order to reach new heights in business, marketing is important. Similarly, Google Webmaster is important to get traffic from Google. Like all other apps from Google, a Webmaster is also a free tool. Almost all Website owners use Webmaster to have a look over the relation between their website and Google (as a search engine). Here I will be sharing a guide with you through which you easily Add your website’s sitemaps to Google Webmaster 2019. Before proceeding towards the guide, you need to create an account on Webmaster if you haven’t yet. Once you are logged in to webmaster account, you have to add your website and need to verify it. If you haven’t verified your website yet then you check our guide on "How to add a website in Google Webmaster 2019". Note: – Google Webmaster 2018’s layout and the interface was very different from Webmaster 2019 thus, it is recommended to read the guide as per your webmaster’s version. But 2019’s Webmaster has some more features than 2018’s webmaster. Now, let begin with the Guide Itself. Step 1# Login to your Google Webmaster account. The very first is to login into your Google webmaster with the
I hope you have already tried to change your WordPress Username but somehow you couldn’t. We will be sharing two different methods through which you can change your WordPress Username very easily. Although the complete procedure is not very complex but still it needs some special tools or we can say it has some particular steps to be followed. Earlier You might not have the proper knowledge but after reading this article you will become expert of changing WordPress Username. But if you are just reading this article just for gaining some knowledge then you have to understand What are the reasons that may lead you to change the Username? Why to change Username? Security could be a reason, if you had shared your important login details with someone back in the days then, changing your Username can add a new layer of security to your Website. While Installing the WordPress, you might have opted the “admin” username and now you want to change it. Sometimes, while selling a website personal name as a “username” can affect the impression on client thus, for your client you want to change. You might want to switch your username to something more relevant