storedproc_master.inc

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· INC 代码 · 共 2,828 行 · 第 1/5 页

   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE distinctrow()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE div()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE double()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE drop()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE dual()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE each()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE else()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE elseif()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE enclosed()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE escaped()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE exists()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE exit()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE explain()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE false()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE fetch()
   SELECT * from t1 where f2=f1;

#FIXME check this is OK:--error 1064
CREATE PROCEDURE fields()
   SELECT * from t1 where f2=f1;
DROP PROCEDURE fields;

--error 1064
CREATE PROCEDURE float()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE for()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE force()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE foreign()
   SELECT * from t1 where f2=f1;

#FIXME check this is OK:--error 1064
CREATE PROCEDURE found()
   SELECT * from t1 where f2=f1;
DROP PROCEDURE found;

--error 1064
CREATE PROCEDURE from()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE fulltext()
   SELECT * from t1 where f2=f1;

#FIXME check this is OK:--error 1064
CREATE PROCEDURE goto()
   SELECT * from t1 where f2=f1;
DROP PROCEDURE goto;

--error 1064
CREATE PROCEDURE grant()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE group()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE having()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE high_priority()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE hour_microsecond()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE hour_minute()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE hour_second()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE if()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE ignore()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE in()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE index()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE infile()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE inner()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE inout()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE insensitive()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE insert()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE int()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE integer()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE interval()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE into()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE is()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE iterate()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE join()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE key()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE keys()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE kill()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE leading()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE leave()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE left()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE like()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE limit()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE lines()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE load()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE localtime()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE localtimestamp()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE lock()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE long()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE longblob()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE longtext()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE loop()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE low_priority()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE match()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE mediumblob()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE mediumint()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE mediumtext()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE middleint()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE minute_microsecond()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE minute_second()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE mod()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE modifies()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE natural()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE not()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE no_write_to_binlog()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE null()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE numeric()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE on()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE optimize()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE option()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE optionally()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE or()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE order()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE out()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE outer()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE outfile()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE precision()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE primary()
   SELECT * from t1 where f2=f1;

#FIXME check this is OK:--error 1064
CREATE PROCEDURE privileges()
   SELECT * from t1 where f2=f1;
DROP PROCEDURE privileges;

--error 1064
CREATE PROCEDURE procedure()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE purge()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE read()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE reads()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE real()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE references()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE regexp()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE rename()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE repeat()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE replace()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE require()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE restrict()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE return()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE revoke()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE right()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE rlike()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE schema()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE schemas()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE second_microsecond()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE select()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sensitive()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE separator()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE set()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE show()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE smallint()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE soname()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE spatial()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE specific()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sql()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sqlexception()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sqlstate()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sqlwarning()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sql_big_result()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sql_calc_found_rows()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE sql_small_result()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE ssl()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE starting()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE straight_join()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE table()
   SELECT * from t1 where f2=f1;

#FIXME check this is OK:--error 1064
CREATE PROCEDURE tables()
   SELECT * from t1 where f2=f1;
DROP PROCEDURE tables;

--error 1064
CREATE PROCEDURE terminated()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE then()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE tinyblob()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE tinyint()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE tinytext()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE to()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE trailing()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE trigger()
   SELECT * from t1 where f2=f1;

--error 1064
CREATE PROCEDURE true()
   SELECT * from t1 where f2=f1;