mysql的使用18

最新推荐文章于 2021-02-19 11:42:17 发布
最新推荐文章于 2021-02-19 11:42:17 发布
阅读量468 收藏
点赞数
分类专栏： MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u012016940/article/details/39338817
版权
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> #pivoting
mysql> #pivoting 是一项可以把行旋转为列的技术   在执行pivoting的过程中可能会使用到聚合
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| MonthlyOrders  |
| Nums           |
| a              |
| animals        |
| charTest       |
| customers      |
| dept_manager   |
| emp            |
| employees      |
| g              |
| mintable       |
| new_emp        |
| orders         |
| sales          |
| sessions       |
| t              |
| test01         |
| timetest       |
| tt             |
| ttt            |
| updatetime     |
| x              |
| xx             |
| y              |
| yeartest       |
| yy             |
| z              |
+----------------+
27 rows in set (0.01 sec)

mysql> drop table t;
Query OK, 0 rows affected (0.06 sec)

mysql> create table t(
    -> id int,
    -> attribute varchar(10),
    -> value varchar(20),
    -> primary key(id, attribute));
Query OK, 0 rows affected (0.08 sec)

mysql> insert into t select 1,'attr1','BMW';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 1,'attr2','100';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 1,'attr3','2010-01-01';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 2,'attr2','200';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 2,'attr3','2010-03-04';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 2,'attr4','M';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 2,'attr5','55.60';
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 3,'attr1','SUV';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 3,'attr2','10';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 3,'attr3','2011-11-11';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> select * from t;
+----+-----------+------------+
| id | attribute | value      |
+----+-----------+------------+
|  1 | attr1     | BMW        |
|  1 | attr2     | 100        |
|  1 | attr3     | 2010-01-01 |
|  2 | attr2     | 200        |
|  2 | attr3     | 2010-03-04 |
|  2 | attr4     | M          |
|  2 | attr5     | 55.60      |
|  3 | attr1     | SUV        |
|  3 | attr2     | 10         |
|  3 | attr3     | 2011-11-11 |
+----+-----------+------------+
10 rows in set (0.01 sec)

mysql>
mysql> select id,
    -> max(case when attribute='attr1' then value end) as attr1,
    -> max(case when attribute='attr2' then value end) as attr2,
    -> max(case when attribute='attr3' then value end) as attr3,
    -> max(case when attribute='attr4' then value end) as attr4,
    -> max(case when attribute='attr5' then value end) as attr5,
    -> from t
    -> group by id;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from t
group by id' at line 7
mysql> select id, max(case when attribute='attr1' then value end) as attr1, max(case when attribute='attr2' then value end) as attr2, max(case when attribute='attr3' then value end) as attr3, max(case when attribute='attr4' then value end) as attr4, max(case when attribute='attr5' then value end) as attr5  from t group by id;
+----+-------+-------+------------+-------+-------+
| id | attr1 | attr2 | attr3      | attr4 | attr5 |
+----+-------+-------+------------+-------+-------+
|  1 | BMW   | 100   | 2010-01-01 | NULL  | NULL  |
|  2 | NULL  | 200   | 2010-03-04 | M     | 55.60 |
|  3 | SUV   | 10    | 2011-11-11 | NULL  | NULL  |
+----+-------+-------+------------+-------+-------+
3 rows in set (0.00 sec)

mysql> #注意最后一个max不要加逗号
mysql> #pivoting先根据id进行分组，确定行列互转后记录的行数，之后通过已知的五个属性来确定互转后有5列数据，并通过case得到每列的值，由于使用了分组函数取得列的值，这里使用max函数
mysql>
mysql>
mysql> #关系除法    和常见的关系运算join,semi join一样，都是一个关系代数
mysql>
mysql> drop table t;
Query OK, 0 rows affected (0.04 sec)

mysql> create table t(
    -> orderid varchar(10) not null,
    -> productid int not null,
    -> primary key(orderid, productid));
Query OK, 0 rows affected (0.10 sec)

