##########################
#
# MySQL/PHP Workshop - SQL Commands
# Day 1
#
##########################

SHOW DATABASES;

USE trii;

SHOW TABLES;

DESC organism;

SELECT * FROM organism;

SELECT common_name, species FROM organism;

SELECT species FROM organism WHERE organism_id=1;

INSERT INTO gene (ensembl_gene_id, organism_id, name, chromosome, chromo_start, chromo_end) VALUES ('MY_NEW_GENE', 1, 'MY GENE', 1, 12345, 67890);

SELECT gene_id FROM gene WHERE name='MY GENE';

DELETE FROM gene WHERE gene_id=19;

UPDATE gene SET name='NEW NAME'
WHERE name='AKIP';

SELECT gene.name, organism.species FROM gene, organism;

SELECT gene.name, organism.species
FROM gene, organism
WHERE gene.organism_id=organism.organism_id;