Question
Give the commands for opening a MYSQL program, and then connecting to a database called my_chado. Then write an SQL query that lists the types
Give the commands for opening a MYSQL program, and then connecting to a database called my_chado. Then write an SQL query that lists the types of features in a feature table and gives the count of each. The database contains two tables: 1. feature: all of the feature types are stored in this table: the type_id column gives each different type a different numerical designation. 2. cvterm: each of the numerical types from the feature table is given a plain language name based on names in this table. Each numerical type has a unique identifier listed in a cvterm_id field. 3. The cvterm_id can be linked directly to the type_id field in the feature table.
The output must look like this example:
+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +
: feature type : feature count
+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +
: assembly : 1
: exon : 4200:
:gene : 4200:
: mRNA : 4200:
: polypeptide : 4200:
+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started