SQLTeam.com | Weblogs | Forums

Auto generate email sql

so i have this homework where i need to generate an "email" or simply conact from first and last name of my "user" table to a new "email" table
and i just dont know how to make it work.
db name= test
table=user
table=email
heres my query. what am i supposed to do next?

create database test
use test
create table user
( userid int not null primary key auto_increment,
username varchar (50) not null,
userlastn varchar (50) not null)

create table email