MariaDB | DECLARE maxid INT(11);

Čer...

Tole sem že imel rešeno, pa nimam več source fajlov, in ponovno iščem...

Kako deklarirati variable maxid pri Mariji (ne tisti, katera je bila na današnji dan v nebo vzeta), rabim INT.


Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6098
Server version: 10.5.5-MariaDB-1:10.5.5+maria~buster mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]> USE database_1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [database_1]> DECLARE maxid INT;
ERROR 1064 (42000): 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 'DECLARE maxid INT' at line 1
MariaDB [database_1]> DECLARE maxid INT(11);
ERROR 1064 (42000): 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 'DECLARE maxid INT(11)' at line 1
MariaDB [database_1]>
MariaDB [database_1]> DECLARE trolll INT;
ERROR 1064 (42000): 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 'DECLARE trolll INT' at line 1
MariaDB [database_1]> DECLARE x, y INT DEFAULT 0;
ERROR 1064 (42000): 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 'DECLARE x, y INT DEFAULT 0' at line 1
MariaDB [database_1]>