Check default : Default Value « Table Index « SQL / MySQL

1. SQL / MySQL
2. Table Index
3. Default Value

Check default

      
mysql>
mysql> CREATE TABLE TABDEFKARSET
    ->       (C1   CHAR(10) NOT NULL,
    ->        C2   VARCHAR(10))
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT   COLUMN_NAME, CHARACTER_SET_NAME
    -> FROM     INFORMATION_SCHEMA.COLUMNS
    -> WHERE    TABLE_NAME = 'TABDEFKARSET';
+-------------+--------------------+
| COLUMN_NAME | CHARACTER_SET_NAME |
+-------------+--------------------+
| C1          | latin1             |
| C2          | latin1             |
+-------------+--------------------+
2 rows in set (0.00 sec)

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

mysql>

   
    
    
    
    
    
  

Related examples in the same category