If you are a beginner or an experienced user, this MySQL beginner’s guide is a good resource. At some point while learning web development you need to know a bit of SQL or MySQL. Just like learning how to use the PHP framework, you need some knowledge of OOP or object oriented programming.
One of the advantages of the framework is the ORM, or object-relational converter. If you don’t know how native SQL and MySQL work, you will go upstream without rowing. With this in mind, let’s take a look at some of the resources to keep MySQL up to date and make sure you use the database.
The point of building a dynamic website is that you can connect to databases to store and retrieve information.
Here is a collection of MySQL tutorials at AlfinTech Computer, because MySQL is a relatively large topic of discussion, so we will cover many features of the language. We start with a basic introduction to MySQL, then move on to data types and the declarative nature of SQL. Continue on to the data definition language DDL, the data manipulation language DML, functions, operators, and many more.
MySQL, also known as My Sequel, is the world’s most popular open source database system. This relational database management system is the preferred database for many open source web projects like WordPress, Drupal, Joomla, phpBB, TYPO3, MODx, Google, Facebook, Twitter, Flickr, YouTube, etc.
Go ahead introduction to MySQL
MySQL is the world’s most popular open source database supporting a variety of applications in the technology industry. Of course, the blogging platform WordPress uses MySQL as its database technology, but MySQL goes far beyond simple blogging applications.
Some of the biggest tech companies, including Twitter, Facebook, Etsy, and others, use MySQL. I also love writing PHP natively or using MySQL with great frameworks like Laravel or Codeigniter. These frameworks are useful for hiding details about how MySQL works in the background.
This is great, but it’s really important to understand the basics well. In this series of articles, we’ll take a closer look at what MySQL is, how it works, and how you can use it’s capabilities.
Get to know the Command Line on MySQL that you will work with it
Applications like phpmyadmin, MySQL Workbench, and sequel pro are really great tools for working with MySQL, but the best way to really jump into the tech is to explore everything you have to offer right from the command line, and let’s look at the first command.
show_databases;
https://gist.github.com/7c485af89619efc45354778c0f9727af
Congratulations! I have just executed my first command in MySQL from the command line. Think of it as a kind of welcoming world. You can see from the output that there are already many databases in this installation. Do not worry. Let’s create a new database and table from scratch.
Let’s get started with MySQL
Of course, the best way to learn MySQL is to install it on your local machine. Whether you’re using Mac, Linux or Windows, you have options. The example above is from a local install command line using wamp. For example, if you are accessing it from a wamp installation, you need to click on the wamp taskbar icon and then go to MySQL->MySQL Console.
What can you do if don’t have MySQL Installed?
As we said, the best way to work with the examples is to install MySQL on your local machine. On rare occasions, you can continue to practice the MySQL syntax online. In fact, some of these tools are also useful if you have MySQL installed locally, but need additional functionality.
Here you can quickly mock HTML and JavaScript to get some good code examples. You can skip the whole process, such as loading the local server and opening the IDE. Did you know that MySQL has great tools for this?
Database overview
One analogy when thinking of a database is to use a database versus a spreadsheet. It’s certainly not the same, but it has some things in common, and let’s figure it out.
- Data is stored in Columns and Rows
- Both can value new data based on current data
- Both have Multi User Capabilities
As a web developer’s daily life lacks abbreviations, we will add a few more abbreviations to our database toolkit. The following are the most common.
- DB: Database
- RDBMS: Relational Database Management System
- SQL: Structured Query Language
- DDL: Data Definition Language
- DML: Data Manipulation Language
- OLAP: Online Analytical Processing
- OLTP: Online Transactional Processing
- CRUD: Create Read Update Delete
You now have a basic understanding of a high-level overview of database technology. Now you can use MySQL from the command line. The first thing to do is look at the information_schema database, and let’s get started at the tables in this current database.
mysql> show tables from information_schema;
https://gist.github.com/4d4a2b3096ab0d23281eb3c6cdb31e74
Very sleek! You can see that you need to specify the database in which the table will be displayed. Let’s fix the problem by changing the database used.
mysql> use information_schema;
https://gist.github.com/90b3498d37f4c522c7b94bb12d6da098
mysql> show tables;
This gives you the same result, but now you do not have to specify which tables in the database you want to see. This is because I switched the database using the use command. You can go deeper and see the columns of various tables in the database. Let’s see how.
mysql> show columns from schemata;
https://gist.github.com/82594314e5ef1730e9ad1e1495535d00
MySQL can also use dot notation to view tables that are not part of the current database. Here’s how:
mysql> use mysql
https://gist.github.com/90b3498d37f4c522c7b94bb12d6da098
mysql> show columns from information_schema.schemata;
This gives the same output as the previous example, but first I changed the default database from information_schema to mysql. From there, we were able to get information about information_schema using dot notation to refer to it.
Getting Help with MySQL
If you run into problems at the command line, your first thought is to search the Google search bar. This isn’t really a bad idea. However, the built-in MySQL is a great help system to access. Let’s check it.
mysql> help show;
https://gist.github.com/933385a63c44260a269d9f064a0a5506
As you can see here, you will come across a huge amount of information related to the show command. This is a good overview with detailed examples. Finally, at the end of this output, a link is provided that will take you directly to the official documentation branch for more information. excellent.
Conclusion
This was a great introduction to database technology and MySQL. As we go through this series of web articles, we will dig even deeper to see if our database communication skills are at the highest level. When writing your own PHP or using a framework to give your application a level of persistence, you may encounter some bugs if you don’t know the basic principles of your application.
AUTHOR BIO
On my daily job, I am a software engineer, programmer & computer technician. My passion is assembling PC hardware, studying Operating System and all things related to computers technology. I also love to make short films for YouTube as a producer. More at about me…
Leave a Reply