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
|
|
|