Comments - About the Knowledge Base

Hello, I'm committed to a United Nations volunteer project; I'm using Xampp ((Mariadb10.1) for a database application related to a vocational school. After my deep search, I have found nothing comparable to the complete PDF guide available for the MySQL 5.7 https://dev.mysql.com/doc/ it would be sufficient to make a PDF from the section of the statements and their syntax available in this website. When that will be done I'm sure the base of users will enlarge a lot. Thank you. Giuseppe Calamita

Unfortunately there is no downloadable version at present. See MDEV-6881 and feel free to vote for or comment on that issue.

Why not download and convert to PDF the existing section of this website on SQL statements and make it available to all interested in here?

I have found that the syntax in the documentation contains allot of closed brackets, and I'm wondering what all of that means. For example,

 LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [CHARACTER SET charset_name]
    [{FIELDS | COLUMNS}
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char']
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number LINES]
    [(col_name_or_user_var,...)]
    [SET col_name = expr,...]

I have not found a document that explains the conventions used in the documentation, particularly the knowledge base articles.

[..] means that the contents are optional, and | means OR. So, in your example, you can use LOAD DATA LOW PRIORITY... or LOAD DATA CONCURRENT..., or neither option, just LOAD DATA...

You're right that there should be a key - these are standard conventions, but should still be explained.