INTEGER(4) ZEROFILL : Int « Data Type « SQL / MySQL

1. SQL / MySQL
2. Data Type
3. Int

INTEGER(4) ZEROFILL

      
mysql>
mysql> CREATE TABLE WIDTH (C4 INTEGER(4) ZEROFILL)
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO WIDTH VALUES (1)
    -> ;
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO WIDTH VALUES (200);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql>
mysql> drop table width;
Query OK, 0 rows affected (0.00 sec)

mysql>

   
    
    
    
    
    
  

Related examples in the same category