# mysql-outfile-plugin

**Repository Path**: netkiller/mysql-outfile-plugin

## Basic Information

- **Project Name**: mysql-outfile-plugin
- **Description**: No description available
- **Primary Language**: C
- **License**: BSD-3-Clause
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-11-20
- **Last Updated**: 2024-02-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

mysql-outfile-plugin
=================

MySQL Outfile Plugin

Build
-----
	cd /usr/local/src/
	git clone https://github.com/netkiller/mysql-outfile-plugin.git
	cd mysql-outfile-plugin/

	yum install -y cmake3
	
	cmake3 .
	make
	make install

	or
	
	gcc -O3  -g  -I/usr/include/mysql -I/usr/include  -fPIC -lm -lz -shared -o liboutfile.so outfile.c
	sudo mv liboutfile.so /usr/lib/mysql/plugin/
	
Plugin Install and Uninstall
--------------

### Install

	create function out2file returns string soname 'liboutfile.so';

### Uninstall

	drop function out2file;

Testing
-------

### 安装插件	

	mysql> create function out2file returns string soname 'liboutfile.so';
	Query OK, 0 rows affected (0.00 sec)

### 调用插件

	mysql> select out2file('/tmp/myoutfile',"Helloworld!!!");
	+--------------------------------------------+
	| out2file('/tmp/myoutfile',"Helloworld!!!") |
	+--------------------------------------------+
	| true                                       |
	+--------------------------------------------+
	1 row in set (0.00 sec)
	
### 查看文件


	root@netkiller ~/mysql-outfile-plugin % cat /tmp/myoutfile
	Helloworld!!!
	

# Donations

We accept PayPal through:

https://www.paypal.me/netkiller

Wechat (微信) / Alipay (支付宝) 打赏:

http://www.netkiller.cn/home/donations.html