I tried the query defined in the Go Example queries:
and added some filtering on t.term_type, t.is_root and t.is_obsolete
Finding all ancestors of a term:
SELECT p.*
FROM
graph_path
INNER JOIN
term AS t ON (t.id = graph_path.term2_id
and t.term_type=biological_process)
INNER JOIN
term AS
Using MySql Connect/J (mysql-connector-java-3.1.7.tar)
on Linux Fedora 2.
I use a Statement object and do the following query:
String myquery = SELECT * FROM term WHERE name REGEXP (\'+ name
+\') and term_type=\'+ ontology +\' LIMIT 20;
table term has 6 columns.
MySql
To have mysql to start at boot you need to inform the inetd (daemon) that
mysql should be launched at one of the 6 levels:
Use chkconfig to have mysql start in one of the level (2,3,4,5,6)
5 being X windows.
There are two ways to check that mysql will be loaded:
- 1 - by checking the file in
I am on linux Fedora 2 with mysqld running as a daemon and the service mysql
running (/etc/rc.d/init.d/).
I have two shell sessions (mysql client) running one with root and the other
with a user.
I did (as root) : grant all privileges on mydb to [EMAIL PROTECTED];
in the root session the show