SELECT, INNER JOIN getting all ancestors of a term

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 A

Re: mysql not starting at boot

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 /

JDBC driver problem with sql LIMIT

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

show databases;

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 d