ICT - Databases

CREATE DATABASE puppets;

What is the MySQL command to create a database?

USE DATABASE puppets;

What is the MySQL command to switch to the database you would like to use?

VARCHAR

Stands for variable character; a data type that is used to store strings of letters, numbers, and symbols

DESCRIBE muppets;

What do you do to check the structure of the table created in MySQL?

CREATE muppets;

What do you do to create a table in MySQL?

AUTO-INCREMENT

Allows a unique number to be generated automatically when a new record is inserted into a table.

INSERT INTO sesame_street

How do you populate the second table with information?

SELECT muppet_performers FROM muppets;

How do you display information from the first table based only on one field?

SELECT muppet_performers from muppets LIMIT 2;

How do you display information from the first table based only on one field, while limiting the number of rows?

UPDATE muppets; SET title = ‘Jim Henson’ WHERE character = ‘Kermit’;

How do you change information in one cell while using another cell as an identifier?

SELECT * FROM muppets JOIN sesame_street USING (muppet_performers)

How do you display all information from the two tables, joining them through a common key?

DELETE from muppets WHERE muppet_performers = ‘Jim Henson’;

How do you delete information in one cell using information from another identifying cell (like getting rid of a whole row)?

DROP TABLE muppets;

How do you remove one table from the database?

MySQL Database

A system that lets you store, organize, retrieve, and manipulate data efficiently using a structured format.