use user_geometry;

drop table magnetic_fields;
create table user_geometry.magnetic_fields (  name          VARCHAR(40) UNIQUE);
alter table magnetic_fields add column          type          VARCHAR(150);
alter table magnetic_fields add column          magnitude     VARCHAR(240);
alter table magnetic_fields add column          swim_method   VARCHAR(40);
alter table magnetic_fields add column          description   VARCHAR(100);
LOAD DATA LOCAL INFILE 'magnetic_fields.txt'  into TABLE magnetic_fields;

use user_geometry;
drop table magnetic_fields;
create table user_geometry.magnetic_fields (  name          VARCHAR(40) UNIQUE);
alter table magnetic_fields add column          type          VARCHAR(150);
alter table magnetic_fields add column          magnitude     VARCHAR(240);
alter table magnetic_fields add column          swim_method   VARCHAR(40);
alter table magnetic_fields add column          description   VARCHAR(100);
LOAD DATA LOCAL INFILE 'magnetic_fields.txt'  into TABLE magnetic_fields;




