初学者,打算用存储过程实现同时给四个表格添加数据,其中一个为关联表,结构如下:
member
-----------------
MemberID Name
memb_add
--------------------------------------
MemberID AddressTypeID AddressID
address
-----------------
AddressID Address
addresstype
-----------------
AddressTypeID AddressType尝试着写了一个,保错提示MemberID 不能为空,希望高人给指点一下,多谢~PROCEDURE test.addMembAdd()
BEGIN
DECLARE name char(20);
DECLARE addresstype char(20);
DECLARE address char(20);set name='Aelx';
set addresstype='Home';
set address='22222222';INSERT INTO test.member(Name) VALUES (name);
select @memberID = @@IDENTITY;
INSERT INTO test.address(Address) VALUES (address);
select @addressID= @@IDENTITY;
select @addresstypeID = test.addresstype.AddressTypeID from test.addresstype where AddressType=addresstype;
INSERT INTO test.memb_add VALUES (@memberID,@addresstypeID,@addressID);END
member
-----------------
MemberID Name
memb_add
--------------------------------------
MemberID AddressTypeID AddressID
address
-----------------
AddressID Address
addresstype
-----------------
AddressTypeID AddressType尝试着写了一个,保错提示MemberID 不能为空,希望高人给指点一下,多谢~PROCEDURE test.addMembAdd()
BEGIN
DECLARE name char(20);
DECLARE addresstype char(20);
DECLARE address char(20);set name='Aelx';
set addresstype='Home';
set address='22222222';INSERT INTO test.member(Name) VALUES (name);
select @memberID = @@IDENTITY;
INSERT INTO test.address(Address) VALUES (address);
select @addressID= @@IDENTITY;
select @addresstypeID = test.addresstype.AddressTypeID from test.addresstype where AddressType=addresstype;
INSERT INTO test.memb_add VALUES (@memberID,@addresstypeID,@addressID);END
解决方案 »
- 请教一个关于复杂指标报表的Mysql数据库设计问题
- 求一条sql
- 几个小问题。
- mysql是5.0.45是否支持cluste是否是max版本)
- 我在mysql的某个中表中会不断插入连续的数据,但是由于出错的发生,导致一些数据没有插进去,现在想用一个sql语句来查查到底有哪些数据没插进去
- postgresql中 sql语句过长问题
- Access denied for user: 'meiya@localhost' to database 'meiya'
- (30)求救,mysql的卸载问题
- 我在windows98获2000里怎么访问postgres 数据库
- mssql怎么转化为mysql
- 请问如何 开启/察看 mysql日志
- mysql中系统找不到路径
改成 set @memberID = @@IDENTITY;或者我上面说的.