Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Reporting with SQL Working with Text Single vs Double Quotes

Maryam Naz
Maryam Naz
3,636 Points
Posted by Maryam Naz
Maryam Naz
3,636 Points

can someone define "string literal" and identifier"? I tried the web, and still unclear. Thanks in advance.

can someone define "string literal" and identifier"? I tried the web, and still unclear. Thanks in advance.

2 Answers

Steven Parker
Steven Parker
231,184 Points
Steven Parker
Steven Parker
231,184 Points

A "literal" is something that represents itself. Like the number 42 or the word "test". The latter is an example of a string literal since is composed of text instead of a number.

On the other hand, an identifier is a name that represents something else. An example common identifier used with SQL is a column name or table name.

Maryam Naz
Maryam Naz
3,636 Points
Maryam Naz
Maryam Naz
3,636 Points

Copy that. Perfect! Many thanks Steven :).

Shikha Sitaula
Shikha Sitaula
3,443 Points
Shikha Sitaula
Shikha Sitaula
3,443 Points

It was helpful for me as well. Thank you Maryam for bring up this question. You bit me to it as I was about to show the same concern.