Welcome to the MySQL Knowledge Base and Tutorial
Install MySQL / MariaDB Server with PhpMyAdmin Centos 8
Install MySQL / MariaDB Server with PhpMyAdmin Centos 8 Install PHP, MySQL support package for PHP, and other PHP packagesRead More »
mysql is dead but subsys locked
MySQL is dead but subsys locked Issue Description: When tried to connect to MySQL or run any command. It DisplayedRead More »
How to check table Engine in MySQL
How to check table Engine in MySQL With the help of below query, we can check the table engine inRead More »
MySQL Addtime() : Adding time to datetime
MySQL Addtime() : Adding time to datetime The ADDTIME() function adds a time interval to a time/datetime and then returns theRead More »
Data Manipulation Language in SQL (DML)
SQL language also includes syntax to update, insert, and delete records. These query and update commands together form the DataRead More »
Data Definition Language (DDL) in SQL
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also defineRead More »
Characteristics of SQL Commands
Here you can see that SQL commands follow a number of basic rules: • SQL keywords are not normally caseRead More »
SQL Commands
There are three groups of commands in SQL: 1. Data Definition 2. Data Manipulation and 3. Transaction ControlRead More »
What is SQL?
Structured Query Language, commonly abbreviated to SQL and pronounced as “sequel”, is not a conventional computer programming language in theRead More »
PHP MySQL connector
PHP MySQL connector Example: <html> <head> <title>Connecting MySQL Server</title> </head> <body> <?php $dbhost = 'localhost:3306'; $dbuser = 'guest'; $dbpass =Read More »
LOCATE() - MySQL Function
LOCATE() – MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string.Read More »
time_to_sec MySQL function
time_to_sec MySQL function The TIME_TO_SEC() function converts a time value into seconds. SELECT TIME_TO_SEC(“19:30:10”); Output: 70210 SELECT TIME_TO_SEC(“-03:30:00”); Output: -12600Read More »
CONCAT() Function - MySQL
CONCAT() Function – MySQL MySQL has the CONCAT() function, which allows you to concatenate two or more strings. The functionRead More »
TIMEDIFF - MySQL Function
TIMEDIFF – MySQL Function This returns the difference between two datetime expressions: For example: SELECT TIMEDIFF(“2020-05-10 13:10:11”, “2020-05-05 13:10:10”); Output:Read More »
Truncate or Empty table in mysql from phpmyadmin
Truncate or Empty table in mysql from phpmyadmin phpMyAdmin is a free software tool written in PHP intended to handleRead More »