Krishna

MySQL TRUNCATE Table MYSQL TRUNCATE statement removes the complete data without removing its structure. The TRUNCATE TABLE statement is used when you want to delete the complete data from a table without removing the table structure. Syntax: TRUNCATE TABLE  table_name; Example: This example specifies how to truncate a table. In this example, we truncate the table “cus_tbl”. … Read more

MySQL ALTER Table MySQL ALTER statement is used when you want to change the name of your table or any table field. It is also used to add or delete an existing column in a table. The ALTER statement is always used with “ADD”, “DROP” and “MODIFY” commands according to the situation. 1) ADD a … Read more

MySQL CREATE TABLE The MySQL CREATE TABLE command is used to create a new table into the database. A table creation command requires three things: Name of the table Names of fields Definitions for each field Syntax: CREATE TABLE table_name (column_name column_type…); Example: Here, we will create a table named “cus_tbl” in the database “customers”. Note: Here, NOT NULL … Read more

MySQL Drop Database You can drop/delete/remove a MySQL database easily with the MySQL DROP DATABASE command. It deletes all the tables of the database along with the database permanently. Syntax: DROP DATABASE database_name; Example: Let’s take an example to drop a database name “employees” DROP DATABASE employees; Now you can check that either your database is removed by executing … Read more

Installing MySQL on Windows Your downloaded MySQL is neatly packaged with an installer. Download the installer package, unzip it anywhere and run setup.exe. By default, this process will install everything under C:\mysql. Verify MySQL installation Once MySQL has been successfully installed, the base tables have been initialized, and the server has been started, you can … Read more

MySQL 13Runningand Shutting down MySQL Server MySQL 13Runningand Shutting down MySQL ServerFirst check if your MySQL server is running or not. You can use the following command to check it:                        ps -ef | grep mysqld If your MySql is running, then you will seemysqldprocess listed out in your result. If server is not running, … Read more

Perl Installation Notes The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module for each type of database server you want to … Read more

Installing MySQL on Linux Linux supports a number of different solutions for installing MySQL. Table  Linux Installation Methods and Information As an alternative, you can use the package manager on your system to automatically download and install MySQL with packages from the native software repositories of your Linux distribution. These native packages are often several … Read more

Overview of the MySQL Database Management Sysytem MYSQL – MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website (http://www.mysql.com/) provides the latest information about MySQL software. MySQL is a database management system. A database is a structured collection of data. It may be … Read more