Known restrictions of the MariaDB Jupyter Kernel include one SQL statement per cell, single line magic per cell, no mixing of magic and SQL, and required semicolon delimiters.
Here's a list of the current restrictions and limitations of the MariaDB Jupyter kernel. Trying to stretch what we listed here is at your own risk, the results and the behavior of the kernel might be at the mercy of the universe :-)
One cell should only contain a single SQL statement. It can be multi-line, a one liner, it doesn't matter, but it needs to only be a single statement.
A notebook cell can only contain one line magic command (line magics start with %). Everything else within the same cell below the line magic command will be ignored.
Magic commands and SQL statements cannot be mixed within the same notebook cell.
The kernel does not officially support the DELIMITER (MariaDB specific) client command. It might work, but it shouldn't be used. Rather use the %%delimiter cell magic command (see %lsmagic for usage information).
Each SQL statement within a notebook cell should end with the ; MariaDB default delimiter, except in cells using the %%delimiter cell magic command where it should end with the user-specified delimiter.
Last updated
Was this helpful?
Was this helpful?
