String quoting and concatenation differences in SQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What type of quotes are used in SQL to represent string literals?

Single quotes (' ') are used to represent string literals in SQL. Double quotes (" ") are typically used for identifiers like column or table names.

beginner

How do you concatenate two strings in standard SQL?

You use the double pipe operator (||) to concatenate strings in standard SQL. For example: 'Hello' || ' World' results in 'Hello World'.

intermediate

What happens if you use double quotes around a string in SQL?

Double quotes are used for identifiers, not strings. Using double quotes around a string will make SQL treat it as a column or table name, which can cause errors if that identifier does not exist.

intermediate

How do MySQL and PostgreSQL differ in string concatenation?

PostgreSQL uses the || operator for string concatenation. MySQL uses the CONCAT() function instead. For example, CONCAT('Hello', ' World') in MySQL vs 'Hello' || ' World' in PostgreSQL.

beginner

Why is it important to use the correct string quoting in SQL queries?

Using the correct quotes prevents syntax errors and SQL injection risks. Single quotes ensure strings are treated as data, while double quotes are for identifiers. Mixing them up can cause errors or security issues.

Which quotes should you use to write a string literal in SQL?

A No quotes

B Double quotes (" ")

C Backticks (` `)

D Single quotes (' ')

Single quotes are used for string literals in SQL.

How do you concatenate strings in standard SQL?

A Using + operator

B Using || operator

C Using CONCAT() function only

D Using & operator

The || operator is the standard SQL way to concatenate strings.

In MySQL, how do you concatenate 'Hello' and 'World'?

A CONCAT('Hello', 'World')

B 'Hello' || 'World'

C 'Hello' + 'World'

D 'Hello' & 'World'

MySQL uses the CONCAT() function for string concatenation.

What does double quotes around a word mean in SQL?

A Comment

B String literal

C Identifier like column or table name

D Number

Double quotes are used for identifiers in SQL.

What is a risk of using wrong quotes in SQL queries?

A All of the above

B SQL injection

C Syntax errors

D Wrong data retrieval

Wrong quotes can cause syntax errors, security risks, and wrong results.

Explain the difference between single and double quotes in SQL and why it matters.

Think about how SQL treats data vs names.

Describe how string concatenation differs between standard SQL, MySQL, and PostgreSQL.

Focus on operators and functions used.