Documentation Source Text

Check-in [b1b9dd90bb]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Another accidental fork merge.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b1b9dd90bb0f2b8a958920e23953285c6d30d52a
User & Date: drh 2014-05-25 20:11:37.579
Context
2014-05-25
21:54
Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. (check-in: 227fb14d50 user: drh tags: trunk)
20:11
Another accidental fork merge. (check-in: b1b9dd90bb user: drh tags: trunk)
20:08
Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. (check-in: fc0e9baa66 user: drh tags: trunk)
2014-05-24
17:31
Merge accidental fork (check-in: 0f2064446a user: drh tags: trunk)
Changes
Unified Diff Show Whitespace Changes Patch
Changes to pages/faq.in.
︙︙
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342


faq {
  How do I use a string literal that contains an embedded single-quote (')
  character?
} {
  <p>The SQL standard specifies that single-quotes in strings are escaped
  by putting two single quotes in a row.  SQL works like the Pascal programming
  language in the regard.  SQLite follows this standard.  Example:
  </p>

  <blockquote><pre>
    INSERT INTO xyz VALUES('5 O''clock');
  </pre></blockquote>
}









|








328
329
330
331
332
333
334
335
336
337
338
339
340
341
342


faq {
  How do I use a string literal that contains an embedded single-quote (')
  character?
} {
  <p>The SQL standard specifies that single-quotes in strings are escaped
  by putting two single quotes in a row.  SQL works like the Pascal programming
  language in this regard. Example:
  </p>

  <blockquote><pre>
    INSERT INTO xyz VALUES('5 O''clock');
  </pre></blockquote>
}
︙︙