create a new table in a tablespace...
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...
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...
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...
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