Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
Structured Query Language 06

Structured Query Language 06

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(1)
(0)
10 cards
()
Section 1

Preview this deck

to return all columns and data types from a table

Front

1 / 10

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

1

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

to return all columns and data types from a table

Front

SHOW COLUMNS FROM tblName;

Back

to return an exact string

Front

SELECT * FROM tblName WHERE fieldName1 LIKE '%CA';

Back

to return columns that are indexed

Front

SHOW INDEX FROM tblName;

Back

to return a string in lower case

Front

SELECT LOWER ('string');

Back

to return a string with leading spaces removed

Front

SELECT LTRIM (' string ');

Back

to return a string in upper case

Front

SELECT UPPER ('string');

Back

to return the first 3 characters of fieldName1

Front

SELECT SUBSTRING (fieldName1, 1, 3) FROM tblName;

Back

to return an exact string using NOT

Front

SELECT * FROM tblName WHERE NOT fieldName LIKE '%CA';

Back

to return a string in reversed order

Front

SELECT REVERSE ('string');

Back

to return the length of a string

Front

SELECT LENGTH ('string');

Back