安装完成之后,启动命令行,输入密码,回车,出现几行说明,别的输入如下:
mysql>showdatabases 回车之后,就出现:
->
->\c
mysql>create database test
-> 再回车
->
请问各位,这是怎么回事啊?每次输入完成命令之后,回车,都得不到想要的结果,得到的是:->
说明:服务中有个叫mesql的服务,是启动了的。
mysql>showdatabases 回车之后,就出现:
->
->\c
mysql>create database test
-> 再回车
->
请问各位,这是怎么回事啊?每次输入完成命令之后,回车,都得不到想要的结果,得到的是:->
说明:服务中有个叫mesql的服务,是启动了的。
create database test;
create database test;
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.28-rc-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql-[(none)]> use groupon
Database changed
mysql-[groupon]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| babywar |
| db |
| groupon |
| mysql |
| test |
| tj_groupon |
+--------------------+
7 rows in set (0.00 sec)mysql-[groupon]> create database lym;
Query OK, 1 row affected (0.00 sec)mysql-[groupon]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| babywar |
| db |
| groupon |
| lym |
| mysql |
| test |
| tj_groupon |
+--------------------+
8 rows in set (0.00 sec)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.28-rc-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql-[(none)]> use groupon
Database changed
mysql-[groupon]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| babywar |
| db |
| groupon |
| mysql |
| test |
| tj_groupon |
+--------------------+
7 rows in set (0.00 sec)mysql-[groupon]> create database lym;
Query OK, 1 row affected (0.00 sec)mysql-[groupon]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| babywar |
| db |
| groupon |
| lym |
| mysql |
| test |
| tj_groupon |
+--------------------+
8 rows in set (0.00 sec)mysql-[groupon]> delimiter $$
mysql-[groupon]> use lym;
ERROR 1049 (42000): Unknown database 'lym;'
mysql-[groupon]> use lym
Database changed
mysql-[lym]> create table t_Test(id int, name varchar(20));
-> $$
Query OK, 0 rows affected (0.03 sec)mysql-[lym]> show tables;
-> $$
+---------------+
| Tables_in_lym |
+---------------+
| t_Test |
+---------------+
1 row in set (0.00 sec)mysql-[lym]> show create table t_Test\G
*************************** 1. row ***************************
Table: t_Test
Create Table: CREATE TABLE `t_Test` (
`id` int(11) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)