Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

CRUD

memorize.ai (lvl 286)

(0)

8 cards

()

Section 1

Preview this deck

Delete and rule of thumb.

Front

1 / 8

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (8)

Section 1

(8 cards)

Delete and rule of thumb.

Front

SELECT * FROM cats WHERE name='egg'; DELETE FROM cats WHERE name='egg'; This will NOT change initial cat_id.

Back

Finding equal columns.

Front

SELECT cat_id, age FROM cats WHERE cat_id=age;

Back

Updating and rule of thumb.

Front

SELECT * FROM cats; UPDATE cats SET age=14 WHERE name='Misty';

Back

Word Size.

Front

It's reserved word because sql uses that word internally.

Back

Define where.

Front

SELECT * FROM WHERE name='BuCko';<==case insensitive; INT without quotes.

Back

DELETE FROM cats; vs DROP TABLE;

Front

DELETE would delete data form the table, but not the table which is the case with DROP.

Back

Aliases for displaying dat, but they don't affect data names.

Front

mysql> SELECT cat_id AS 'space space', name, age FROM cats;<=="" if there is a space SELECT cat_id AS id, name, breed FROM cats;<==without quotes

Back

What means "" in SELECT FROM <tablename>;?

Front

Select all columns. SELECT <tablename>,.. FROM <tablename>; Order matters.

Back