RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields. RDBMS store the data into collection of tables, which might be related by common fields (database table columns). … Read more
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 PHP MySQL Program example of time_to_sec <!doctype html> <html lang=”en”> <head> <meta charset=”utf-8″> <meta name=”viewport” content=”width=device-width, initial-scale=1″> <title>example-time_to_sec-function – php mysql examples | w3resource</title> <meta name=”description” content=”PHP MySQL PDO Example”> <link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”> </head> <body> … Read more
In addition to the core communications protocol used to send messages between client and server, web applications employ numerous different technologies to deliver their functionality. Any reasonably functional application may employ dozens of distinct technologies within its server and client components. Before you can mount a serious attack against a web application, you need a … Read more
LAMP, an acronym for Linux, Apache, MySQL, and PHP, is a popular free and open-source stack used by website administrators and developers alike to test and host dynamic websites. The LAMP server comes with 4 core components: the Apache web server, MySQL or MariaDB database and PHP which is a popular scripting language that is … Read more
mysql_secure_installation – MySQL Script mysql_secure_installation is a shell script available on Unix systems, and enables you to improve the security of your MariaDB or MySQL installation in the following ways: You can set a password for root accounts. You can remove root accounts that are accessible from outside the local host. You can remove anonymous-user accounts. … Read more
MySQL UNION Operator The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECT statement within UNION must have the same number of columns The columns must also have similar data types The columns in each SELECT statement must also be in the same order Example: Basic Query: SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2; … Read more
MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are % wildcards often used in conjunction with the LIKE operator: % – The percent sign represents zero, one, or multiple characters _ – The underscore represents a single character SELECT column1, column2, … Read more
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 calculate the sum of a set of values or an expression. Syntax for SUM function would be as below: SELECT SUM(column_name) FROM table_name WHERE condition; You can also use distinct value while sum function SELECT SUM(distinct column_name) FROM table_name WHERE condition; If … Read more
PHP mysql select average program example PHP MySQL code to to calculate average. <!doctype html> <html lang=”en”> <head> <meta charset=”utf-8″> <meta name=”viewport” content=”width=device-width, initial-scale=1″> <title>Example of avg function in php MySQL – Blog.eduguru.in</title> <meta name=”description” content=”Example of avg function in php MySQL”> <link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css”> </head> <body> <div class=”container”> <div class=”row”> <div class=”col-md-12″> <h2>Example … Read more
MySQL AVG() function AVG function to calculate the average value of a set of values or an expression. The AVG() function returns the average value of a numeric column. If the function does not find a matching row, it returns NULL The DISTINCT option can also be used to return the average of the distinct values of expr. … Read more