CSV engine : CSV « Engine « SQL / MySQL

1. SQL / MySQL
2. Engine
3. CSV

CSV engine

      
mysql>
mysql> CREATE  TABLE TEAMS_CSV
    ->         (TEAMNO      INTEGER NOT NULL,
    ->          EmployeeNO    INTEGER NOT NULL,
    ->          DIVISION    CHAR(6) NOT NULL)
    ->    ENGINE = CSV
    -> ;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO TEAMS_CSV VALUES (1, 6, 'first')
    -> ;
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO TEAMS_CSV VALUES (2, 27, 'second');
Query OK, 1 row affected (0.00 sec)

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

mysql>

   
    
    
    
    
    
  

Related examples in the same category