WHAT IS RDBMS?
RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table
Read moreMySQL
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: -12600
Read moreWeb Functionality
In addition to the core communications protocol used to send messages between client and server, web applications employ numerous different
Read more
How to Install LAMP Server on CentOS 8
LAMP, an acronym for Linux, Apache, MySQL, and PHP, is a popular free and open-source stack used by website administrators
Read more
mysql_secure_installation – MySQL Script
mysql_secure_installation – MySQL Script mysql_secure_installation is a shell script available on Unix systems, and enables you to improve the security of
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 SELECT
Read more MySQL LIKE Operator
MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a
Read 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 to
Read more
PHP mysql select average program example
PHP mysql select average program example PHP MySQL code to to calculate average. <!doctype html> <html lang=”en”> <head> <meta
Read more MySQL AVG() function
MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() function
Read more