Change the @@STORAGE_ENGINE : Global Variables « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Global Variables

Change the @@STORAGE_ENGINE

      
mysql>
mysql> SET @@STORAGE_ENGINE = 'InnoDB'
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE   TABLE TEAMS
    ->         (TEAMNO      INTEGER NOT NULL,
    ->          EmployeeNO    INTEGER NOT NULL,
    ->          DIVISION    CHAR(6) NOT NULL,
    ->          PRIMARY KEY (TEAMNO),
    ->          FOREIGN KEY (EmployeeNO)
    ->             REFERENCES EmployeeS (EmployeeNO))
    -> ;
mysql> SELECT   *
    -> FROM     TEAMS
    -> WHERE    EmployeeNO NOT IN
    ->         (SELECT   EmployeeNO
    ->          FROM     EmployeeS);
mysql>
mysql> drop table teams;

   
    
    
    
    
    
  

Related examples in the same category