试一试这个吧 SELECT t1.[select], t1.name FROM t1; 在access下面是好用的 在mysql下面表都没建立起来。
试试 update aaa set "SELECT"=1;
update aaa set "SELECT"=1;
试试update aaa set 用户名.select=1看看
说错了 是试试用别名 SELECT * FROM HISTORY A,NAME B WHERE A.**=……之类的
通过视图 1. CREATE TABLE QQCALLCENTER."HUATEST" ("SELECT" CHAR(10) NOT NULL, "UPDATE" CHAR(10) NOT NULL, "INTO" CHAR(10) NOT NULL, "WHERE" CHAR(10) NOT NULL) ;2. CREATE VIEW vhuatest (a1,a2,a3,a4) AS select "SELECT","UPDATE","INTO","WHERE" from huatest3. select a1,a2,a3,a4 from vhuatest where A4 = 'd';
SELECT "SELECT" FROM 表a;
以下都试了:update aaa set select=1
*
ERROR 位于第 1 行:
ORA-01747: 无效的用户.表.列,表.列,或列规格
---------------------------
update aaa set 'select'=1
*
ERROR 位于第 1 行:
ORA-01747: 无效的用户.表.列,表.列,或列规格---------------------------
update aaa set "select"=1
*
ERROR 位于第 1 行:
ORA-00904: 无效列名
---------------------------怎么办啊,很急的
SELECT t1.[select], t1.name
FROM t1;
在access下面是好用的
在mysql下面表都没建立起来。
update aaa set "SELECT"=1;
是试试用别名
SELECT * FROM HISTORY A,NAME B WHERE A.**=……之类的
1. CREATE TABLE QQCALLCENTER."HUATEST" ("SELECT" CHAR(10) NOT NULL, "UPDATE" CHAR(10) NOT NULL, "INTO" CHAR(10) NOT NULL, "WHERE" CHAR(10) NOT NULL) ;2. CREATE VIEW vhuatest (a1,a2,a3,a4) AS select "SELECT","UPDATE","INTO","WHERE" from huatest3. select a1,a2,a3,a4 from vhuatest where A4 = 'd';
"SELECT" OK