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 18: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)