MySQL Tutorial

MySQL Tutorial

Welcome to the MySQL Knowledge Base and Tutorial

 

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 Data
Read 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 define
Read More »

Characteristics of SQL Commands

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

SQL Commands

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

What is SQL?

Structured Query Language, commonly abbreviated to SQL and pronounced as “sequel”, is not a conventional computer programming language in the
Read 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: -12600
Read More »

CONCAT() Function - MySQL

CONCAT() Function – MySQL MySQL has the CONCAT() function, which allows you to concatenate two or more strings. The function
Read 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 handle
Read More »

Convert mysql table engine to innodb

Convert mysql table engine to innodb    
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 »

Install MySQL 8.0

How to Install MySQL 8.0 on CentOS 7 MySQL is an open-source free relational database management system (RDBMS) released under
Read More »

MySQL JOINS

mysql join 1MySQL JOINS MySQL JOINS are used with SELECT statement. It is used to retrieve data from multiple tables. It is
Read More »

Older Entries » For any query or issue, feel free to discuss on http://discuss.eduguru.in