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