Форум » Базар » Data Base(MySQL) » Ответить
Data Base(MySQL)
Nobody RST: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.21-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show database -> ; ERROR 1064: 'SQL 구문에 오류가 있습니다.' 에러 같읍니다. ('database' 명령어 라인 1) mysql> show databases -> ; +----------+ | Database | +----------+ | mysql | +----------+ 1 row in set (0.00 sec) mysql> create database monkey; Query OK, 1 row affected (0.02 sec) mysql> show databases; +----------+ | Database | +----------+ | monkey | | mysql | +----------+ 2 rows in set (0.00 sec) mysql> create table -> \c mysql> create table -> monkey_ -> (ID int, User varchar(20), Sex varchar(1)); ERROR 1046: 선택된 데이타베이스가 없습니다. mysql> use ]monkey ERROR 1049: 데이타베이스 ']monkey'는 알수 없음 mysql> use monkey Database changed mysql> create table -> monkey_ -> (ID int, User varchar(20), Sex varchar(1)); Query OK, 0 rows affected (0.02 sec) mysql> show table -> monkey_ -> \c mysql> show tables; +------------------+ | Tables_in_monkey | +------------------+ | monkey_ | +------------------+ 1 row in set (0.00 sec) mysql> explain monkey_ -> ; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | ID | int(11) | YES | | NULL | | | User | varchar(20) | YES | | NULL | | | Sex | char(1) | YES | | NULL | | +-------+-------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql>
Ответов - 0
полная версия страницы