Re: How do I export a set of data nightly

2004-11-02 Thread Matthew Scales
$ mysql -u mysqlusername -e 'insert your sql here' On Mon, 1 Nov 2004, Scott Haneda wrote: My query works: (version 4) SELECT u.id, r.user_id, u.first_name, u.middle_name, u.last_name, u.company, u.department, u.address, u.address2, u.city, u.state, u.country, u.zip,

Re: sub queries

2004-10-29 Thread Matthew Scales
Hi Nathan, Subqueries are only available in MySQL as of version 4.1. On Fri, 29 Oct 2004, Nathan Coast wrote: Hi apologies if this is a dumb question but can you do subqueries in mysql? select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID =2 and UGR.ROLE_ID = (select

Re: run mysql service in Linux

2004-10-29 Thread Matthew Scales
Hi Cecep, On Fri, 29 Oct 2004, Cecep Rosuludin wrote: Gleb Paharenko [EMAIL PROTECTED] wrote: See INSTALL-BINARY in the distribution directory and follow instructions in it exactly. Don't forget about mysql_install_db! You appear to have missed this part out below. Don't know if this is