Big integer with default value : BIGINT : Procedure Function SQL / MySQL

SQL / MySQL » Procedure Function » BIGINT »

 

Big integer with default value


 
mysql>
mysql> delimiter $$
mysql>
mysql> CREATE PROCEDURE myProc()
    -> BEGIN
    ->      DECLARE l_bigint1   BIGINT DEFAULT 4000000000000000;
    ->
    ->     select l_bigint1;
    -> END$$
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql>
mysql> call myProc();
+------------------+
| l_bigint1        |
+------------------+
| 4000000000000000 |
+------------------+
1 row in set (0.02 sec)

Query OK, 0 rows affected (0.02 sec)

mysql>
mysql> drop procedure myProc;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>

        



Leave a Comment / Note


Vérification Refresh
  
Enter code
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

Navioo Procedure Function
» BIGINT
Backup LoadBackup Load
Command MySQLCommand MySQL
CursorCursor
Data TypeData Type
DatabaseDatabase
Date TimeDate Time
Flow ControlFlow Control
FunctionFunction
Insert Delete UpdateInsert Delete Update
JoinJoin
KeyKey
MathMath
Procedure FunctionProcedure Function
Select ClauseSelect Clause
StringString
Table IndexTable Index
TransactionTransaction
TriggerTrigger
User PermissionUser Permission
ViewView
Where ClauseWhere Clause