$ mysql -u mysqlusername -e ''
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,
>u.pho
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
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 = (se
