Category >
MYSQL
|| Published on :
Monday, February 29, 2016 || Views:
11036
||
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