Import and Export Data To MySQL Using Command Line

Import and export data in MySQL using command line tool

2, In development, some times import and export to mysql database table is seems to be easier when you are a system admin. But in most of the cases we always prefer the UI tool of PhpMyAdmin to import and export data. Just think at some situation when we don’t have any browser to … Read more

How to Add Comments on Columns of MySQL Table

Add Comments on Columns MySQL Database Table

11, Sometimes if we are handle large projects in development, then at database level we need to add comments on columns to understand about the supported values. This gives the better vision to get the concept of use of column in tables. What we mean by adding comments on columns to MySQL tables ? … Read more

Learn About 10 Basic Commands of MySQL for Beginners

10 Basic Commands to Start with MySQL - PhpMyAdmin

8, MySQL is a database management tool which manages databases and it’s relations. MySQL commands are very easy to learn in comparison of other available database management software. It is used to store, organize data and in data retrieval processes. It is handled by both – via MySQL Shell + MySQL commands. Inside this … Read more

Basics Overview of MySQL Stored Procedures

MySQL Stored Procedure Basics

4, Inside this article we will discuss about Basics Overview of MySQL Stored Procedures. Additionally, we will see how to create using PhpMyAdmin Interface Tool. MySQL stored procedures are a method of encapsulating SQL statements into a reusable, modular package. They are created and saved in the database, where they can be called by … Read more