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

Read More »
MySQL ALTER Table

Read More »
MySQL CREATE TABLE

Read More »
MySQL Drop Database

Read More »
Installing MySQL on Windows

Read 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

Read 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

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 »