Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL

memorize.ai (lvl 286)

(0)

11 cards

()

Section 1

Preview this deck

SELECT * FROM <table _name>;

Front

1 / 11

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

Section 1

(11 cards)

SELECT * FROM <table _name>;

Front

selects all data from the table.

Back

Auto Increment

Front

automatically assign the next available number each time a row i added to a table.

Back

USE <database name>;

Front

use a specific database you select.

Back

INSERT INTO table_name (column_name, column_name) VALUES (value, value), (value, value), (value, value);

Front

inserting multiple values at the same time.

Back

INSERT INTO table_name(column_name) VALUES (data);

Front

INSERT INTO cats(name, age) VALUES ('Jetson', 7);

Back

DROP DATABASE <name>;

Front

erases a database

Back

INSERT

Front

Back

SHOW COLUMNS FROM <tablename>;

Front

returns a row for each field containing the field name, its data type, if NULL or not, key information, default value, and extra information.

Back

CREATE DATABASE <name>;

Front

creates a database.

Back

SHOW TABLES;

Front

returns a list of available tables in the currently selected database.

Back

SHOW DATABASES;

Front

returns a list of available databases.

Back