create a new table in a tablespace...

2002-06-18 Thread Silmara Cristina Basso

I'm using MySQL 4.0.1 and my question is How can i do to create a new table
in a tablespace?.

Thank you!




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: create a new table in a tablespace...

2002-06-18 Thread Egor Egorov

Silmara,
Tuesday, June 18, 2002, 3:43:48 PM, you wrote:

SCB I'm using MySQL 4.0.1 and my question is How can i do to create a new table
SCB in a tablespace?.

Tablespaces are used only for InnoDB tables. If you create InnoDB
table, it will be stored in InnoDB tablespace. How to create InnoDB
tables read in the manual:
   http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html

SCB Thank you!





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: create a new table in a tablespace...

2002-06-18 Thread Silmara Cristina Basso

If i had more than one tablespace,  don't i control where it will be stored
?

- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 18, 2002 11:06 AM
Subject: Re: create a new table in a tablespace...


 Silmara,
 Tuesday, June 18, 2002, 3:43:48 PM, you wrote:

 SCB I'm using MySQL 4.0.1 and my question is How can i do to create a
new table
 SCB in a tablespace?.

 Tablespaces are used only for InnoDB tables. If you create InnoDB
 table, it will be stored in InnoDB tablespace. How to create InnoDB
 tables read in the manual:
http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html

 SCB Thank you!





 --
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Egor Egorov
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: create a new table in a tablespace...

2002-06-18 Thread Orr, Steve

It's not THAT much like Oracle. ;-)

-Original Message-
From: Silmara Cristina Basso [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 9:16 AM
To: [EMAIL PROTECTED]; Egor Egorov
Subject: Re: create a new table in a tablespace...

If i had more than one tablespace, don't i control where it will be stored?

- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 18, 2002 11:06 AM
Subject: Re: create a new table in a tablespace...

 Silmara,
 Tuesday, June 18, 2002, 3:43:48 PM, you wrote:

 SCB I'm using MySQL 4.0.1 and my question is How can i do to create a
new table
 SCB in a tablespace?.

 Tablespaces are used only for InnoDB tables. If you create InnoDB
 table, it will be stored in InnoDB tablespace. How to create InnoDB
 tables read in the manual:
http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html

 SCB Thank you!


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php