Skip to content
  • About Author
  • About UgtWorld
  • Privacy Policy
  • The Era of Techno
  • Write With Us
Ugt world

Ugt world

Flow of Emotion

  • Artificial Intelligence Free Course
  • Google Explore
    • Career Opportunities
    • Travel and Roaming
    • Physical and Mental Health
    • Sci-Fi
  • हिंदी
    • हिंदी लेख
    • हिंदी लघु-लेख
    • हिंदी कथा
    • हिंदी कविताएँ
    • हिंदी शायरी
      • Love Shayari
      • Friendship Shayari
      • Sad-Heartbroken Shayari
      • Motivational Shayari
      • Life Shayari
      • Chai Shayari
      • Khubsurati Shayari
  • मराठी
    • मराठी लेख
    • मराठी लघु-लेख
    • मराठी लघु-लेख : २
    • मराठी कथा
    • मराठी कविता
    • मराठी चारोळ्या
      • चारोळ्या – प्रेम
      • चारोळ्या – पहाट
      • चारोळ्या – रात्र
      • चारोळ्या – आयुष्य
    • मराठी सुविचार
  • English
    • Quotes
      • Inspirational Quotes
      • Motivational Quotes
      • Life Quotes
      • Attitude Quotes
      • Love Quotes
      • Happy Quotes
      • Sad Quotes
    • Blogs
      • Social Awareness
      • Motivational
      • Life Lessons
      • Love
      • Friendship
    • Micro Blogs
    • Micro Blogs 2
    • Story
    • English Poetry
  • Banking and Finance
  • The Era of Techno
    • Social Engineering Attacks
    • Java
      • Introduction of Java, the technological language…
      • Set-up of Java
    • MySQL
    • Spring
  • Fashion Design
  • Write With Us
    • Suhani’s Write-ups
    • Revathi ‘s Write-ups
    • Rachna’s Blog
    • Pooja’s Write-ups
    • Komal’s Write-ups
    • Tanaya Talks
    • AKWrites
    • Rutuja’s Write-ups
    • Samreen ‘s Write-ups
    • शायAr
      • Marathi Blogs
      • Marathi Story
      • Hindi Blogs
      • English Blogs
      • English Stories

Category: MySQL

  • Home
  • Era of Techno
  • Database
  • MySQL
  • Page 2
Blogs Database Era of Techno MySQL

Custom Function in MySQL 

March 30, 2023March 30, 2023 ugtworld

How to Create a Custom Function in MySQL? We have seen that MySQL has some predefined functions to use and get the required values. But

Read More
Blogs Database Era of Techno MySQL

Null functions in MySQL

March 23, 2023March 23, 2023 ugtworld

What are the Null functions present in MySQL? We have two null functions as below in the mysql 1. IFNULL() 2. COALESCE() We will see

Read More
Blogs Database Era of Techno MySQL

INSERT INTO SELECT statement in MySQL

March 15, 2023March 15, 2023 ugtworld

Why is the INSERT INTO SELECT statement used? If we want to copy data selected from one table to another, we can use MySQL INSERT

Read More
Blogs Database Era of Techno MySQL

MySQL CASE Statement

March 5, 2023March 5, 2023 ugtworld

What is MySQL CASE statement? MySQL CASE statement is a similar switch case where if any condition is ‘true’ then that respective value is returned

Read More
Blogs Database Era of Techno MySQL

EXISTS/ANY/ALL Operators in MySQL

March 1, 2023March 1, 2023 ugtworld

What is the use of EXISTS/ANY/ALL Operators in MySQL EXISTS/ANY/ALL Operators in MySQL are used along with the where condition to check if the condition

Read More
Blogs Database Era of Techno MySQL

MySQL HAVING

February 15, 2023February 15, 2023 ugtworld

What is MySQL HAVING? This is similar to the WHERE clause in MySQL but since we can not use the aggregate function in the WHERE

Read More
Blogs Database Era of Techno MySQL

MySQL GROUP BY

February 9, 2023February 9, 2023 ugtworld

How to use MySQL GROUP BY? As name suggested MySQL GROUP BY is used to group the rows with the same values of defined columns

Read More

Posts pagination

Previous 1 2 3 … 5 Next

Aapsi Baatchit aur Kissein / आपसी बातचीत और किस्से

Aapsi Baatchit aur Kissein / आपसी बातचीत और किस्से
Shop now on Notion Press, Amazon and Flipkart

Write With Us

Write with us

AMAZON BANNER

Follow Us

Copyright ©2024 Ugtworld. All rights reserved.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.