MySQL
文章平均质量分 68
HHVic
网络
展开
-
MySQL8 - Day4 - Table
文章目录Selecting all dataSelecting Particular RowsSelecting Particular ColumnsSorting RowsDATA calculationsCounting Rows Selecting all data mysql> SELECT * FROM pet; +----------+--------+---------+------+------------+------------+ | name | owener | spe原创 2021-05-27 16:29:14 · 74 阅读 · 0 评论 -
MySQL8 - Day3 - Creating and Using a Database
文章目录Creating and Selecting a DatabaseCreating a TableLoading Data into a Table Creating and Selecting a Database Before Creating a Database, you should like to check the existing database in your server. mysql> SHOW DATABASES; +--------------------+ | D原创 2021-05-24 14:58:00 · 140 阅读 · 0 评论 -
MySQL8 - Day2 - Prompt
文章目录Set your own Prompt Set your own Prompt Parameter Description /D Integrated Date and Time /d Current Database /h Server Name /u Current User #mysql -u root -p prompt HHVic> It's also working mysql> prompt HHVic> HHVic> H原创 2021-05-21 16:41:20 · 92 阅读 · 0 评论 -
MySQL8 - Day1 - Installation and initialized configuration
文章目录DownloadInstallation Download https://dev.mysql.com/downloads/mysql/ Installation Now it’s zip file, unzip it to C:\mysql8 Create a new file my.ini to this folder Copy the following text into my.ini [mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 ba原创 2021-05-20 16:25:36 · 69 阅读 · 0 评论