create table test (name varchar(10)) insert test select 'before' union all select 'aa' select * from test update test set name='after' where name='before' select * from test drop table test ------------------- ame ---------- before aaname ---------- after aa
*****************************************************************************
欢迎使用CSDN论坛阅读器 : CSDN Reader(附全部源代码)
http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html
没权限的话那没办法查询出来的结果当然不能改,要改就要改数据库中的表
(name varchar(10))
insert test
select 'before' union all
select 'aa'
select * from test
update test set name='after' where name='before'
select * from test
drop table test
-------------------
ame
----------
before
aaname
----------
after
aa