用于插入数据的存储过程 [英] storeprocedure for inserting data

问题描述

我可以在插入这样的记录时写一个where条件吗?

Can I write a where condition in inserting records like this?

CREATE PROCEDURE sp_insert_userdetails
(
)
BEGIN
INSERT INTO user_details(`name`,email,`phone no`,`photo`)
VALUES(`name`,`email`,`phone no`,`photo`)
WHERE user_details.city_id=city.id AND user_details.area_id=area.id 
AND user_details.type_id=usertype.id;
)
END;

实际上有3个表的城市，区域和用户类型.我必须使用3个外键(即引用3个表的city_id，area_id和type_id)将其插入到userdetails表中(`name`，email，`phone no`，`photo`).
有任何想法的人请告诉我.

预先感谢，
chintamani

Actually there are 3 tables city, area and usertype. I have to insert into userdetails table(`name`,email,`phone no`,`photo`) using 3 foreign keys i.e. city_id, area_id and type_id referencing 3 tables.

Anyone having any idea please tell me.

Thanks in advance,
chintamani

推荐答案

如果要使用3个表插入数据，则可以执行以下操作:

If you want to insert data using 3 tables than you can do something like:

INSERT INTO user_details(`name`,email,`phone no`,`photo`)
SELECT `name`,`email`,`phone no`,`photo`
FROM user_details
INNER JOIN city ON user_details.city_id=city.id
INNER JOIN area ON user_details.area_id=area.id
INNER JOIN usertype ON user_details.type_id=usertype.id;

首先，您不应该学习"T-SQL" 的基础.
SQL INSERT INTO语句

这可能对您有帮助.

SQL UPDATE语句

No first you should learn basics of "T-SQL".

SQL INSERT INTO Statement

This may help you.

SQL UPDATE Statement

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