MySQL Primary and Foreign keys.

Hello Friends,

This is one of my tutorials regarding the MySql primary and foreign keys. In this tutor I will be focusing on one of the main aspect of any database i.e. keys. Database keys are mostly used while accessing the database itself of its tables from any other source like web-application or simple code. This helps the developer to retrieve or manipulate the data from or in the database from the application itself using simple queries. Continue reading “MySQL Primary and Foreign keys.”

Import/Export sql Dump into Mysql.

Hello Friends,

This is one of my tutorial related to MySQL database. While using MySql database you may have come across this issue to import your data from one place to another. But how to do that when the data we have is smaller in size but what when the data is heavy. In such case Mysql provides the option to export your data as a dump (.sql file) and then import the same data into new server or new system. The import and export of MySQL database not only is important to recover the data when disaster strikes, but also provides an easy way to migrate or move to another server, such as when switching web hosting providers. Continue reading “Import/Export sql Dump into Mysql.”

MySql Command Prompt-Tips and Tricks.

Hello Friends,

This is another tutorial for some of the basic points to remember for using MySQL Database.

MySQL is a client-server Database management system, and so to use MySQL we need a client, an application that we will use to interact with MySQL is its command prompt.(giving it commands to be executed).

Every MySQL installation comes with a simple command-line utility called mysql. This utility does not have any drop-down menus, fancy user interfaces, mouse support, or anything like that. Continue reading “MySql Command Prompt-Tips and Tricks.”

MySql Installation

Hello Friends,

 

This is one of my tutorials related to database. You all must be familiar with MySQL, but still for those who have not learned about this, for them I will recall it in short.

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.The most important feature of this is that it is open-source  i.e. it does not require any licence to use. I can be easily downloaded from the internet for personal use. Hence some of the free software projects that require a full-featured database management system often use MySQL. Continue reading “MySql Installation”