User:SwMATHimport240215: Difference between revisions
From MaRDI portal
Created page with "quick statements generatino SQL command <source lang=sql> SELECT '' as "qid", id as "P13", name from swmath_software where id not in (Select swid from zz_mors_mardi_software) </source>" |
No edit summary |
||
| Line 1: | Line 1: | ||
quick statements generatino SQL command | quick statements generatino SQL command | ||
<source lang=sql> | <source lang=sql> | ||
SELECT '' as "qid", id as "P13", name | SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len" | ||
from swmath_software | from swmath_software | ||
where id not in (Select swid from zz_mors_mardi_software) | where id not in (Select swid from zz_mors_mardi_software) | ||
</source> | </source> | ||
Revision as of 17:02, 15 February 2024
quick statements generatino SQL command
SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len"
from swmath_software
where id not in (Select swid from zz_mors_mardi_software)
