SQL query(s) to the database?

Question

SQL

What's wrong with the request? I checked the manual several times - there is such a request, but it gives me an error

CREATE TABLE 'textlog' (
    'id' int(11) NOT NULL,
    'chat_id' int(111) NOT NULL,
    'text' text CHARACTER SET NOT NULL,
    'date' datetime NOT NULL DEFAULT CURRENT_TIMESTAMP   
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Found 4 errors during analysis.

Symbol name expected! (near "'id'" at position 30)
Expected at least one column declaration. (near "'id'" at position 30)
Unexpected start of expression. (near "11" at position 39)
Unknown operator. (near "NOT NULL" at position 43)

Answer 1

'id' - string
`id` - column/table/database name