Welcome to the MySQL Knowledge Base and Tutorial
get the difference between two timestamps in seconds
get the difference between two timestamps in seconds You could use the TIMEDIFF() and the TIME_TO_SEC() functions as follows: SELECT TIME_TO_SEC(TIMEDIFF('2010-08-20 12:01:00', '2010-08-20Read More »
mysql length function : calculate length of a column
mysql length function : calculate length of a column Function length() Return the length of the string Usages SELECT CustomerName,Read More »
Install mysql on centos linux
Install mysql on centos linux Reference : https://blog.eduguru.in/linux-2/install-lamp-server-apache-mysql-php-on-rhel-centos-scientific-linux-6-56-4 Install MySQL MySQL is an enterprise class, open source, world’s second most usedRead More »
MySQL conditional expression CASE
MySQL conditional expression CASE MySQL CASE expression is a conditional expression that allows you to construct conditions inside a query such as SELECT or WHERERead More »
mysql - sql query to fetch count of employee
mysql – sql query to fetch count of employee Read More »
MySQL 5.7 features
MySQL 5.7 features MySQL 5.7 is the best release ever of the world’s most popular open source database and providesRead More »
MySQL service uptime
MySQL service uptime Sometimes, we need to check the uptime for MySQL in our server. There are multiple methodRead More »
Replication with Different Master and Slave Storage Engines
Replication with Different Master and Slave Storage Engines It does not matter for the replication process whether the source tableRead More »
Executing SQL Statements from a Text File
Executing SQL Statements from a Text File The mysql client typically is used interactively, like this: shell> mysql db_name However,Read More »
MySQL : Dumping Data in SQL Format with mysqldump
MySQL : Dumping Data in SQL Format with mysqldump By default, mysqldump writes information as SQL statements to the standard output.Read More »
RANGE Partitioning in MySQL
RANGE Partitioning in MySQL What is Partitioning? Partitioning is a way in which a database (MySQL in this case) splitsRead More »
Download HeidiSQL
Download HeidiSQL Installer, 32/64 bit combined Portable version (zipped): 32 bit , 64 bit Microsoft Store App, 32 bit Sourcecode HeidiSQLRead More »
How can I check MySQL engine type for a specific database?
MySQL engine type for a specific database SHOW GLOBAL VARIABLES LIKE 'storage_engine' [xyz-ihs snippet="Discuss"]Read More »
Views in MySQL : MySQL Views
Summary: in this tutorial, you are going to learn about MySQL View. We will explain how MySQL implements views. MySQL supports database viewsRead More »
mysqld — The MySQL Server
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation.Read More »