MySQL Tutorial

Category > MYSQL || Published on : Monday, February 29, 2016 || Views: 9959 || MySQL Install MySQL Creating & Deleting Databases MySQL Creating & Deleting Tables MySQL Alter Table MySQL Insert and Select Data MySQL Updating and Deleting Data


Introduction

Here Pawan Kumar will explain MySQL Tutorial

Description

In previous post I have explained How to Access AppSettings in Code Behind File, Increse Decrease Font Size or Zoom In Zoom Out Text Size Using jQuery, Sql query Script to get the columns with datatype of tables with default values, Top Popular Open Source .Net Projects - Websites/Portals : Portal/CMS, Top Popular Open Source Forum ASP.Net Projects, Show Confirm Navigation using onbeforeunload event in javascript, and many more articles.

Now I will explain How to MySQL Tutorial

So follow the steps to learn MySQL Tutorial

MySQL is an open source database management system, and it is the world's most popular database system. It is used by many organizations including Google, Facebook, YouTube and many others. SQL stands for Structured Query Language and is a database programming language, and it is quite easy to learn. MySQL is currently owned by the Oracle Corporation, so do not get it confused with SQL Server which is owned by Microsoft.

MySQL Install

MySQL is available on Mac, Linux and Windows. You can download the Windows version here http://dev.mysql.com/downloads/installer/ (opens in new tab), however if you're on Mac or Linux your version should also be somewhere on the same website. Once you have downloaded the executable file run it and you should see the installation wizard.

Read more: http://www.thecodingguys.net/tutorials/mysql/mysql-install#ixzz41XEYGTrH

MySQL Creating & Deleting Databases

Creating databases is quite simple. Open the MySQL Command Line Client (from now on we will call this CLC or CLI) which can be found in the start menu. When you start it, you will find that it's a small application with a black background. It will tell you to enter your password, which is the password you entered at setup. Enter your password and then you should see something like this

Read more: http://www.thecodingguys.net/tutorials/mysql/mysql-creating-and-deleting-databases#ixzz41XEgm9LI

MySQL Creating & Deleting Tables

Our database CES currently has no tables. We will create a new table named Games. Before we create the table we must select the database:

Read more: http://www.thecodingguys.net/tutorials/mysql/mysql-creating-and-deleting-tables#ixzz41XEvLqHa

MySQL Alter Table

You can alter a table and change a column data type or add new columns, as well as other changes. The alter command will perform the action to add a new column. The syntax is:

Read more: http://www.thecodingguys.net/tutorials/mysql/mysql-alter-tables#ixzz41XF3FKDD

MySQL Insert and Select Data

must must A database is useless if you cannot add and retrieve data. This tutorial will cover how to insert and retrieve data. To insert data you use the following syntax:

Read more: http://www.thecodingguys.net/tutorials/mysql/mysql-inserting-and-selecting-data#ixzz41XFAEarO

MySQL Updating and Deleting Data

You can update and delete data using the the UPDATE and DELETE commands. To update a column the syntax is:

Read more: http://www.thecodingguys.net/tutorials/mysql/mysql-update-and-delete-data#ixzz41XFHwAl8

Conclusion:

So, In this tutorial we have learned, MySQL Tutorial