How To Include Character Strings in SQL statements?
Submitted by: AdministratorIf you want to include character strings in your SQL statements, you need to quote them in one of the following formats:
► Using single quotes. For example 'GlobalGuideLine.com'.
► Using double quotes. For example "ggl Center".
► Using single quotes prefixed with N for NATIONAL characters (same as UTF8 characters). For example N'Allo, Francois.'.
► Using single quotes prefixed with _utf8 for UTF8 characters. For example _utf8'Allo, Francois.'.
Submitted by: Administrator
► Using single quotes. For example 'GlobalGuideLine.com'.
► Using double quotes. For example "ggl Center".
► Using single quotes prefixed with N for NATIONAL characters (same as UTF8 characters). For example N'Allo, Francois.'.
► Using single quotes prefixed with _utf8 for UTF8 characters. For example _utf8'Allo, Francois.'.
Submitted by: Administrator
Read Online MySQL Programming Job Interview Questions And Answers
Top MySQL Programming Questions
| ☺ | How To Use CASE Expression? |
| ☺ | How To Use Regular Expression in Pattern Match Conditions? |
| ☺ | What Is TIMESTAMP in MySQL? |
| ☺ | How To Write Date and Time Literals? |
| ☺ | How To Delete an Existing Column in a Table? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
