MySQL安装和基本知识

上个星期，我在op刘老师的带领下，第一次接触了数据库，老师分别给我们讲了很多的关于数据库的知识，例如:数据库的发展和历史，以及如何安装数据库等等许多的专业知识，收获很多的知识，也让我明白数据库的重要性，在前端，后端，数据库知道其中的关联，还明白了面试中数据库的考题比例。
     这也是我上大学除了学习专业课——软件工程 ，第一次接触的其他专业知识，让我对机器语言更加感兴趣。
接下来就是数据库MySQL的安装过程，我的理解就是msi版本的就是老师说的傻瓜版，下载只需要一直按回车就可以 再改个环境变量即可，还明白MySQL不可以随随便便的删除，还有一个zip版本的删除比较方便，但是安装也挺难的，需要改很多东西，不过学会了也是很简单的，安装好之后，又登录进去，明白了如何使用MySQL（/h）可以帮助你了解许多的技巧，还有退出的三种方式/q exit 和quit，还学到了create一个数据库和表格db_clallse和db_hero.
   总结一些一下，这节课学会了许多，也让我对编程更感兴趣，以后的学习还请多多指教！！❤❤❤

mysql> insert into db_hero values(1, "孙悟空", "齐天大圣", 800, "男", "花果山", "金箍棒", "西游世界", "妖族"
);
Query OK, 1 row affected (0.02 sec)

mysql> insert into db_hero values(2, "猪八戒", "天蓬元帅", 500, "男", "高老庄猪窝", "九齿钉耙", "西游世界",
"妖族");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(3, "唐僧", "陈玄奘",40 , "男", "大唐", "九环锡杖", "西游世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(4, "沙僧", "沙悟净", 2000, "男", "流沙河", "降妖宝仗", "西游世界", "人");
Query OK, 1 row affected (0.02 sec)

mysql> insert into db_hero values(5, "刘备", "蜀汉开国皇帝",47 , "男", "中国", "雌雄双股剑", "三国世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(6, "关羽", "蜀汉名将字云长",40 , "男", "中国", "青龙偃月刀", "三国世界", "
人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(7, "张飞", "蜀汉名将字翼德",40 , "男", "中国", "丈八蛇矛", "三国世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(8, "诸葛亮", "蜀汉丞相", 50, "男", "中国茅庐", "羽扇", "三国世界", "人");
Query OK, 1 row affected (0.02 sec)

mysql> insert into db_hero values(9, "曹操", "魏国开国皇帝",50 , "男", "中国", "倚天剑", "三国世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(10, "孙权", "吴国开国皇帝",37 , "男", "中国", "碧玉剑", "三国世界", "人");

Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(11, "林黛玉", "潇湘妃子",40 , "女", "中国", "无", "红楼世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(12, "贾宝玉", "无", 40, "男", "中国", "无", "红楼世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(13, "宋江", "黑三郎 及时雨", 45, "男", "清河县", "朴刀", "水浒世界", "人")
;
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(14, "林冲", "80万禁军教头",40 , "男", "东京", "丈八蛇矛", "水浒世界", "人"
);
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(15, "武松", "打虎英雄", 50, "男", "清河县", "拳头", "水浒世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(16, "鲁智深", "谓州提搳",60 , "男", "关西", "禅杖", "水浒世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(17, "李逵", "江州黑旋风",62 , "男", "浠水县", "板斧", "水浒世界", "人");
Query OK, 1 row affected (0.01 sec)

mysql> insert into db_hero values(18, "卢俊义", "员外", 40, "男", "大名府", "仗二钢鞭", "水浒世界", "人");
Query OK, 1 row affected (0.01 sec)