已采纳回答 / 慕仙7189323
this function is removed in MySQL8.0.11please check the R&M for more details
2018-07-12
最赞回答 / 慕田峪4123210
mysql> SELECT goods_id,goods_name，cate_name FROM tdb_goods INNER JOIN tdb_goods_cates -> ON tdb_goods.cate_id = tdb_goods_cates.cate_id;ERROR 1054 (42S22): Unknown column 'goods_name，cate_name' in 'field list'
2018-07-06
我的直接就展示返回的结果了i哎 没有用into 我忘了 结果就直接显示了
-> SELECT COUNT(ID) FROM users；
mysql> CALL removeANDreturn(4,@unm)//
+-----------+
| COUNT(ID) |
+-----------+
| 6 |
+-----------+
1 row in set (0.01 sec)
-> SELECT COUNT(ID) FROM users；
mysql> CALL removeANDreturn(4,@unm)//
+-----------+
| COUNT(ID) |
+-----------+
| 6 |
+-----------+
1 row in set (0.01 sec)
2018-07-04
MySQL下载配置环境，新建一个my.ini配置文件，输入以下内容：
[mysql]
basedir = D:\\mysql-8.0.11-winx64\\mysql-8.0.11-winx64
[mysqld]
port = 3306 //端口设置
datadir = D:\\mysql-8.0.11-winx64\\mysql-8.0.11-winx64\\data
[mysql]
basedir = D:\\mysql-8.0.11-winx64\\mysql-8.0.11-winx64
[mysqld]
port = 3306 //端口设置
datadir = D:\\mysql-8.0.11-winx64\\mysql-8.0.11-winx64\\data
2018-07-03
