扇扇子的炼丹师

文章目录Selecting all dataSelecting Particular RowsSelecting Particular ColumnsSorting RowsDATA calculationsCounting Rows Selecting all data mysql> SELECT * FROM pet; +----------+--------+---------+------+------------+------------+ | name | owener | spe

文章目录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

文章目录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

文章目录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