插入记录 [英] Inserting the records

问题描述

我的桌子上有10个字段，但是我想为第一个进程插入oly 5个字段，第二个进程需要插入8个字段..这样做.. < br $>


谢谢和问候

MGBalamurugan

Hi,
I'm having 10 fields in my table but i want to insert oly 5 fields for first process and 8 fields should insert for second process..hw to do this..

Thanks and Regards
M.G.Balamurugan

推荐答案

大量的sql参考资料谷歌的sql插入语句，像这样



（ http： //www.w3schools.com/sql/sql_insert.asp [ ^ ]



所以你需要

plenty of sql references on google for the sql insert statement, like this

(http://www.w3schools.com/sql/sql_insert.asp[^]

So you need

insert into table (field1, field2, field3, field4, field5) values(value1, value2, value3, value4, value5);

或< br $>

or

insert into table (field1, field2, field3, field4, field5) select (a,b,c,d,e) from table2 where ....

（显然这是第一种情况）.. field1..field5只是你的字段希望数据插入

(this is for the first case obviously) .. field1..field5 are only the fields that you want data inserted into

这篇关于插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！