Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

double insert (MySQL)

DROP TABLE IF EXISTS TableA;
DROP TABLE IF EXISTS TableB;

CREATE TABLE TableA (
    Row1 int,
    Row2 int
);
  
CREATE TABLE TableB (
    id serial NOT NULL,
    Row1 text,
    Row2 text,
    Row3 int,
    PRIMARY KEY (ID)
);
    
INSERT INTO
  TableA (Row1, Row2)
VALUES
  (10, 12);
  
INSERT INTO
  TableB (Row1, Row2, Row3)
VALUES
  ('Test', 'Second test', 12);
  
SELECT * FROM TableA;
SELECT * FROM TableB;
 run  | edit  | history  | help 0