Since mySQL at this time does not support sub query, Do I've to break this into 2 SQLs and process:
select question_id from questions where abs_sort_order in (select min(a.abs_sort_order) from questions a where a.abs_sort_order > 1) Ben ----- Original Message ----- From: "DeNewbie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 28, 2002 8:03 AM Subject: Basic RPM installation? > > In my first posting I had the following problem; > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > > [1] 1759 > > mike@cords-orj86jfje:/usr/bin> cat: /var/lib/mysql/cords-orj86jfje.pid: Permission denied > > rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied > > Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid > > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > > Please remove it manually and start /usr/bin/safe_mysqld again > > mysqld daemon not started > > > > > I removed the cords-orj86jfje.err file from /var/lib/mysql/cords-orj86jfje.err and I performed the mysql_install_db script all over again, now I have this problem in that I get the same response even after removing the cords-orj86jfje.err file. > > > > > > mike@cords-orj86jfje:/usr/bin> safe_mysqld & > [1] 1059 > mike@cords-orj86jfje:/usr/bin> Starting mysqld daemon with databases from /var/lib/mysql > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied > tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied > 020928 10:47:57 mysqld ended > tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied > > > [1]+ Exit 1 safe_mysqld > mike@cords-orj86jfje:/usr/bin> cd /var/lib/mysql > mike@cords-orj86jfje:/var/lib/mysql> ls > mysql test > mike@cords-orj86jfje:/var/lib/mysql> ls -l > total 1 > drwx--x--x 2 mysql root 506 Sep 2 14:20 mysql > drwxr-xr-x 2 mysql root 35 Sep 2 14:20 test > > > > I have the safe_mysql in my /usr/bin but I get this; > > > > > mike@cords-orj86jfje:~> cd /usr/bin > mike@cords-orj86jfje:/usr/bin> safe_mysql & > [1] 1118 > bash: safe_mysql: command not found > [1]+ Exit 127 safe_mysql > mike@cords-orj86jfje:/usr/bin> ls safe* > safe-rm safe_mysqld > mike@cords-orj86jfje:/usr/bin> su > Password: > cords-orj86jfje:/usr/bin # safe_mysql & > [1] 1126 > bash: safe_mysql: command not found > [1]+ Exit 127 safe_mysql > cords-orj86jfje:/usr/bin # > > > > > What do I do from here ??? > > Thanks, DeNewbie > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
