![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mariadb
okman312
底层it工作者
展开
-
powerdns执行创建表语句报错
ERROR 1709 (HY000) at line 12: Index column size too large. The maximum column size is 767 bytes.具体报错语句是CREATE TABLE tsigkeys ( id INT AUTO_INCREMENT, name VARCHAR(255), algorithm VARCHAR(50), secr原创 2020-10-04 11:29:00 · 105 阅读 · 0 评论 -
第16周
题1mysql的数据库备份脚本[root@use07 ~]# cat sqlback.sh #!/bin/bashwhile true;docat<<EOF backup mode: full databases -- f single databases -- sEOFread -p "enter f|s: " cho if [ $cho == 'f' -o $cho == 'F' ];then while true;do原创 2020-08-29 21:36:26 · 74 阅读 · 0 评论 -
mariadb安装与卸载插件
mariadb上有很多功能插件,下面简要的说一下在命令行中的安装与卸载方法。本例以实现半同步功能的插件为例。安装MariaDB [(none)]> install plugin rpl_semi_sync_slave soname 'semisync_slave.so';Query OK, 0 rows affected (0.00 sec)卸载MariaDB [(none)]> uninstall plugin rpl_semi_sync_slave;Query OK, 0 ro原创 2020-08-17 20:43:31 · 823 阅读 · 0 评论 -
mariadb创建函数报错
MariaDB [hellodb]> create function simpleFun() returns varchar(20) return "hello world!";ERROR 1418 (HY000): 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 th原创 2020-08-06 08:28:03 · 383 阅读 · 0 评论 -
第15周
题1导入数库据,并查询[root@use01 ~]# mysql -uroot -p123 < hellodb_innodb.sql[root@use01 ~]# mysql -uroot -p123MariaDB [(none)]> use hellodb;MariaDB [hellodb]> select name,age from students where age > 25 and gender = 'm';+--------------+-----+|原创 2020-07-26 15:12:18 · 83 阅读 · 0 评论 -
cenos7.6编译安装mariadb
安装依赖包yum install bison bison-devel zlib-devel libcurl-devel libarchive-devel boostdevel \gcc gcc-c++ cmake ncurses-devel gnutls-devel libxml2-devel openssl-devel libevent-devel libaio-devel准备安装包[root@use03 ~]# mkdir /tools[root@use03 tools]# cd /tool原创 2020-07-17 11:31:22 · 386 阅读 · 0 评论