Peter
Thanks for the link. I've never run across this page before, but it has
tons of useful informationas well as several answers on how to implement
what I was trying to do.
Ended up going with a solution similar to this example (from the page you
referenced):
SELECT
item,
SUBSTR( MIN
> Date: Wed, 14 Jul 2010 10:25:22 -0400
> Subject: Select w/ group by question
> From: smulle...@gmail.com
> To: mysql@lists.mysql.com
>
> I'm having trouble formulating a query to gather the following data. I can
> do this via a script, but now it is more or less just bothering me if there
On Wednesday, July 14, 2010 09:25:22 am Scott Mullen wrote:
> I'm having trouble formulating a query to gather the following data. I can
> do this via a script, but now it is more or less just bothering me if there
> is an easy/efficient way to gather the following data from a single query.
>
> E
Scott,
I would like to obtain the least cost of each product type and its
associated vendor.
See "Within-group aggregates" at
http://www.artfulsoftware.com/infotree/queries.php.
PB
-
On 7/14/2010 9:25 AM, Scott Mullen wrote:
I'm having trouble formulating a query to gather the follo
I'm having trouble formulating a query to gather the following data. I can
do this via a script, but now it is more or less just bothering me if there
is an easy/efficient way to gather the following data from a single query.
Example Tables
Products
Type Cost Vendor_id
-
Options such as these are set in my.cnf/my.ini (depending on your host
operating system).
innodb_file_per_table is a very useful option but not neccessarily the
best choice for a novice trying to set up replication.
- michael dykman
On Tue, Jul 13, 2010 at 5:43 AM, lejeczek wrote:
> I'm a novi
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrote:
> GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY
> PASSWORD 'password';
>
> *.* ie for all databases , if want on particular DB
>
> GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com'
> IDENTIFIED BY
I am no sure you are taking about cluster table space or innodb table space.
Just check :
http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
On Wed, Jul 14, 2010 at 2:52 PM, alba.albetti wrote:
> Is it possible in My
Is it possible in MySQL to define the initial space that the table is going to
use and the space for its growth? I usually work on Oracle where the syntax is:
create table MYTABLE
(...fields...)
tablespace MYTABLESPACE
(initial 2M
next 1M);
that means Oracle reserves a data block of 2Mb for
