Comments - MariaDB String Functions
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
SELECT CONCAT_WS('|', col1, col2, col3) FROM table1; The above is used as an example method for exporting data. If some rows contain columns that may have null values the entire column is skipped for eaach column containing a null for the given row. The output would have a different number of separators on different rows and the missing column is not necessarily the same column for all rows. I'm not sure how this could be safely imported. Am I missing something or is this a bad example if there are nulls present in the table?