![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
文章平均质量分 68
HHVic
网络
展开
-
MySQL8 - Day4 - Table
文章目录Selecting all dataSelecting Particular RowsSelecting Particular ColumnsSorting RowsDATA calculationsCounting RowsSelecting all datamysql> SELECT * FROM pet;+----------+--------+---------+------+------------+------------+| name | owener | spe原创 2021-05-27 16:29:14 · 88 阅读 · 0 评论 -
MySQL8 - Day3 - Creating and Using a Database
文章目录Creating and Selecting a DatabaseCreating a TableLoading Data into a TableCreating and Selecting a DatabaseBefore Creating a Database, you should like to check the existing database in your server.mysql> SHOW DATABASES;+--------------------+| D原创 2021-05-24 14:58:00 · 151 阅读 · 0 评论 -
MySQL8 - Day2 - Prompt
文章目录Set your own PromptSet your own PromptParameterDescription/DIntegrated Date and Time/dCurrent Database/hServer Name/uCurrent User#mysql -u root -p prompt HHVic> It's also working mysql> prompt HHVic>HHVic>H原创 2021-05-21 16:41:20 · 102 阅读 · 0 评论 -
MySQL8 - Day1 - Installation and initialized configuration
文章目录DownloadInstallationDownloadhttps://dev.mysql.com/downloads/mysql/InstallationNow it’s zip file, unzip it to C:\mysql8Create a new file my.ini to this folderCopy the following text into my.ini[mysqld]# 设置3306端口port=3306# 设置mysql的安装目录ba原创 2021-05-20 16:25:36 · 79 阅读 · 0 评论