MySQL is an Open Source Relational Database management system. It can be freely downloadable from MySQL.org and can be used for development and learning.
In MySQL we can create Databases. Inside Database we can create lots of objects like Tables, Views, Procedures, Sequence and triggers.
Let's understand the concept of Database and tables in this tutorial.
Basic definition of Database and table is:
To manage the school functioning online we have to create the database of school and store the information of students, teachers and other support staff in the form of tables.
Now let's see how to store all the information in MySQL database.
There are 2 things you must know, one is SYNTAX and second is correct way to write it.
So Lets start how to create the Database ...
In MySQL we can create Databases. Inside Database we can create lots of objects like Tables, Views, Procedures, Sequence and triggers.
Let's understand the concept of Database and tables in this tutorial.
Basic definition of Database and table is:
- Database is collection of tables or views or procedures or triggers etc.
- Tables are the collections of columns and rows, where columns are the heading or attributes which tells us what kind of data we can store in a table. we will see the example latter on.
To manage the school functioning online we have to create the database of school and store the information of students, teachers and other support staff in the form of tables.
Now let's see how to store all the information in MySQL database.
There are 2 things you must know, one is SYNTAX and second is correct way to write it.
So Lets start how to create the Database ...
NEXT
No comments:
Post a Comment