GROUP BY approximation

2005-07-22 Thread Andy McHargue
I have table with very similar values in one field, count word - 2 APPLE 6 APPLES 1 APPEL select *,sum(count) as total from table group by word will leave these rows separated. So I want to GROUP BY that field to add the numbers (to come up with 9 APPLES). Is this possible? I gues

Re: remote connection problem

2005-05-18 Thread Andy McHargue
nteresting ports on s191.n33.xx.com (66.84.xx.xx): Port State Service 3306/tcp filteredmysql nmap on B indicates 'open' rather than 'filtered' ... how can i change? Andy McHargue wrote: I'm having trouble connecting remotely from Server A (local) to Ser

remote connection problem

2005-05-18 Thread Andy McHargue
I'm having trouble connecting remotely from Server A (local) to Server B (remote). Both Linux. From Server A, I'm issuing this command mysql -h [domain.com] -u [user] -p And I get ERROR 2003: Can't connect to MySQL server on 'domain.com' (110) I assume this is a time out. 1. The user on Server B