mysql

Data Manipulation Language in SQL (DML)

August 11, 2020 Krishna Data Manipulation, Data Manipulation Language in SQL (DML), database, Database System, dbms, MySQL, SQL

SQL language also includes syntax to update, insert, and delete records. These query and update commands together form the Data

DBMS mysql

Data Definition Language (DDL) in SQL

August 11, 2020 Krishna Data Definition language, Data Definition Language (DDL) in SQL, Database System, dbms, MySQL, SQL

The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define

DBMS mysql

Characteristics of SQL Commands

August 11, 2020 Krishna Characteristics of SQL, Characteristics of SQL Commands, MySQL, SQL, SQL Commands

Here you can see that SQL commands follow a number of basic rules: • SQL keywords are not normally case

DBMS mysql SQL Server

SQL Commands

August 11, 2020 Krishna COMMANDS, Database System, dbms, MySQL, SQL, SQL Commands

There are three groups of commands in SQL: 1. Data Definition 2. Data Manipulation and 3. Transaction Control

DBMS mysql

What is SQL?

August 11, 2020 Krishna Database System, dbms, MySQL, SQL, SQL injection, What is SQL?

Structured Query Language, commonly abbreviated to SQL and pronounced as “sequel”, is not a conventional computer programming language in the

mysql

PHP MySQL connector

May 17, 2020 eduguru Both MySQLi and PDO have their advantages, Connecting MySQL Server, MySQL Examples in Both MySQLi and PDO Syntax, MySQLi Installation, Open a Connection to MySQL, PHP MySQL connector, Should I Use MySQLi or PDO

PHP MySQL connector Example: <html> <head> <title>Connecting MySQL Server</title> </head> <body> <?php $dbhost = ‘localhost:3306’; $dbuser = ‘guest’; $dbpass =

mysql

LOCATE() – MySQL Function

May 16, 2020 eduguru LOCATE() - MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string. If the substring is not found within the original string, String, this function returns 0. This function performs a case-insensitive search. LOCATE(substring

LOCATE() – MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string.

mysql

time_to_sec MySQL function

May 14, 2020 eduguru MySQL, mysql function, php mysql program, PHP MySQL Program example of time_to_sec, time_to_sec, 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

mysql

CONCAT() Function – MySQL

May 13, 2020 eduguru …) Arguments string1 First string to be joined. string2 Second string to be joined. Up to N number of strings can be specified this way. Here’s an example: SELECT CONCAT('Homer', ' ', '--> ', 'Simpson') AS 'Full Name'; Result: +---------------+ | Full Name | +---------------+ | Homer Simpson | +---------------+ SELECT CONCAT('Homer', 'Simpson') AS 'Full Name'; Result: +--------------+ | Full Name | +--------------+ | HomerSimpson | +--------------+ mysql> SELECT CONCAT(pub_city, but its main use is to concatenate two or more strings. CONCAT (string1, CONCAT() Function - MySQL, country) -> FROM publisher; +---------------------------------+ | CONCAT(pub_city, MySQL has the CONCAT() function, string2, which allows you to concatenate two or more strings. The function actually allows for one or more arguments

CONCAT() Function – MySQL MySQL has the CONCAT() function, which allows you to concatenate two or more strings. The function

mysql

TIMEDIFF – MySQL Function

May 12, 2020 eduguru This returns the difference between two datetime expressions: For example: SELECT TIMEDIFF("2020-05-10 13:10:11"

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:

← Previous