MSQL String Functions

MySQL provided various functions to interact and modify the strings passed via arguments or fetched from tables. This article will go through all the available MSQL String Functions. Before that, let’s understand how exactly a string is treated in MySQL. MySQL...

MySQL Math Functions

In this article, we will discuss all available MySQL Math Functions. Math ABS() function MySQL’s abs() function is a Math function. The absolute value of a number is calculated using this function. Syntax: Select abs(num); Output: 11 Math ACOS() function The arc...

MySQL Date/Time Functions

MySQL Date/Time For storing a date or a date/time value in MySQL, the following data types are available: DATE – format YYYY-MM-DD DATETIME – format: YYYY-MM-DD HH:MI:SS TIMESTAMP – format: YYYY-MM-DD HH:MI:SS YEAR – format...

Table operation in MySQL

Introduction In the structural format, a table is used to organize data in the form of rows and columns and is used for both storing and presenting records. Worksheets in a spreadsheet application are like this. Three components are required for a table formation: The...

MySQL Interview Questions

MySQL Theoretical Interview Questions Below is a list of the most often asked MySQL interview questions and answers. 1) Which programming language was MySQL written in? Ans: MySQL is written in C and C++ and  yacc-based SQL parser is written in yacc. 2) What...