SELECT, INNER JOIN getting all ancestors of a term

2005-04-06 Thread l'eau
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

JDBC driver problem with sql LIMIT

2005-03-30 Thread l'eau
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

Re: mysql not starting at boot

2005-03-30 Thread l'eau
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

show databases;

2005-03-12 Thread l'eau
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