Hi!
I want to get amount of disk space used by certain rows on disk, not a whole
table, but only some rows. Is this possible?
For example I got a table like:
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`parent_category_id` int(
> From: "Arthur Lessard" <[EMAIL PROTECTED]>
>
> > Thanks, Juan, and Patrik as well, this helped
> > immensely. I can get postfix working, and it seems to
> > read the mysql tables on startup, which it wouldn't do
> > before.
great :)
> > However, I still have one bad problem - it
> > won't
From: "Arthur Lessard" <[EMAIL PROTECTED]>
> This is probably a topic that has been beaten to
> death, but I need help in finding a resource for
> getting postfix to support mysql on RedHat 8.0.
You can use Simon J. Mudd's SRPMs or Tuomo Soini's ones...
Simon J. Mudd's:
http://postfix.wl0.org/e
Hi,
Does anybody know of any MySQL vs. PostgreSQL recent article?
I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x
Thanks in advance,
Juan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> Why do you want to store the sum of columns? You can just sum them when
> you retrieve data.
The database has got about 1 million records, and it gorws day by day
The query I need returns lots of records, and calculating it while
retrieving data
Hi, I got the following question:
Imagine I have a table with 3 colums (column1, column2, column3), which are
of type INT.
I want the data in column3 to be generated automatically from the one in
column1 and column2 when it is inserted
For example a sum, that the data in column3 be the sum of col
> From: "Sheryl Canter" <[EMAIL PROTECTED]>
>
> > > DISTINCT removes duplicates: rows that are the same in *all* columns.
> >
> > Would this be all columns in the table, or all columns retrieved by the
> > SELECT statement?
in the SELECT statement :)
SELECT queries do not alter your rows, you
From: "Frank LIU" <[EMAIL PROTECTED]>
> I also did some other test:
> I ceated two tables both only have two columns, and both load 5 rows.
> Talbe A has two int type columns,
> Table B has an int type as primary key, and a mediumblob column. I insert
a
> 4k data into blob column of each row.
Hi,
I'd like to know when the final MySQL 4.1 is expected to be released.
I know it's in alpha state now, so I guess it's not recomendable for
production yet..
What about 4.0?
Can it be already used for production?
Another thing..
I'm about to make a kind of yahoogroups in PHP. It's for a Unive