DB
Mysql; mariadb
by I Sang Hyeon
HTML
http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql
Backticks are to be used for table and column identifiers
Single quotes should be used for string values like in the VALUES() list.
Double quotes are supported by MySQL for string values as well,
but single quotes are more widely accepted by other RDBMS,
so it is a good habit to use single quotes instead of double.
JavaScript
Information of DB
SELECT TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, COLUMN_TYPE, COLUMN_KEY, EXTRA, COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'xxx' AND TABLE_NAME ='xxx';
Backticks are to be used for table and column identifiers