Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

CIS-151 MySQL commands

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

delete a table

Front

1 / 9

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (9)

Section 1

(9 cards)

delete a table

Front

DROP TABLE tablename (no undo)

Back

filter table

Front

WHERE (SELECT * FROM [tablename] where

Back

Make a table

Front

CREATE TABLE

Back

add a row to a table

Front

INSERT INTO [tablename]

Back

change data in a table

Front

UPDATE

Back

Temporarily combine tables

Front

JOIN

Back

display all tables in database

Front

show tables

Back

remove a row from a table

Front

DELETE

Back

finds specific information in a table

Front

SELECT * FROM [tablename]

Back