mysql> select database();
+------------+
| database() |
+------------+
| test11 |
+------------+
1 row in set (0.00 sec)
查看使用的表
mysql> use test11;
Database changed
mysql> show tables
-> ;
+------------------+
| Tables_in_test11 |
+------------------+
| t |
+------------------+
1 row in set (0.00 sec)
删除表
mysql> drop table t;
Query OK, 0 rows affected (0.00 sec)
创建一个innodb的表
mysql> create table t (id int) engine=innodb;
Query OK, 0 rows affected (0.06 sec)
文件产生
ywx@ywx:/opt/mysql5151/data/test11$ ls
db.opt t.frm
阅读(721) | 评论(0) | 转发(0) |
