数据库与表显示、创建、删除
数据库显示
show databases;
mysql>showdatabases;
+--------------------+
|Database|
+--------------------+
|information_schema|
|app_blogcurder|
|auth_demo|
|canzhieps|
|cmsdemo|
|mysql|
|onethink|
|performance_schema|
|ranzhi|
|thinkems|
|thinksns_3_1|
|thinksns_4_0|
+--------------------+
12rowsinset(0.01sec)
创建数据库
create database 库名字;
mysql>createdatabasetest;
QueryOK,1rowaffected(0.00sec)
删除数据库
drop database [IF EXISTS] 库名字;
mysql>dropdatabasetest;
QueryOK,0rowsaffected(0.01sec)
选中数据库
use 库名;
mysql>usemysql
Databasechanged
mysql>\s
--------------
mysqlVer14.14Distrib5.6.17,forWin64(x86_64)
Connectionid:8
Currentdatabase:mysql
Currentuser:root@localhost
SSL:Notinuse
Usingdelimiter:;
Serverversion:5.6.17MySQLCommunityServer(GPL)
显示表
数据表
show tables;[需要县选中数据库]
mysql>usemysql
Databasechanged
mysql>showtables;
+---------------------------+
|Tables_in_mysql|
+---------------------------+
|columns_priv|
|db|
|event|
|func|
|general_log|
......
显示表结构
desc 表名; 或者 describe 表名;
mysql>descdb;
+-----------------------+---------------+------+-----+---------+-------+
|Field|Type|Null|Key|Default|Extra|
+-----------------------+---------------+------+-----+---------+-------+
|Host|char(60)|NO|PRI|||
|Db|char(64)|NO|PRI|||
|User|char(16)|NO|PRI|||
......
表创建
CREATETABLE`member`(
`uid`int(10)unsignedNOTNULLAUTO_INCREMENTCOMMENT'用户ID',
`nickname`char(16)NOTNULLDEFAULT''COMMENT'昵称',
`sex`tinyint(3)unsignedNOTNULLDEFAULT'0'COMMENT'性别',
`birthday`dateNOTNULLDEFAULT'0000-00-00'COMMENT'生日',
`qq`char(10)NOTNULLDEFAULT''COMMENT'qq号',
`score`mediumint(8)NOTNULLDEFAULT'0'COMMENT'用户积分',
`login`int(10)unsignedNOTNULLDEFAULT'0'COMMENT'登录次数',
`reg_ip`bigint(20)NOTNULLDEFAULT'0'COMMENT'注册IP',
`reg_time`int(10)unsignedNOTNULLDEFAULT'0'COMMENT'注册时间',
`last_login_ip`bigint(20)NOTNULLDEFAULT'0'COMMENT'最后登录IP',
`last_login_time`int(10)unsignedNOTNULLDEFAULT'0'COMMENT'最后登录时间',
`status`tinyint(4)NOTNULLDEFAULT'0'COMMENT'会员状态',
PRIMARYKEY(`uid`),
KEY`status`(`status`)
)ENGINE=MyISAMDEFAULTCHARSET=utf8COMMENT='会员表';
表删除
drop table 表名;