Literal strings


show more Literal strings provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training show less
please wait ...

Literal strings

You use literal values for a lot of purposes for example when you add or update rows to a table, you'll often use literals for the new values. Literal strings in MYSQL deserve some attention because there are some ways in which they can be different from the SQL standard. For example, I say select hello world with the single quotes around the string and a semicolon, press Go, we get hello world. So this is standard SQL and standard SQL literal string.

Has single quotes and the characters are inside of the single quotes. Now, if I want to concatenate strings in MYSQL, you can do that like this. And this will give me the same result. Press Go, and that's exactly the same result. Now, you notice what we have here is we have three strings. One string there, another string here which is a comma and a space, and another string here with the word world. So, those are three separate strings, each in single quotes and just separated by spaces like this.

And in MySQL that with concatenate the strings an...

Literal strings
Video duration: 3m 12s 4h 24m Beginner

Viewers:

Literal strings provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training

Subject:
Developer
Software:
MySQL
Author:
please wait ...