How To Include Character Strings in SQL statements

Q

How To Include Character Strings in SQL statements? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

If 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 'FYIcenter.com'.
  • Using double quotes. For example "FYI 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.'.

2007-05-11, 5042👍, 0💬