Discussion:
Q: A database called "genomicdb" in MYSQL server with two tables: "gene" and "location" is created. The tables are supposed to be populated with data from attachment. One of the files, "gene.txt", works fine and populates fine in the table.
#Created the tables.
mysql> create table gene
-> (gene_name varchar(20) not null,
-> gene_id varchar(20) not null primary key
-> );
Query OK, 0 rows affected (0.09 sec)
mysql> create table location
-> (chromosome varchar(10) not null,
-> strand varchar(10) not null,
-> cds_from varchar(30) not null primary key,
-> cds_to varchar(30) not null
-> );
Query OK, 0 rows affected (0.11 sec)
Attachment:- Information.rar