You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When using the restore method, sql files using changed delimiters (see bottom) seem to break
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DELIMITER //CREATE PROCEDURE `deleteDeadVehicles`()BEGINDELETE FROM `vehicles...' at line 1
CREATETABLEIF NOT EXISTS `containers` (
`id`int(11) NOT NULL AUTO_INCREMENT,
`pid`varchar(17) NOT NULL,
`classname`varchar(32) NOT NULL,
`pos`varchar(32) DEFAULT NULL,
`inventory`textNOT NULL,
`gear`textNOT NULL,
`dir`varchar(128) DEFAULT NULL,
`active`tinyint(4) NOT NULL DEFAULT 0,
`owned`tinyint(4) NOT NULL DEFAULT 0,
`insert_time`timestampNOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `fkIdx_players_containers` (`pid`),
CONSTRAINT`FK_players_containers`FOREIGN KEY (`pid`) REFERENCES`players` (`pid`) ON DELETE CASCADEONUPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DELETEFROM`containers`;
DELIMITER //
CREATE PROCEDURE `deleteDeadVehicles`()
BEGINDELETEFROM`vehicles`WHERE`alive`=0;
END//
DELIMITER ;
11.3.2-MariaDB-1:11.3.2+maria~ubu2204
The text was updated successfully, but these errors were encountered:
When using the
restore
method, sql files using changed delimiters (see bottom) seem to break11.3.2-MariaDB-1:11.3.2+maria~ubu2204
The text was updated successfully, but these errors were encountered: