ggestion. I will have a play on my test database.
> I'd certainly perform lots of testing away from the live system before I
> tried this for real.
:-))
Rgds
Shin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
me having to extract all their existing encrypted
passwords and then inserts them in afterwards in the appropriate
tables - I prefer using GRANT.
Is there anyway I can what I'm after?
many thanks
Shin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: Friday, August 08, 2003 12:17 AM
To: Fatt Shin
Cc: [EMAIL PROTECTED]
Subject: Re: select count(*) Problem in PowerBuilder Thru MySQL ODBC
3.51
You are not doing "select count(*)"
You are doing "select count ( *)"
Get rid of the spaces before the "("
Fatt Shin w
Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBuilder, I always get SQL syntax error back from MySQL. (Refer
to ODBC Trace I captured below).
metrohouse af8-b94 ENTER S
Try this ...
Delete from clients where 0 = (select count(*) from branches where branches.cid =
clients.cid)
Cheers
FattShin
-Original Message-
From: Vikram Vaswani [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 9:51 PM
To: Nils Valentin; [EMAIL PROTECTED]
Subject: Re: Help with
I have remote access to a MySQL database. I would like to be able to
"download" a table or portions of a table to my local computer so as to work
with the data using other tools for simple data manipulation. Can this be
done? How? Any tips or pointers in the right direction would be greatly
ap
