D:wampbinmysqlmysql5.6.17bin>dir 驱动器 D 中的卷是 软件 卷的序列号是 0004-12AF D:wampbinmysqlmysql5.6.17bin 的目录2016/04/16  12:51    <DIR>          .2016/04/16  12:51    <DIR>          ..2014/05/01  14:38           134,656 echo.exe2014/05/01  14:38         4,067,840 innochecksum.exe2014/05/01  14:38         4,523,008 myisamchk.exe2014/05/01  14:38         4,306,432 myisamlog.exe2014/05/01  14:38         4,431,360 myisampack.exe2014/05/01  14:38         4,398,592 myisam_ftdump.exe2014/05/01  14:38         4,856,320 mysql.exe2014/05/01  14:38         4,745,728 mysqladmin.exe2014/05/01  14:38         4,912,640 mysqlbinlog.exe2014/05/01  14:38         4,739,072 mysqlcheck.exe2014/05/01  14:38        32,940,032 mysqld-debug.exe2014/05/01  14:38        12,942,848 mysqld.exe2014/05/01  14:38         4,813,312 mysqldump.exe2014/05/01  14:38             7,635 mysqldumpslow.pl2014/05/01  14:38            27,732 mysqld_multi.pl2014/05/01  14:38            36,010 mysqlhotcopy.pl2014/05/01  14:38         4,732,928 mysqlimport.exe2014/05/01  14:38         4,732,416 mysqlshow.exe2014/05/01  14:38         4,759,040 mysqlslap.exe2014/05/01  14:38         5,038,592 mysqltest.exe2014/05/01  14:38        13,902,336 mysqltest_embedded.exe2014/05/01  14:38         5,230,080 mysql_client_test.exe2014/05/01  14:38        14,152,192 mysql_client_test_embedded.exe2014/05/01  14:38             9,079 mysql_config.pl2014/05/01  14:38         4,532,736 mysql_config_editor.exe2014/05/01  14:38             4,504 mysql_convert_table_format.pl2014/05/01  14:38        13,757,952 mysql_embedded.exe2014/05/01  14:38         4,078,080 mysql_plugin.exe2014/05/01  14:38            10,518 mysql_secure_installation.pl2014/05/01  14:38         3,955,200 mysql_tzinfo_to_sql.exe2014/05/01  14:38         4,227,072 mysql_upgrade.exe2014/05/01  14:38         4,059,136 my_print_defaults.exe2014/05/01  14:38         4,192,768 perror.exe2014/05/01  14:38         3,970,560 replace.exe2014/05/01  14:38         4,057,088 resolveip.exe              35 个文件    191,285,494 字节               2 个目录 39,392,387,072 可用字节

D:wampbinmysqlmysql5.6.17bin>mysql -uroot -pEnter password: ********Welcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 24Server version: 5.6.17 MySQL Community Server (GPL)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || game               || mysql              || performance_schema || test               |+--------------------+5 rows in set (0.00 sec)

mysql> create database demo;Query OK, 1 row affected (0.01 sec)

mysql> use demo;Database changed

mysql> create table user(id int,name varchar(25),age int(2));Query OK, 0 rows affected (0.06 sec)

mysql> insert into user(id,name,age) values(1,'xiaoming',20);Query OK, 1 row affected (0.09 sec)

mysql> select * from user;+------+----------+------+| id   | name     | age  |+------+----------+------+|    1 | xiaoming |   20 |+------+----------+------+1 row in set (0.00 sec)

mysql> drop table user;Query OK, 0 rows affected (0.03 sec)

mysql> drop database demo;Query OK, 0 rows affected (0.01 sec)

mysql> create table user(    -> id int(11) unsigned auto_increment primary key,    -> name varchar(30) not null default '',    -> age int(2) not null default '0')engine=innodb DEFAULT CHARSET=utf8;Query OK, 0 rows affected (0.06 sec)

    查看mysql版本        mysql> s    查看数据库        mysql> show databases;    创建数据库        mysql> create database mytest;    查看数据库字符编码        mysql> show create database mytest;    删除数据库        mysql> drop database mytest;    切换数据库        mysql> use game;    查看表        mysql> show tables;    创建一张表        create table 表名(字段1 属性，字段2 属性);        mysql> create table user(id int,name varchar(25),age int(2));    查看表结构        mysql> desc user;    查看表数据        mysql> select * from user;    插入表数据        insert into 表名(字段1，字段2，字段3) values(值1，值2，值3);        mysql> insert into user(id,name,age) values(1,'xiaoming',18);    修改表数据        update 表名 set 字段1 ='字段1值'，字段2='字段2值' where 主键字段='值'        mysql> update user set name='lisi' whert id=1;    删除表数据        delete from 表名称 where (主键)    字段='字段值';    删除表        mysql> drop table user;    创建表的连贯操作        mysql> create table user(        -> id int(11) unsigned auto_increment primary key,        -> name varchar(30) not null default '',        -> age int(2) not null default '0')engine=innodb DEFAULT CHARSET=UTF8;    mysql> show create table user;