Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

47 cards

()

Section 1

Preview this deck

"%llo Wo%"

Front

1 / 47

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

Section 1

(47 cards)

"%llo Wo%"

Front

Would match to "Hello World" too

Back

how do you view all contents of a table

Front

SELECT* FROM mytable

Back

what are column names and values separated by?

Front

by commas

Back

does each column of entries NEED to have a datatype

Front

yes

Back

What does SQL stand for?

Front

Structured Query Language

Back

what do ALL values have around them?

Front

single quotes

Back

how do you view only col1 from mytable

Front

SELECT col1 FROM mytable

Back

syntax to add into table

Front

INSERT INTO table_name (column names) VALUES (values to be entered)

Back

what happens when you send a query to add a new row without any data to a column that does not allow NULL values

Front

query will not compute properly

Back

INSERT INTO Customer (CustomerID, FirstName, LastName,PhoneNumber, Address) VALUES ('0003', 'Landon', 'Colbert', '(333) 333-3333', '351 Avenue') what does VALUES keyword mean

Front

it signifies the data

Back

do you use parentheses when updating columns

Front

no

Back

what happens when a field in a column does not adhere to its datatype

Front

you can get errors

Back

SELECT * FROM Customer WHERE CustomerID = "000%"

Front

SELECT * FROM Customer WHERE CustomerID = "000%"

Back

columns can choose to allow _______ values

Front

NULL

Back

are database columns names case sensitive?

Front

yes

Back

what are rows in tables?

Front

individual entries

Back

delete one record where cid is 0001

Front

DELETE FROM mytable WHERE CID = '0001'

Back

what is the keyword used to delete all records or single entry

Front

DELETE

Back

what if you do not give a condition for updating

Front

all entries will be updated of the column

Back

Must have all the data being added to a table in the query or it will __________

Front

cause an error and not insert the data

Back

can foreign keys have a NULL value

Front

no, because it is primary key of another table and primary key can never be NULL.

Back

what can be used to separate multiple queries?

Front

semicolons

Back

keyword to insert an entry into a table

Front

INSERT

Back

UPDATE Customer SET FirstName='Dana'

Front

sets every record to have the first name Dana

Back

"Hello%"

Front

would match to "Hello World"

Back

keywords for updating data

Front

SET and UPDATE

Back

should queries always be all caps

Front

they should be, nut not required

Back

are database names case sensitive?

Front

yes

Back

what is a primary key?

Front

a primary key is associated with a column, which is a unique value for each entry which can identify each row.

Back

can a primary key have a NULL value

Front

NO

Back

what are foreign keys

Front

primary keys of other tables that a current table uses to reference other tables

Back

what is the use of SQL

Front

it lets you access and manipulate databases

Back

SELECT * FROM Customer WHERE CustomerID = "0001"

Front

Displays only the Customer that has that CustomerID

Back

code to delete all records from a table

Front

DELETE * FROM mytable

Back

you can specify the _________ length for values

Front

MAXIMUM

Back

UPDATE Customer SET FirstName='Dana', LastName='Shows' WHERE CustomerID='0001'

Front

updates first and last name of customer ID 001

Back

"Hello"

Front

would NOT match to "Hello World"

Back

what does database tables contain?

Front

data that you can pull from

Back

can you update multiple columns?

Front

yes

Back

what do you need to delete one record

Front

a unique condition such as primary key

Back

"%World"

Front

would match to "Hello World"

Back

how do you specify a table name?

Front

FROM mytable

Back

how many primary keys can a table have?

Front

1

Back

what happens when an entry for a string given a MAXIMUM length of 5 exceeds it

Front

anything over it gets cut off

Back

example of data types

Front

string, int, timestamp

Back

what all do you need to build a website using databases?

Front

1) Relational Database Management System -- mySQL 2) Server-side scripting language -- ex PHP, ASP 3) SQL querries

Back

what is a standard for databases

Front

SQL

Back