MySQL Tutorial Step By Step Part I
MYSQL Step by Step – Sagar Jaybhay
MySQL tutorial provides basic and advanced ideas of MySQL. Our MySQL tutorial is intended for beginners and professionals.
MySQL could be a computer database management system. it’s open-source and free.
Our MySQL tutorial includes all topics of MySQL information like insert record, update a record, delete record, choose record, produce table, drop table, etc. There also are given MySQL interview inquiries to assist you higher perceive the MySQL information.
What is MySQL
MySQL could be a quick, straightforward to use computer database. it’s presently the foremost standard open-source database. it’s very normally utilized in conjunction with PHP scripts to create powerful and dynamic server-side applications.
MySQL is employed for several little and large businesses. it’s developed, marketed and supported by MySQL AB, a Swedish company. it’s written in C and C++.
The name of MySQL is that the combination of My and SQL, MySQL.
MySQL could be a direction system that enables you to manage relative databases. it’s open-source package backed by Oracle. It means that you’ll use MySQL while not paying a dime. Also, if you would like, you’ll modification its source code to fit your desires.
Even though MySQL is open supply software package, you’ll obtain a billboard license version from Oracle to induce premium support services.
MySQL is pretty straightforward to master as compared with different information packages like Oracle information, or Microsoft SQL Server.
The official thanks to pronouncing MySQL is My Ess Que ell, not My Sequel. However, you’ll pronounce it no matter if you prefer, who cares?
Introduction to database
You contend with knowledge each day
When you need to pay attention to your favorite songs, you open your playlist from your smartphone. during this case, the playlist may be a database. When you take a photograph and transfer it to your account on a social network like Facebook, your image gallery may be a database.
When you browse associate eCommerce web site to shop for shoes, clothes, etc., you utilize the handcart database. Databases area unit everyplace. thus what’s a database? By definition, info is simply a structured assortment of knowledge.
The data relating to every different naturally, e.g., a product belonged to a product class and related to multiple tags. Therefore, we tend to use the term electronic information service. In the electronic information service, we tend to model knowledge like product, categories, tags, etc.using tables. A table contains columns and rows. it’s sort of a program.
A table might relate to a different table employing a relationship, e.g., one-to-one and one-to-many relationships.
Because we tend to contend with a major quantity of information, we’d like to outline the databases, tables, etc., and method knowledge additional with efficiency. Besides, we would like to show data into information. And this is often wherever SQL comes to play.
SQL – the language of the database
SQL stands for structured query language.
SQL is that the standardized language used to access the database.
ANSI/SQL defines the SQL commonplace. this version of SQL is SQL:2003. Whenever we tend
to visit the SQL standard, we tend to mean this SQL version.
SQL contains 3 parts:
1. Data definition language includes statements that assist you to outline the information and its objects, e.g., tables, views, triggers, stored procedures, etc.
2.information manipulation language contains statements that permit you to update and question data.
3. Data management language permits you to grant permissions to a user to access specific knowledge within the info.
Reasons for recognition
MySQL is turning into thus well-liked due to these following reasons:
MySQL is an open-source database thus you ought not to pay one penny to use it.
MySQL could be a terribly powerful program thus it will handle an over-sized set of functionality of the foremost expensive and powerful information packages. MySQL is customizable as a result of it’s an open-source database and also the open-source GPL license facilitates programmers to change the SQL software system consistent with their own specific surroundings.
MySQL is faster than alternative databases thus it will work well even with the big data set. MySQL supports several operating systems with several languages like PHP, PERL, C, C++, JAVA, etc. MySQL uses a typical kind of the well-known SQL data language. MySQL is extremely friendly with PHP, the foremost standard language for internet development.
MySQL supports giant databases, up to fifty million rows or a lot of in an exceeding table. The default file size limit for a table is 4GB, however, you will increase this (if your OS can handle it) to a theoretical limit of eight million terabytes (TB).