SQL Flashcards
When should you use a programming language?
When it is useful for what you are doing.
What does TSV stand for and what is it?
Tab Separated Values and is a format where each field is separated by a tab.
What does SQL stand for?
Structured Query Language
What does * mean in SQL?
Select everything
What is a varchar in SQL?
A variable character where the maximum possible length is specified.
What is a char in SQL?
A fixed length string
What is a text type in SQL?
A string
What does CRUD stand for in SQL?
Create (insert), Read, Update, Delete (drop)
What does ‘=’ represent in SQL
Equal
Why is the following code a big no no?
DELETE FROM favorites
It will delete the entire database
Why is it important? To back up databases?
Because there is no undo button/whole databases can be deleted with one query.
What does Ctrl c do?
Breaks
What does ‘- -’ mean in SQL?
Comment
Why is the following code dangerous: ‘…’ ?
It can easily be hacked
What type of print function can be hacked? What type can’t?
Formatted can, placeholder can’t.
