SQL - Part 19 - upper() MySQL String Function

Показать описание

In this video, I have explained and practically demonstrated using the upper() built-in function of MySQL in SQL statements.

Рекомендации по теме

Комментарии

This channel is a great place to learn SQL.

sanjukumarguttedar

IF ANY ONE IS GETTING ERROR FOR UPPER(COUNTRY) THEN TRY UCASE(COUNTRY)

sujanm

Hi sir! i have a query. i have used the following sql expression
select upper (country) as country
from customers
where country between 'ARGENTINA' and 'MEXICO'
order by country;

This shows 49 entries in the column excluding MEXICO but when i run the expression

select upper (country) as country
from customers
where upper(country) between 'ARGENTINA' and 'MEXICO'
order by country;
It is showing 54 entries including MEXICO. can you please clear this doubt sir.
Thank You.

Clout_chasing_boy

How could we have to use for only one name want to upper() case ?

madhusudhanmadasu

Hi ! i need to fetch multiple columns in upper case without mentioning upper(country), upper(name), upper()description. can we pass upper(country, name, description)?? is it possible?

aneeshk

Getting error
Error in SQL:
Undefined function 'upper' in expression.

noelhopkins

Upper() is not working in w3schools... Use UCASE() function instead for same purpose.

ashokkumarpatel

SQL - Part 19 - upper() MySQL String Function

Stored procedures with output parameters Part 19

Stored procedure output parameters or return values Part 20

SQL - Part 19 - upper() MySQL String Function

Part 19: Starting with a SQL table...

Introduction to SQL Programming for Excel Users Part 19 - More CASE WHEN

Part 19 UpdateCheck property

Part 19 Copying data from one table to another table using SqlBulkCopy

SQL Tutorial Part 19 | SQL Variables: Basics and Usage | DECLARE Statement | Use of @ symbol

Part 19: Joins in MySql | #telugu #mysql

SQL Server Integration Services (SSIS) Part 19 - Parameters and deployment

SQL Queries With PhpMyAdmin (Union Operator)-Part:19

Part 19 Unintended updates in mvc

Part 19 SQL Server in Amharic Crash Course QA Master and Log files

Stored procedures in sql server Part 18

SQL Essentials Part - 19 | Like | Logical Operators |

Part 19 Creating and throwing strongly typed SOAP faults

Topic 03, Part 19 - An Overview of Joins and How to use INNER JOINS in SQL

SQL Interview Questions and answers Part 19 | SQL Scenario based Interview Question and Answer

Big Data on Spark | Tutorial for Beginners [Part 19] | Spark SQL | Great Learning

SSIS Tutorial Part 19-How to Load Data from Excel File to SQL Server Table in SSIS Package

Using optimistic concurrency when editing data in gridview - Part 19

SSRS Cascading Parameters In Reports Part 19

Part 19 - PostgreSQL Backup and Restore.

Part 19 Table Per Hierarchy TPH inheritance in entity framework with code first