查看视图创建语句

SELECT
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
SUBSTRING_INDEX(LOAD_FILE('C:\Users\Loki\Downloads\mysql-5.6.17-winx64\data\course\v.frm'),
'
source=',-1),
'\_','\_'), '\%','\%'), '\\','\'), '\Z',''), '\t','	'),
'\r','
'), '\n','
'), '\b',''), '\"','"'), '\'','''),
'\0','')
AS source;

其中load_file()中的地址用

mysql> show global variables like "%datadir%";

可查看