MySQL Tutorial – Part 5 – Nested Tables – Foreign Key in MySQL

MySQL Tutorial – Part 5 – Nested Tables with Foreign Key As mentioned in the previous lessons, building optimal tables is very important in database design. Nested tables are very effective in reducing database size. For this reason, in this talk we will teach you how to build a foreign key in MySQL.     Nested Tables Definition In the example in Lesson 2 we created the following two tables to store information about our friends.   Row name last name Age Date of birth Profile code 1 Tofique Ahmed Soomro 40…

Read More

MySQL Tutorial – Part Four – Flags in MySQL

In this lesson we are going to talk about Flags in MySQL. In the previous lesson we learned how to add a table to the database. If you remember when creating the tables in the section below, check the expressions PK, NN and UQ as shown.     Now, because of the importance of this section, we will briefly explain the functional flags.   PK – Primary Key When you create a table you must define a key for each row of the database. This means that we render each database row with…

Read More

MySQL Tutorial – Part Three – MySQL Workbench

Creating a Table in MySQL Workbench In this lesson, we are going to build our first database table with the MySQL Workbench tool. First we need to create our new schema in MySQL. To practice the tables we will build the previous lesson together.   Open MySQL Workbench To open the program go to the Start menu in your Windows and click the MySQL Workbench option in the MySQL folder. You can also open the program by going to the Notification Area in your Windows by clicking on the MySQL form like…

Read More

MySQL Tutorial – Part Two – Schema and Table

In this section of MySQL tutorial we will briefly introduce Tables. In general, each database consists of structures called Schema. Schemes have different sizes and sections on which different processes or views can be defined. MySQL tutorial MySQL Tutorial – Part 1 – Installation MySQL Tutorial – Part 2 – Schema and Table MySQL Tutorial – Part 3 – MySQL Workbench MySQL Tutorial – Part 4 – Flags in MySQL MySQL Tutorial – Part 5 – Nested Tables with Foreign Key Each Schema can have different tables or tables to store information.…

Read More

Introducing The CouchDB Database

  CouchDB is also a member of the NoSQL family, and it can be said that there are differences between families. CouchDB was first released in 2005, but it was owned by Apache in 2008. CouchDB, originally developed with the C ++ programming language, was later translated into Erlang in 2008. Like other members, this database is a documentary database that stores data in the document using the JSON format. This database began with the slogan “A database that accepts the concept of the Web”. You can read out the differences at a…

Read More

How To User Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. this tutorial will give a short overview. 01 – Login MySQL server and then user accounts 02 – click on “Edit privileges”   03 – change privileges How To Grant Different User Permissions Here is a short list of other common possible permissions that users can enjoy. ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the…

Read More

How to create new user account in MYSQL

01- go to “localhost” or IP “127.0.0.1” to login MySQL server and click “User accounts”   02 – go down and click “Add user accounts”     03 – MySQL User name “which do you need” and password “Example” or generate password to secure the MySQL database   04 – The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation.    05 – or select privileges type, which do you need…

Read More