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
myisamchk: error: myisam_sort_buffer_size is too small MySQL Error while repair with myisamchk utility – recovering (with sort) MyISAM-table ‘tableName’ Data records: 10662929483 – Fixing index 1 myisamchk: error: myisam_sort_buffer_size is too small MyISAM-table ‘tableName’ is not fixed because of errors Try fixing it by using the –safe-recover (-o), the –force (-f) option or by not using … Read more
MySQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECT statement within UNION must have the same number of columns The columns must also have similar data types The columns in each SELECT statement must also be in the same order Example: Basic Query: SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2; … Read more
MySQL table join JOIN clause is used to combine rows from two or more tables, based on a related column between them. Different Types of SQL JOINs Here are the different types of the JOINs in SQL: (INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Return all records from … Read more
MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are % wildcards often used in conjunction with the LIKE operator: % – The percent sign represents zero, one, or multiple characters _ – The underscore represents a single character SELECT column1, column2, … Read more
MySQL SUM function The SUM() function returns the total sum of a numeric column. The SUM() function is an aggregate function that allows you to calculate the sum of a set of values or an expression. Syntax for SUM function would be as below: SELECT SUM(column_name) FROM table_name WHERE condition; You can also use distinct value while sum function SELECT SUM(distinct column_name) FROM table_name WHERE condition; If … Read more