如何在sqlite中用填充连接字符串

||

-- the statement below is almost the same as
-- select lpad(mycolumn,\'0\',10) from mytable

select substr(\'0000000000\' || mycolumn, -10, 10) from mytable

-- the statement below is almost the same as
-- select rpad(mycolumn,\'0\',10) from mytable

select substr(mycolumn || \'0000000000\', 1, 10) from mytable

SELECT col1 || \'-\' || substr(\'00\'||col2, -2, 2) || \'-\' || substr(\'0000\'||col3, -4, 4)

\"A-01-0001\"
\"A-01-0002\"
\"A-12-0002\"
\"C-13-0002\"
\"B-11-0002\"

printf

SELECT printf(\'%s-%.2d-%.4d\', col1, col2, col3) FROM mytable

SELECT 
  (
    col1 || \'-\' || SUBSTR(\'00\' || col2, -2, 2) | \'-\' || SUBSTR(\'0000\' || col3, -4, 4)
  ) AS my_column 
FROM
  mytable;