Welcome to the MySQL Knowledge Base and Tutorial
MySQL DROP Table
MySQL DROP Table MYSQL DROP table statement removes the complete data with structure. Syntax: DROP TABLE table_name; Example: DROP TABLE cus_tbl; MySQL TRUNCATE TableRead More »
MySQL TRUNCATE Table
MySQL TRUNCATE Table MYSQL TRUNCATE statement removes the complete data without removing its structure. The TRUNCATE TABLE statement is usedRead More »
MySQL ALTER Table
MySQL ALTER Table MySQL ALTER statement is used when you want to change the name of your table or anyRead More »
MySQL CREATE TABLE
MySQL CREATE TABLE The MySQL CREATE TABLE command is used to create a new table into the database. A tableRead More »
MySQL Drop Database
MySQL Drop Database You can drop/delete/remove a MySQL database easily with the MySQL DROP DATABASE command. It deletes all theRead More »
Installing MySQL on Windows
Installing MySQL on Windows Your downloaded MySQL is neatly packaged with an installer. Download the installer package, unzip it anywhereRead More »
MySQL –Administration
MySQL 13Runningand Shutting down MySQL Server MySQL 13Runningand Shutting down MySQL ServerFirst check if your MySQL server is running orRead More »
Perl Installation Notes
Perl Installation Notes The Perl DBI module provides a generic interface for database access. You can write a DBI scriptRead More »
Installing MySQL on Linux
Installing MySQL on Linux Linux supports a number of different solutions for installing MySQL. Table Linux Installation Methods and InformationRead More »
MYSQL
Overview of the MySQL Database Management Sysytem MYSQL – MySQL, the most popular Open Source SQL database management system, isRead More »
myisamchk: error: myisam_sort_buffer_size is too small
myisamchk: error: myisam_sort_buffer_size is too small MySQL Error while repair with myisamchk utility - recovering (with sort) MyISAM-table 'tableName' Data records:Read More »
MySQL UNION Operator
MySQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECTRead More »
MySQL table join
MySQL table join JOIN clause is used to combine rows from two or more tables, based on a related columnRead More »
MySQL LIKE Operator
MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in aRead More »
MySQL SUM function
MySQL SUM function The SUM() function returns the total sum of a numeric column. The SUM() function is an aggregate function that allows you toRead More »