daily pastebin goal
63%
SHARE
TWEET

Untitled

a guest Jan 18th, 2019 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `Influence` (
  2.     `Influence_ID`  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  3.     `SetupName` TEXT NOT NULL,
  4.     `Assessment` TEXT,
  5.     `Parameter` TEXT,
  6.     `Zone`  TEXT,
  7.     `Target`    NUMERIC,
  8.     `PA` NUMERIC
  9. );
  10.    
  11. CREATE TABLE `InfluenceStructures` (
  12.     `InfluenceStructure_ID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  13.     `StructureType` TEXT NOT NULL,
  14.     `Assessment`    TEXT NOT NULL,
  15.     `Parameter`     TEXT,
  16.     `Zone`          TEXT NOT NULL,
  17.     `Target`        TEXT,
  18.     `PA`            NUMERIC
  19. );
  20.    
  21. INSERT INTO Influence (SetupName, Assessment, Parameter, Zone, Target, PA)
  22.                                    SELECT "NOmbreQueQuiero",Assessment, Parameter, Zone, 5555, PA
  23.                                    FROM InfluenceStructures
  24.                                    WHERE StructureType="multiNoFail" AND Target="V"
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top