qq_43521551的博客

问题简介[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)[Err] 1418-此函数中没有声明DETERMINISTIC，NO SQL或REA

概述MySQL中以下几个个常用子句及其用法IN子句EXISTS子句ANY子句ALL子句用例表-- 创建一张用例表drop table if exists tb_user;create table tb_user(id int auto_increment,name char(10),age int,sex char(2),primary key(id))ENGINE=INNODB DEFAULT CHARSET=utf8mb4 auto_increment=

MySQL数据库编码查询查看数据库版本select VERSION()查看指定数据库的charset编码、collate排序规则等信息select * from information_schema.schemata where schema_name = 'equipmanage';查看表各字段的类型、以及collation编码show full columns from `tb_temp`;查看表的编码show create table `tb_temp`;修改数据库默认编码及

tb_temp表中某一字段