[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

[kjiu]

C:\usr\mysql\bin>mysql -h localhost -u root -p krasnal
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 3.23.58-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database portal;
ERROR 1007: Nie mo┐na stworzyŠ bazy danych 'portal'. Baza danych ju┐ istnieje
mysql> drop database portal;
Query OK, 0 rows affected (0.00 sec)

mysql> create database portal;
Query OK, 1 row affected (0.00 sec)

mysql> use portal;
Database changed
mysql> 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 `user_id` (`user_id`)
-> ) TYPE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
ERROR 1064: Something is wrong in your syntax obok 'DEFAULT CHARSET=latin1 AUTO_
INCREMENT=2' w linii 11
mysql>
mysql>
mysql>
mysql> INSERT
-> INTO `users` VALUES (1, 'admin', 'admin', 'db42fd', 'kevinek0@wp.pl', ' '
, 'Tarnów', 'Php');
ERROR 1146: Table 'portal.users' doesn't exist
mysql>
mysql>

(IMG:http://forum.php.pl/style_emoticons/default/sadsmiley02.gif) (IMG:http://forum.php.pl/style_emoticons/default/sadsmiley02.gif)

prosze o odpowiedz

pomoze ktos (IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif)