Jerry Schwartz wrote:
I know that you can alias a function result as easily as anything else, but
I've run into a problem with an application I inherited. For reasons too
murky to go into, I would like to refer to the result of a group function as
the name of the argument of the function. Here's
I know that you can alias a function result as easily as anything else, but
I've run into a problem with an application I inherited. For reasons too
murky to go into, I would like to refer to the result of a group function as
the name of the argument of the function. Here's an example of what I mea
[EMAIL PROTECTED] (Kelly Solakofski) wrote in
news:[EMAIL PROTECTED]:
> I've been trying to put the data onto our data drive, and the mysql
> application on the main server. I've edited the my.ini file
> correctly. I can get it to work on different drives where the data is
> on the same comput
On 1/23/07, Kelly Solakofski <[EMAIL PROTECTED]> wrote:
I've been trying to put the data onto our data drive, and the mysql
application on the main server. I've edited the my.ini file correctly.
I can get it to work on different drives where the data is on the same
computer as mysql. I can't ge
I've been trying to put the data onto our data drive, and the mysql
application on the main server. I've edited the my.ini file correctly.
I can get it to work on different drives where the data is on the same
computer as mysql. I can't get it to work where the data is on a
different compute
The free version is crippled. You don't get all the capabilities they say.
>>> "COS" <[EMAIL PROTECTED]> 1/23/07 8:16 AM >>>
Hi,
DBTools Software is proud to announce the availability of the new DBManager
Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2.
For a complete
I'm performance testing my 'users' table. It currently has roughly
1M user records. The 'geo_entities' table has ~ 250 records.
Here's my query.
SELECT users.entity_id, geo_entities.entity_name,
geo_entities.short_code, COUNT( users.entity_id )
FROM users, geo_entities
WHERE users.user_ty
Hi,
DBTools Software is proud to announce the availability of the new DBManager
Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2.
For a complete list of changes please check our website at
http://www.dbtools.com.br/EN.
The new versions are available in our downloads cent
If the connection itself passes a test, but MS Access hangs, I don't know
what to suggest. I'm not an expert, it just worked when I tried it.
You use File... Get external data... Link tables, right? Is that where it
hangs? Does it list the tables in your MySQL data base, or doesn't it even
get tha
I used mysqlhotcopy and all is fine.
Daniel da Veiga wrote:
>
> On 1/23/07, Alex Arul <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
>> tables and copying them or shutting down the server and taring the entire
>> MySQL directory
On 1/23/07, Alex Arul <[EMAIL PROTECTED]> wrote:
Hi,
MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
tables and copying them or shutting down the server and taring the entire
MySQL directory if you are using innodb. If you are using innodb tables only
you can run mysqldu
Hi All !
I did "mysqldump mydb -uroot -ppass --databases --add-locks
--allow-keywords --create-options --extended-insert --routines -r file.sql"
and after that in MySQL Command Line Client "source file.sql"
After that my view was converted to an empty table.
What should I do to backup and r
12 matches
Mail list logo