SQL language also includes syntax to update, insert, and delete records. These query and update commands together form the Data […]
Category: mysql
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 define […]
Characteristics of SQL Commands
Here you can see that SQL commands follow a number of basic rules: • SQL keywords are not normally case […]
SQL Commands
There are three groups of commands in SQL: 1. Data Definition 2. Data Manipulation and 3. Transaction Control
What is SQL?
Structured Query Language, commonly abbreviated to SQL and pronounced as “sequel”, is not a conventional computer programming language in the […]
PHP MySQL connector
PHP MySQL connector Example: <html> <head> <title>Connecting MySQL Server</title> </head> <body> <?php $dbhost = ‘localhost:3306’; $dbuser = ‘guest’; $dbpass = […]
LOCATE() – MySQL Function
LOCATE() – MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string. […]
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 […]
CONCAT() Function – MySQL
CONCAT() Function – MySQL MySQL has the CONCAT() function, which allows you to concatenate two or more strings. The function […]
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: […]