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?
Regards,
Ravi.
Hi Prasad
This question got me a bit interested as we're thinking of moving
some MyISAM tables to InnoDB and I haven't used it much.
I decided to test some of these ideas so I created an innodb table
and put some data into it and tried some selects:
(Running on MacBook Pro, 2.0ghz, 1gb
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
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
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
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
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.
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.
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
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
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
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
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,
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,
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 is
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
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
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
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
[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,
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
21 matches
Mail list logo