Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL Syntax

MySQL Syntax

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

Preview this deck

Always have a column name after a function

Front

1 / 20

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

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (20)

Section 1

(20 cards)

Always have a column name after a function

Front

Back

Non-Correlated Subquery

Front

processing the inner query first, then checking the outer query, so there is no join clause inside the query, but outside

Back

Existential Qualifier

Front

this checks if the item is in the list, and it returns a true or false statement depending on if the item is in the row don't put anything before exists EXISTS (...)

Back

Having Function

Front

used after a group by function usually

Back

What is a Cartesian Produt

Front

it is just simply all the rows multiplied by each other, this pops up if you dont join the table correctly

Back

Adding Table Rows + What to do if there's a Null? Or if you want to put only in specific columns?

Front

INSERT INTO table name (columnname1, columnname2) VALUES (value1, value2); if theres a null you write null, if you want to put it into a specific column

Back

Comparison Operator: <>

Front

not equal to

Back

And/Or Statement

Front

this is used to link two conditions, for and, if must be satisfied, for or it doesn't have to be don't forget to specify what comes after

Back

Deleting Table Rows

Front

DELETE FROM tablename WHERE insert column name = condition

Back

Delete Tables from Database

Front

DROP TABLE tablename

Back

Distinct Function

Front

eliminates all duplicate rows.. just put it infant of whatever you want to make distinct

Back

Create Table Statement

Front

CREATE TABLE table name ( columnname1 datatype constraint PRIMARY KEY ( column name) FOREIGN KEY table name ( column name ) REFERENCES table name (columnname);

Back

Ordering Output

Front

this goes to order the column in whatever order you want ORDER BY column name DESC, column 2 DESC

Back

IN/Not In Function

Front

this is used for a list of products. The part that is after the In function we are looking to see if that is in what is in front of it WHERE column name IN (.....,.....)

Back

Updating Table Rows

Front

UPDATE table name SET column name = expression

Back

What is Restrict?

Front

this chooses a horizontal slice of data

Back

Correlated Subquery

Front

the inner query has a join statement and it processes over and over again

Back

Link a Recursive Table

Front

1. Make 2 Alias' 2. Think, what do the recursive and employees both share? 3. That thing they share is what comes after the period, and the two alias' go first

Back

Aggregate Functions usually use a Group By function at the end

Front

Back

Like/Not Like

Front

if you want to pattern match and compare a value in a column with its parent's to find the single character you use "_", to do anything you use "%".. unless its the first letter there should be one of those in front and after the list WHERE column name LIKE '%what you wanna find%'

Back