mysql> insert into t select 'A',1;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 'A',2;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 'A',3;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 'A',4;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql>
mysql> insert into t select 'B',2;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 'B',3;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 'B',4;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql>
mysql> insert into t select 'C',3;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into t select 'C',4;
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql>
mysql> insert into t select 'D',4;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> select * from t;
+---------+-----------+
| orderid | productid |
+---------+-----------+
| A       |         1 |
| A       |         2 |
| A       |         3 |
| A       |         4 |
| B       |         2 |
| B       |         3 |
| B       |         4 |
| C       |         3 |
| C       |         4 |
| D       |         4 |
+---------+-----------+
10 rows in set (0.00 sec)

mysql> select orderid from (
    -> select orderid,
    -> max(case when productid=2 then 1 end) as p2,
    -> max(case when productid=3 then 1 end) as p3,
    -> max(case when productid=4 then 1 end) as p4
    -> from t group by orderid) as P
    -> where p2=1 and p3=1 and p4=1;
+---------+
| orderid |
+---------+
| A       |
| B       |
+---------+
2 rows in set (0.00 sec)

mysql> #以上查询的是包含2，3，4订单号的产品
mysql>
mysql> #其实 这里将max改为count似乎更合理  因为没有的需要用0来 而不是null
mysql>
mysql> create table tt(
    -> orderid int not null,
    -> orderdate date not null,
    -> empid int not null,
    -> custid varchar(10) not null,
    -> qty int not null,
    -> primary key(orderid, orderdate));
ERROR 1050 (42S01): Table 'tt' already exists
mysql> create table tttt( orderid int not null, orderdate date not null, empid int not null, custid varchar(10) not null, qty int not null, primary key(orderid, orderdate));
Query OK, 0 rows affected (0.10 sec)

