MSQL String Functions

by | Apr 9, 2022 | Oracle, SQL

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

by | Apr 9, 2022 | Oracle, SQL

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

by | Apr 9, 2022 | Oracle, SQL

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 YYYY or YY DATE()...

Table operation in MySQL

by | Apr 8, 2022 | Oracle, SQL

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

by | Apr 8, 2022 | Interview, Oracle, SQL

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 are...
en English
af Afrikaanssq Albanianam Amharicar Arabichy Armenianaz Azerbaijanieu Basquebe Belarusianbn Bengalibs Bosnianbg Bulgarianca Catalanceb Cebuanony Chichewazh-CN Chinese (Simplified)zh-TW Chinese (Traditional)co Corsicanhr Croatiancs Czechda Danishnl Dutchen Englisheo Esperantoet Estoniantl Filipinofi Finnishfr Frenchfy Frisiangl Galicianka Georgiande Germanel Greekgu Gujaratiht Haitian Creoleha Hausahaw Hawaiianiw Hebrewhi Hindihmn Hmonghu Hungarianis Icelandicig Igboid Indonesianga Irishit Italianja Japanesejw Javanesekn Kannadakk Kazakhkm Khmerko Koreanku Kurdish (Kurmanji)ky Kyrgyzlo Laola Latinlv Latvianlt Lithuanianlb Luxembourgishmk Macedonianmg Malagasyms Malayml Malayalammt Maltesemi Maorimr Marathimn Mongolianmy Myanmar (Burmese)ne Nepalino Norwegianps Pashtofa Persianpl Polishpt Portuguesepa Punjabiro Romanianru Russiansm Samoangd Scottish Gaelicsr Serbianst Sesothosn Shonasd Sindhisi Sinhalask Slovaksl Slovenianso Somalies Spanishsu Sundanesesw Swahilisv Swedishtg Tajikta Tamilte Teluguth Thaitr Turkishuk Ukrainianur Urduuz Uzbekvi Vietnamesecy Welshxh Xhosayi Yiddishyo Yorubazu Zulu