а
тут что нужно исправить?
Size: a a a
2020 December 21
DE
DELIMITER // -- is imporant
CREATE PROCEDURE mypro ()
BEGIN
SET @counter = 1;
SET @result = "";
WHILE (@counter < 20) DO
SET @counter = @counter + 1;
SET @result = CONCAT(@result, ", ", @counter);
END WHILE;
SELECT @result;
END // -- end need be with "//"
S
DELIMITER // -- is imporant
CREATE PROCEDURE mypro ()
BEGIN
SET @counter = 1;
SET @result = "";
WHILE (@counter < 20) DO
SET @counter = @counter + 1;
SET @result = CONCAT(@result, ", ", @counter);
END WHILE;
SELECT @result;
END // -- end need be with "//"
а
DELIMITER //
CREATE TRIGGER RailCarInsert AFTER INSERT ON RailwayStation.RailCar
FOR EACH ROW BEGIN
DECLARE i, a, b int;
DECLARE money decimal(12,2);
SET money = (SELECT SeatPrice
FROM inserted JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET b = (SELECT RailCarID
FROM inserted LIMIT 1);
SET a = (SELECT SeatNumber
FROM inserted
JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET i = 0;
select a;
WHILE i < a DO
BEGIN
INSERT INTO RailwayStation.Seat (RailCarID, Status, SeatPrice) VALUES ( b, 'false', money);
set i = i + 1;
end;
end; //
CREATE TRIGGER RailCarInsert AFTER INSERT ON RailwayStation.RailCar
FOR EACH ROW BEGIN
DECLARE i, a, b int;
DECLARE money decimal(12,2);
SET money = (SELECT SeatPrice
FROM inserted JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET b = (SELECT RailCarID
FROM inserted LIMIT 1);
SET a = (SELECT SeatNumber
FROM inserted
JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET i = 0;
select a;
WHILE i < a DO
BEGIN
INSERT INTO RailwayStation.Seat (RailCarID, Status, SeatPrice) VALUES ( b, 'false', money);
set i = i + 1;
end;
end; //
а
все равно ошибка
DE
анна
все равно ошибка
Так у тебя всё равно бегин
а
DELIMITER //
CREATE TRIGGER RailCarInsert AFTER INSERT ON RailwayStation.RailCar
FOR EACH ROW BEGIN
DECLARE i, a, b int;
DECLARE money decimal(12,2);
SET money = (SELECT SeatPrice
FROM inserted JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET b = (SELECT RailCarID
FROM inserted LIMIT 1);
SET a = (SELECT SeatNumber
FROM inserted
JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET i = 0;
select a;
WHILE i < a DO
INSERT INTO RailwayStation.Seat (RailCarID, Status, SeatPrice) VALUES ( b, 'false', money);
set i = i + 1;
end while;
end; //
CREATE TRIGGER RailCarInsert AFTER INSERT ON RailwayStation.RailCar
FOR EACH ROW BEGIN
DECLARE i, a, b int;
DECLARE money decimal(12,2);
SET money = (SELECT SeatPrice
FROM inserted JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET b = (SELECT RailCarID
FROM inserted LIMIT 1);
SET a = (SELECT SeatNumber
FROM inserted
JOIN RailwayStation.RailCarType AS T ON T.TypeID = inserted.TypeID LIMIT 1);
SET i = 0;
select a;
WHILE i < a DO
INSERT INTO RailwayStation.Seat (RailCarID, Status, SeatPrice) VALUES ( b, 'false', money);
set i = i + 1;
end while;
end; //
а
изменила 1415
а
теперь
DE
если ничего не изменить, то ничего и не изменится
Кому измена, а кого и на хавку пробило