mysql点进去是什么样

更新时间:02-02 教程 由 念旧 分享

MySQL是一种开源的关系型数据库管理系统,它被广泛应用于各种应用程序的数据存储和管理。当我们打开MySQL时,我们将看到以下内容:

Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.22 MySQL Community Server (GPL)Copyright (c) 2000, 2018, 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>

这是MySQL监视器的欢迎界面,我们可以在MySQL监视器中执行各种SQL命令。下面是一些基本命令,您可以在MySQL监视器中尝试:

mysql> SHOW DATABASES;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.00 sec)mysql> CREATE DATABASE mydatabase;Query OK, 1 row affected (0.00 sec)mysql> USE mydatabase;Database changedmysql> CREATE TABLE mytable (-> id INT,-> name VARCHAR(255),-> age INT-> );Query OK, 0 rows affected (0.00 sec)mysql> INSERT INTO mytable (id, name, age) VALUES (1, 'Alice', 18);Query OK, 1 row affected (0.00 sec)mysql> SELECT * FROM mytable;+------+------+-----+| id | name | age |+------+------+-----+| 1 | Alice| 18 |+------+------+-----+1 row in set (0.00 sec)

这些基本命令可以帮助您开始使用MySQL,尝试在您的本地计算机上安装MySQL,并使用这些命令创建您自己的数据库和表。祝你好运!

声明:关于《mysql点进去是什么样》以上内容仅供参考,若您的权利被侵害,请联系13825271@qq.com
本文网址:http://www.25820.com/tutorial/14_2082871.html