mysql往多个表中插数据库_MySQL插入多个表？(数据库规范化？)

如果使用存储过程，则相当简单：

call insert_user_and_profile('f00','http://www.f00.com');

完整脚本：

drop table if exists users;

create table users

(

user_id int unsigned not null auto_increment primary key,

username varchar(32) unique not null

)

engine=innodb;

drop table if exists user_profile;

create table user_profile

(

profile_id int unsigned not null auto_increment primary key,

user_id int unsigned not null,

homepage varchar(255) not null,

key (user_id)

)

engine=innodb;

drop procedure if exists insert_user_and_profile;

delimiter #

create procedure insert_user_and_profile

(

in p_username varchar(32),

in p_homepage varchar(255)

)

begin

declare v_user_id int unsigned default 0;

insert into users (username) values (p_username);

set v_user_id = last_insert_id(); -- save the newly created user_id

insert into user_profile (user_id, homepage) values (v_user_id, p_homepage);

end#

delimiter ;

call insert_user_and_profile('f00','http://www.f00.com');

select * from users;

select * from user_profile;