Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
1. Getting Started with MySQL

1. Getting Started with MySQL

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

Preview this deck

SELECT

Front

1 / 18

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 (18)

Section 1

(18 cards)

SELECT

Front

allows the user to retrieve existing records from a table

Back

DELETE

Front

allows the user to delete existing records from a table

Back

CREATE

Front

allows the user to create databases and tables

Back

-B

Front

run in batch mode

Back

-?

Front

list all of the available options

Back

DROP

Front

allows the user to delete entire tables and databases

Back

-h hostname

Front

specify a hostname to a remote database server

Back

UPDATE

Front

allows the user to update existing records in a table

Back

-N

Front

suppress column names from the result output

Back

-A

Front

don't re-initialize the auto-complete lookup

Back

-p

Front

prompt for the account's password to connect

Back

-e statement

Front

execute the given SQL statement

Back

INDEX

Front

allows the user to create or delete indexes

Back

REVOKE

Front

removes permissions

Back

INSERT

Front

allows the user to add records to a table

Back

GRANT

Front

adds permissions

Back

ALTER

Front

allows the user to change the definition of an existing table

Back

-u username

Front

specify the username of an account to connect

Back