Hi,
MySQL creates temporary table to complete the query. However, it doesn't tell
you whether that temporary table will be in memory or on disk. MySQL's
tmp_table_size variable will control the temporary table size.The default
tmp_table_size size is 32 MB
Temporary tables can either be in th
[EMAIL PROTECTED] wrote:
I've installed MySQL, created a database and tables and then loaded fields
into them. I use the command line client and can see the fields, use the
select command and every thing is OK, but when I look for the table files
in the data directory, only the .frm ones appear,
> How do you expect to split a dollar 3 ways?
Sorry, I should have added more smiles, it was supposed to be a joke about
the dollars... ;)
But still, I could win a lot of money by distributing people's money to
their three kids and getting 1 cent out of every operation. :D
> It is not the math
Hello,
A default install should drop data and databases into C:\Program
Files\MySQL\MySQL Server 5.0.\data
If you run something like:
mysql> CREATE DATABASE test1;
Query OK, 1 row affected (0.00 sec)
mysql> USE test1;
Database changed
mysql> CREATE TABLE t (i INT) ENGINE = MYISAM;
Query OK, 0
I've installed MySQL, created a database and tables and then loaded fields
into them. I use the command line client and can see the fields, use the
select command and every thing is OK, but when I look for the table files
in the data directory, only the .frm ones appear, not the .MYI or MYD.
Where
Renato Golin wrote:
Jerry Schwartz wrote:
The difference is that, for example, .01 can be represented exactly
in decimal; but float types are binary, so .01 cannot be represented
exactly. This can lead to all kinds of trouble when doing arithmetic,
the errors accumulate.
Yes! but that can a
In the last episode (Sep 07), [EMAIL PROTECTED] said:
> In http://dev.mysql.com/doc/refman/4.1/en/temporary-files.html says
>
> "MySQL creates all temporary files as hidden files. This ensures that
> the temporary files are removed if mysqld is terminated. The
> disadvantage of using hidden files
I have a legacy app that only supports MySQL 3.23. I'd like to run it
along with 5.0.24a on a Windows 2000 server, with each instance using the
standard port 3306. So I need to have each instance bound to just one IP
address.
In MySQL 3.23 can you specify a bind-address in the my.ini file, o
On Sep 7, 2006, at 3:32 PM, <[EMAIL PROTECTED]> wrote:
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge,
Hi.
In http://dev.mysql.com/doc/refman/4.1/en/temporary-files.html says
"MySQL creates all temporary files as hidden files. This ensures that the
temporary files are removed if mysqld is terminated. The disadvantage of
using hidden files is that you do not see a big temporary file that fil
Jerry Schwartz wrote:
The difference is that, for example, .01 can be represented exactly
in decimal; but float types are binary, so .01 cannot be represented
exactly. This can lead to all kinds of trouble when doing arithmetic,
the errors accumulate.
Yes! but that can also lead to some other
Oooh, oooh, I know!
The difference is that, for example, .01 can be represented exactly in
decimal; but float types are binary, so .01 cannot be represented exactly.
This can lead to all kinds of trouble when doing arithmetic, the errors
accumulate. It's one reason why most people write their loop
On 9/7/06, [EMAIL PROTECTED] wrote:
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge, to avoid my server
Hi Douglas,
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge, to avoid my server running out of
memory. M
Hi Douglas,
I need to know the number of rows that a query will return before
actually executing the query. So I am sending select count(*) before
sending select *. Actually I need to reject queries if the number of
records that it will return is huge, to avoid my server running out of
memory. My
DBTools Software is pleased to announce the new DBManager Standard Edition
version 3.2.0.
This application replaces the old DBManager Freeware Edition (3.1.1) and it
can be used for FREE
in the following conditions:
- Personal use only
You can register the Standard Edition at any time you want an
Bruno Rodrigues Silva wrote:
Dear all.
The MySQL Manual inform that Decimal Data Type is used
for represent exact-number, but like Float Point Data
Type, Decimal use rounding case the fractional part is
not sufficient. Therefore, what the difference?
Hi Bruno,
FLOAT rounds as floating point
Dear all.
The MySQL Manual inform that Decimal Data Type is used
for represent exact-number, but like Float Point Data
Type, Decimal use rounding case the fractional part is
not sufficient. Therefore, what the difference?
Regards
Bruno R. Silva
_
At 11:29 AM +0530 9/7/06, Ravi Kumar. wrote:
Hi All,
I am looking for a data dictionary for MySQL. It should be free and ideally,
developed in php. And such that it stores the data dictionary in MySQL
itself.
Any suggestions / pointers?
If you're using MySQL5, take a look at the information
19 matches
Mail list logo
