[SQL][MYSQL]Dobrze robie ?, prosze o sprawdzenie Opcje

[kjiu]

Witam..

Troche glupia prozba ale czy dobrze to napisalem ?

CREATE TABLE `users` (
`user_id` int(8) NOT NULL auto_increment,
`user_nick` varchar(20) NOT NULL default '',
`user_login` varchar(20) NOT NULL default '',
`user_password` varchar(30) NOT NULL default '',
`user_emial` varchar(40) NOT NULL default '',
`user_birthdate` DATETIME NOT NULL default '',
`user_live` varchar(30) NOT NULL default '',
`user_like` varchar(25) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT
INTO `uzytkownicy` VALUES (1, 'admin', 'admin', 'db42fd', 'kevinek0@wp.pl', ' ', 'Tarnów', 'Php');

Chodzi mi oto zebym pozniej problemow nie mial (IMG:http://forum.php.pl/style_emoticons/default/dry.gif)

Ten post edytował kjiu 22.04.2009, 13:46:08

[Spawnm]

nie słyszałem o ENGINE , daj TYPE=MyISAM

[phpion]

nie słyszałem o ENGINE

http://dev.mysql.com/doc/refman/5.1/en/create-table.html

The older TYPE option was synonymous with ENGINE. TYPE has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed as of MySQL 5.2. You should not use TYPE in any new applications, and you should immediately begin conversion of existing applications to use ENGINE instead.

Możliwe, że autor używa star(sz)ej wersji MySQL i zmiana ENGINE -> TYPE pomoże.