IntroductionBecause BurstCMS is designed so that the same modules can run in different databases, without any sort of modification, there are certain restrictions on SQL syntax. NamesTable, column, and other names in the database ought to fit the regex ^[A-Za-z][A-Za-z0-9_]{0,19}$ although this will not be enforced. QuotingThe SQL standard of using single quotes to quote values and double quotes to quote table names and such should be obeyed. Before your SQL is executed, BurstCMS will run SET sql_mode='ANSI_QUOTES' in MySQL to make the standard-quote-style SQL work. Reserved wordsAs the list of reserved words varies from database to database, affix a prefix to all table names and such in the database to avoid a conflict with a reserved word.
|
Sign in to add a comment