mysql> desc tttt;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| orderid   | int(11)     | NO   | PRI | NULL    |       |
| orderdate | date        | NO   | PRI | NULL    |       |
| empid     | int(11)     | NO   |     | NULL    |       |
| custid    | varchar(10) | NO   |     | NULL    |       |
| qty       | int(11)     | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> insert into tttt select 1,'2010-01-02',3,'A',10;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 2,'2010-04-02',2,'B',20;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 3,'2010-05-02',1,'A',30;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 4,'2010-07-02',3,'D',40;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 5,'2011-01-02',4,'A',20;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 6,'2011-01-02',3,'B',30;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 7,'2011-01-02',1,'C',40;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 8,'2009-01-02',2,'A',10;
Query OK, 1 row affected (0.05 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into tttt select 9,'2009-01-02',3,'B',20;
Query OK, 1 row affected (0.04 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> select * from tttt;
+---------+------------+-------+--------+-----+
| orderid | orderdate  | empid | custid | qty |
+---------+------------+-------+--------+-----+
|       1 | 2010-01-02 |     3 | A      |  10 |
|       2 | 2010-04-02 |     2 | B      |  20 |
|       3 | 2010-05-02 |     1 | A      |  30 |
|       4 | 2010-07-02 |     3 | D      |  40 |
|       5 | 2011-01-02 |     4 | A      |  20 |
|       6 | 2011-01-02 |     3 | B      |  30 |
|       7 | 2011-01-02 |     1 | C      |  40 |
|       8 | 2009-01-02 |     2 | A      |  10 |
|       9 | 2009-01-02 |     3 | B      |  20 |
+---------+------------+-------+--------+-----+
9 rows in set (0.00 sec)

mysql> select cusid,year(orderdate) as year, sum(qty) as sum_qty
    -> from t group by custid,year(orderdate);
ERROR 1054 (42S22): Unknown column 'cusid' in 'field list'
mysql>
mysql> select custid,year(orderdate) as year, sum(qty) as sum_qty from t group by custid,year(orderdate);
ERROR 1054 (42S22): Unknown column 'custid' in 'field list'
mysql>
mysql> select custid,year(orderdate) as year, sum(qty) as sum_qty from tttt group by custid,year(orderdate);
+--------+------+---------+
| custid | year | sum_qty |
+--------+------+---------+
| A      | 2009 |      10 |
| A      | 2010 |      40 |
| A      | 2011 |      20 |
| B      | 2009 |      20 |
| B      | 2010 |      20 |
| B      | 2011 |      30 |
| C      | 2011 |      40 |
| D      | 2010 |      40 |
+--------+------+---------+
8 rows in set (0.00 sec)

mysql> #又是tttt惹得祸。。。。。
mysql> #下面使用旋转将数据变得更加清晰
mysql>
mysql> select custid,
    -> ifnull(sum(case when orderyear=2009 then qty end),0) as '2009',
    -> ifnull(sum(case when orderyear=2010 then qty end),0) as '2010',
    -> ifnull(sum(case when orderyear=2011 then qty end),0) as '2011'
    -> from
    -> (select custid,year(orderdate) as orderyrear, qty from t) as p
    -> group by custid;
ERROR 1054 (42S22): Unknown column 'custid' in 'field list'
mysql>
mysql> select custid, ifnull(sum(case when orderyear=2009 then qty end),0) as '2009', ifnull(sum(case when orderyear=2010 then qty end),0) as '2010', ifnull(sum(case when orderyear=2011 then qty end),0) as '2011' from  (select custid,year(orderdate) as orderyrear, qty from tttt) as p group by custid;
ERROR 1054 (42S22): Unknown column 'orderyear' in 'field list'
mysql>
mysql> select custid, ifnull(sum(case when orderyear=2009 then qty end),0) as '2009', ifnull(sum(case when orderyear=2010 then qty end),0) as '2010', ifnull(sum(case when orderyear=2011 then qty end),0) as '2011' from  (select custid,year(orderdate) as orderyear, qty from tttt) as p group by custid;
+--------+------+------+------+
| custid | 2009 | 2010 | 2011 |
+--------+------+------+------+
| A      |   10 |   40 |   20 |
| B      |   20 |   20 |   30 |
| C      |    0 |    0 |   40 |
| D      |    0 |   40 |    0 |
+--------+------+------+------+
4 rows in set (0.00 sec)

mysql> #ok  这样就非常清晰了
mysql>
mysql> #unpivoting即为pivoting的反响操作 即将列旋转为行。。。
mysql> drop table pp;
ERROR 1051 (42S02): Unknown table 'pp'
mysql> create table pp(
    -> custid varchar(10) not null,
    -> y2009 int null,
    -> y2010 int null,
    -> y2011 int null,
    -> primary key(custid));
Query OK, 0 rows affected (0.09 sec)

mysql> #现在我们可以将上面的表 再次进行行列互转
mysql>
mysql> insert into p
    -> select
    -> custid,
    -> ifnull(sum(case when orderyear=2009 then qty end),0) as '2009',
    -> ifnull(sum(case when orderyear=2010 then qty end),0) as '2010',
    -> ifnull(sum(case when orderyear=2011 then qty end),0) as '2011'
    -> from (select custid, year(orderdate) as orderyear, qty from t) as P
    -> group by custid;
ERROR 1146 (42S02): Table 'test.p' doesn't exist
mysql>
mysql> insert into p select  custid, ifnull(sum(case when orderyear=2009 then qty end),0) as '2009', ifnull(sum(case when orderyear=2010 then qty end),0) as '2010', ifnull(sum(case when orderyear=2011 then qty end),0) as '2011' from (select custid, year(orderdate) as orderyear, qty from t) as pp group by custid;
ERROR 1146 (42S02): Table 'test.p' doesn't exist
mysql>
mysql>
mysql> insert into pp select  custid, ifnull(sum(case when orderyear=2009 then qty end),0) as '2009', ifnull(sum(case when orderyear=2010 then qty end),0) as '2010', ifnull(sum(case when orderyear=2011 then qty end),0) as '2011' from (select custid, year(orderdate) as orderyear, qty from t) as pp group by custid;
ERROR 1054 (42S22): Unknown column 'custid' in 'field list'
mysql>
mysql> desc pp;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| custid | varchar(10) | NO   | PRI | NULL    |       |
| y2009  | int(11)     | YES  |     | NULL    |       |
| y2010  | int(11)     | YES  |     | NULL    |       |
| y2011  | int(11)     | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> insert into pp select  custid, ifnull(sum(case when orderyear=2009 then qty end),0) as '2009', ifnull(sum(case when orderyear=2010 then qty end),0) as '2010', ifnull(sum(case when orderyear=2011 then qty end),0) as '2011' from (select custid, year(orderdate) as orderyear, qty from tttt) as pp group by custid;
Query OK, 4 rows affected (0.04 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> #ok
mysql> select * from pp;
+--------+-------+-------+-------+
| custid | y2009 | y2010 | y2011 |
+--------+-------+-------+-------+
| A      |    10 |    40 |    20 |
| B      |    20 |    20 |    30 |
| C      |     0 |     0 |    40 |
| D      |     0 |    40 |     0 |
+--------+-------+-------+-------+
4 rows in set (0.00 sec)

mysql> #现在unpoviting
mysql> select custid, orderyear,
    -> case orderyear
    ->  when 2009 then y2009
    ->  when 2010 then y2010
    ->  when 2011 then y2011
    -> end as qty
    -> from pp,
    -> (select 2009 as orderyear union all select 2010 union all select 2011) as o;
+--------+-----------+------+
| custid | orderyear | qty  |
+--------+-----------+------+
| A      |      2009 |   10 |
| A      |      2010 |   40 |
| A      |      2011 |   20 |
| B      |      2009 |   20 |
| B      |      2010 |   20 |
| B      |      2011 |   30 |
| C      |      2009 |    0 |
| C      |      2010 |    0 |
| C      |      2011 |   40 |
| D      |      2009 |    0 |
| D      |      2010 |   40 |
| D      |      2011 |    0 |
+--------+-----------+------+
12 rows in set (0.00 sec)

mysql> #现在发现还有0   再次进行过滤
mysql> select custid,orderyear,qty from ( select custid, orderyear, case orderyear  when 2009 then y2009  when 2010 then y2010  when 2011 then y2011 end as qty from pp, (select 2009 as orderyear union all select 2010 union all select 2011) as o) as m where qty<>0;
+--------+-----------+------+
| custid | orderyear | qty  |
+--------+-----------+------+
| A      |      2009 |   10 |
| A      |      2010 |   40 |
| A      |      2011 |   20 |
| B      |      2009 |   20 |
| B      |      2010 |   20 |
| B      |      2011 |   30 |
| C      |      2011 |   40 |
| D      |      2010 |   40 |
+--------+-----------+------+
8 rows in set (0.00 sec)

mysql> #ok  搞定
mysql>
mysql> exit
Jack_Lpz
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Unknown column ‘字段名‘ in ‘field list‘解决方法
y516369的博客
05-19 4万+
Unknown column ‘字段名’ in 'field list’英语翻译过来就是未知列的字段名在字段表中，也就是说数据库表中的字段名在实体类中找不到。 解决方案如下： 查看实体类的属性名和数据库表中的名字是否一致（注意数据库表字段中是否有空格或者下划线） ...
Unknown column 'xxx' in 'field list'
Optimistic
03-30 2万+
可能存在的问题有 1、javaBean和数据库里的字段名不对应，或者配置不匹配； 2、数据库里的字段名可能存在空格之类的细节错误； 3、字段名可能是关键字 总之是和名字有关……
MySQL 使用方法简单教程
chinacodec的专栏
08-08 13万+
MySQL 使用方法简单教程
Unknown column '' in 'field list'解决方案
苏公子的博客
07-08 6万+
很多人在用 php+MySQL 做网站往数据库插入数据时发现如下错误： 注册失败!Unknown column '1a' in 'field list' 结果发现用数字提交是没有问题的，其他如char型就有问题了。 相信小伙伴又坚信SQL语句没写错，那么问题出在哪了。 我们来看下我的SQL语句： --往user表（user和pass列）插入数据，
错误：Unknown column 'a' in 'field list'
xyry
01-12 8239
sql="update stu set name='"+name+"',classes='"+classes+"',score='"+score+"' where id='"+id+"'";必须要加上单引号，才可以区分出来. 字符串必须加单引号，否则会报错
mysql安装使用教程
最新发布
04-23
MySQL是一款广泛使用的开源关系型数据库管理系统，以其高效、稳定、易于管理的特点深受开发者喜爱。本教程将引导您完成MySQL的安装过程，并介绍基本的使用方法。 一、MySQL安装 1. **操作系统兼容性**：MySQL支持...
ubuntu 18 安装MySQL的依赖包
02-09
MySQL可以利用libaio实现更高效的磁盘读写，尤其是当配置为使用直接I/O模式时，能避免文件系统的缓存，提高并发性能。 除了上述两个包，安装MySQL 5.7还可能需要以下依赖： 3. **libssl-dev** 和 **libncurses5-...
MySQL16-18讲
07-11
在MySQL的16到18讲的视频课程中，我们可以期待深入探讨这个广泛使用的开源关系型数据库管理系统的关键概念和技术。以下是对这三讲可能涵盖的知识点的详细解析： 第16讲：通常，这一讲可能会关注数据库设计的基础，...
第18章 MySQL Replication PPT
01-04
4. **监控与故障恢复**：使用`SHOW SLAVE STATUS\G`命令可以查看复制状态，包括延迟情况和错误信息。当主服务器出现故障时，可以将一个从服务器提升为主服务器，继续提供服务。 MySQL Replication还支持主主复制，...
mysql面试题18道.zip
08-07
18. **如何在MySQL中处理大数据？** 对于大数据处理，可以使用分区、分片、列式存储（如InnoDB Cluster或TokuDB）以及使用分布式数据库系统如MySQL Router或MaxScale。 以上内容只是MySQL面试中可能涉及的部分问题...
java后台报错：Unknown column ‘xxx‘ in ‘field list‘
风和日丽的博客
09-27 4万+
解决方法： 1、如果是作插入操作“insert into.....”的话，很可能是插入表的字段没匹配对，比如有一些要求非空的字段，要检查是否都赋了值。 2、查看插入时，赋值是否加了单引号：values（“'”+变量+“'”，'“'”+变量+“'”）。 3、总之，就是要仔细检查sql语句，最好先去数据库中，运行一下看看。 ...
Unknown column '字段名' in 'field list' 错误解决方案
热门推荐
康小超
12-04 35万+
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]SQL Error: 1054, SQLState: 42S22 [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]Unknown column 'this_.CREATE_BY' in 'field list' [org.jeecgframewo...
查询数据库中的数据字段不显示 或者 报Unknown column ‘xxx‘ in ‘field list‘错解决办法(踩坑)
暴走的山交君的博客
01-30 6532
查询数据库中的数据字段不显示 前端首先按F12查看后端返回给前端的数据, 其中的数据的字段名是否与前端自己写的字段的名称是否对应, 返回给前端的字段名不一定和后端定义的字段名完全一致(主要是字母的大小写区分) 这是我踩的坑 这是开发者工具中 : 后端返回给前端的数据 其中的字段名称是这个 rname 而我后端实体类中却是rName 其中是N 所以我前端表格中就写的是rName导致前端取不出数据 导致前端取不出数据, 名字那行是空白. 要改为rname和返回的字段名一样,不要和后端一样. 所以要看
Unknown column ‘字段名‘ in ‘field list‘ 错误解决方案
ITxiaofeixiang的博客
02-19 5万+
解决方案 1.检查实体类属性跟数据表字段名称是否一致 2.检查数据表字段有没有空格或者回车 3.检查数据库编码和数据表字段编码是否一致 4.如果上述都不能解决 那就检查数据库有没有用对！！！ 那就检查数据库有没有用对！！！ 那就检查数据库有没有用对！！！ 有没有切换数据源啊！ 本就是因为用了默认数据源，导致自己怀疑人生！ ...
mysql使用10
Jack_Li
09-15 1975
mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +--------
mysql的使用25
Jack_Li
09-17 1593
mysql> create table listPart(     -> a int,b int)engine=innodb     -> partition p0values in (1,3,5,7,9),     -> partition p0values in (0,2,4,6,8)); ERROR 1064 (42000): You have an error in your SQ
mysql的使用19
Jack_Li
09-17 910
mysql> use test; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> #rollup mysql> #rollup
MySQL使用命令大全
05-10
18. 显示MySQL当前的字符集：show variables like 'character_set_database'; 19. 显示MySQL当前的时区：select @@global.time_zone, @@session.time_zone; 20. 显示MySQL当前的存储引擎：show variables like '...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值