两条巧妙的SQL语句<script language="javascript" type="text/javascript"> document.title="两条巧妙的SQL语句 - "+document.title </script>
复制整张表,条件:a表和b表的数据结构是一样的.
insert into a select * from b
拷贝单条数据
insert into a (select '123' as id, temp,temp2 from b where id=10)