mysql加視圖查詢(xún)，怎么在程序中用動(dòng)態(tài)sql語(yǔ)句創(chuàng)建視圖？
試試這個(gè)方法：
stringMysqlMysql = "CREATE TABLE Employee "&
+"(emp_id integer not null,"&
+"dept_id integer not null, "&
+"emp_fname char(10) not null, "&
+"emp_lname char(20) not null)"
EXECUTE IMMEDIATE :Mysql USING SQLCA;