01-05-2008, 08:06 PM
|
#24 (permalink)
|
|
The Acquainted
Join Date: Nov 2007
Posts: 154
Thanks: 31
|
Quote:
Originally Posted by Aaron
Actually, SOCK, when I create a table over another table I get an error saying there is already a table.
|
Yes, this is why I suggest using IF NOT EXISTS in your CREATE TABLE statement.
Quote:
Originally Posted by Aaron
I also don't see the need for data types that are so peculiar... Saving space really isn't a problem in today's world.
|
No offense, but you don't plan on having many records in your database then, or want your application to work efficiently.
Quote:
Originally Posted by Aaron
What is this engine=myisam?
wouldn't you want your default charset to be utf-8?
|
As VillageIdiot stated, it's the table type, whether InnoDB, MyISAM, HEAP, etc. Used to be MyISAM was the default table type, but has been replaced by InnoDB on most installations. Either one of these will serve you fine, but I prefer to use MyISAM on 'regular' tables I don't need any special constraints on. Thus I specify the table/engine type for each table.
As to the character set, if you want it set to UTF-8, that's fine. Please be aware, the default character set is usually latin1_swedish_ci, even if the server is set to UTF-8.
MySQL Manual : Character set support |
|
|
|