How to define the initial space for a table

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

Re: How to define the initial space for a table

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 alba.albe...@libero.itwrote:

Re: Allowing Connections From Remote Clients

On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar aim.prab...@gmail.com 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'

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

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 pelj...@yahoo.co.uk

Select w/ group by question

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

Re: Select w/ group by question

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

Re: Select w/ group by question

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.

RE: Select w/ group by question

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 is

Re: Select w/ group by question

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(