MYSQL Basics to know ….PART -2

 

MYSQL Basics to know ….PART -2

LoL…I used my YouTube channel name for syntax.

YOUTUBE CHANNEL

REVERSE(): This command reverses a string.

REVERSE( ) syntax

SUBSTRING( ): It works with parts of strings.

SUBSTRING( ) syntax

UPPER(): Converts a string into upper-case.

UPPER( ) syntax

LOWER( ) : Converts a string into lower-case.

LOWER( ) syntax

CONCAT () : This command adds two or more strings together.

CONCAT( ) syntax

CONCAT_WS (): Concat two or more strings into one string with a separator.

CONCAT_WS ( ) syntax

REPLACE( ): Replaces parts(characters)of a string with another set of characters.

REPLACE( )syntax

DISTINCT( ): It collects unique values and it won’t show any duplicate values in the table.

DISTINCT( ) syntax

ORDER BY( ): This command is used to sort the values in Ascending or Descending order. ASC -Ascending order, DESC-Descending order. In the below syntax the output shows in ascending order. Ascending by default.

ORDER BY( ) syntax in Ascending order

DESC -Descending order

ORDER BY( ) syntax in Descending order

LIMIT( ): It shows several records or number of values as specified in the syntax.

LIMIT( ) -It shows only 3 values(titles) in a table
LIMIT( ) -It shows only 1 record(row)

LIKE ( ): This command shows exact matching values/pattern matching. In the below syntax ‘%a%’- Finds any value that has “a” in any position.

LIKE( ) command

‘e%’-finds any values that start with e.

LIKE( ) command

‘%y’-finds any values that end with y.

LIKE( ) Command

GROUP BY( ): It groups rows that have the same values in the table.

Inserted another value in the table

INSERTED another value in the table

Over here GROUP BY command takes both the rows as one because of same title,author_fname,author_lname,released_year,stock_quantity,pages-‘To Kill a Mockingbird’,’christopher’,’sergel’,1970,42,128.

GROUP( ) syntax

Comments

Post a Comment

Popular posts from this blog

MYSQL - “LIKE operator”

Image
  MYSQL - “LIKE operator” The LIKE operator is used in a WHERE clause to search for a pattern in a column. Two wildcards are often used while using the LIKE operator: Percentage sign( % ) — it represents multiple characters ,zero ,one. Underscore sign( _ ) — it represents single character. Create database before creating a table. commands : CREATE DATABASE pannts_db, USE pants_db creating pants_db table and inserting values LIKE ‘J%’ — finds any value that starts with “J” In the below syntax it shows the values from “ Article column ” where the value starts with “J” .  LIKE ‘J%’.  It shows only those values as per the condition described. LIKE ’J%’ LIKE ‘%e’ — finds any values that ends with “e” In the below syntax it shows the values from “ color column ” where the value ends with the letter ”e”.  LIKE ‘%e’.  It shows only those rows as per the condition described. LIKE ‘%e’ LIKE ‘%a%’ — finds any values that have or in any position. In the below syntax it show...
Read more