mysql drop database

mysql数据库简单操作的命令:

1.登录数据库:

[ysq@localhost Desktop]$ mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1882
Server version: 5.7.21 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 its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

2.列举显示所有的数据库信息

mysql> show databases;
+-----------------------------------+
| Database                          |
+-----------------------------------+
| information_schema                |
| ak_pro_mg_5_28                    |
| ak_pro_yii_5_28                   |
| lollicupstore                     |
| magento1938                       |
| magento_martinjeung_20180607_test |
| mysql                             |
| performance_schema                |
| sys                               |
+-----------------------------------+
9 rows in set (0.01 sec)

3. 创建数据库

mysql> create database qiu;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+-----------------------------------+
| Database                          |
+-----------------------------------+
| information_schema                |
| ak_pro_mg_5_28                    |
| ak_pro_yii_5_28                   |
| lollicupstore                     |
| magento1938                       |
| magento_martinjeung_20180607_test |
| mysql                             |
| performance_schema                |
| qiu                               |
| sys                               |
+-----------------------------------+
10 rows in set (0.00 sec)

4. 删除数据库

mysql> drop database qiu;
Query OK, 0 rows affected (0.02 sec)

mysql> create database lollicup;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+-----------------------------------+
| Database                          |
+-----------------------------------+
| information_schema                |
| ak_pro_mg_5_28                    |
| ak_pro_yii_5_28                   |
| lollicup                          |
| lollicupstore                     |
| magento1938                       |
| magento_martinjeung_20180607_test |
| mysql                             |
| performance_schema                |
| sys                               |
+-----------------------------------+
10 rows in set (0.00 sec)

mysql> 

5. 导入数据库的操作,首先要创建一个空的数据库 例如:lollicup

[ysq@localhost Desktop]$ mysql -uroot -p lollicup < /home/ysq/Desktop/lollic6_magento.sql;
Enter password: 
[ysq@localhost Desktop]$

6 . 创建表结构:

mysql> show databases;
+-----------------------------------+
| Database                          |
+-----------------------------------+
| information_schema                |
| ak_pro_mg_5_28                    |
| ak_pro_yii_5_28                   |
| lollicup                          |
| lollicupstore                     |
| magento1938                       |
| magento_martinjeung_20180607_test |
| mysql                             |
| performance_schema                |
| sys                               |
+-----------------------------------+
10 rows in set (0.00 sec)

mysql> use lollicup;
Database changed
mysql> CREATE TABLE `homepagebanner` (
  `homepagebanner_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` int(11) NOT NULL DEFAULT '0',
  `image` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`homepagebanner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

8. 向表里面插入数据:

mysql> INSERT INTO `homepagebanner` VALUES ('1', '1', '/media/homepagebanner/02.jpg', '');
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `homepagebanner` VALUES ('2', '2', '/media/homepagebanner/2.jpg', '24444');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `homepagebanner` VALUES ('3', '3', '/media/homepagebanner/banner1-Boba-List.jpg', '35511');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `homepagebanner` VALUES ('4', '4', '', '46622');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `homepagebanner` VALUES ('5', '5', '', '62211');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `homepagebanner` VALUES ('6', '0', '/media/homepagebanner/01.jpg', 'http://lollicuptest.net/1883-syrup-wire-rack-6-bottles.html');
Query OK, 1 row affected (0.00 sec)

mysql> 

Leave a comment

您的电子邮箱地址不会被公开。 必填项已用*标注