SQLize | PHPize | SQLtest

create table address like sakila.address; insert into address select * from sakila.address; create table customer like sakila.customer; insert into customer select * from sakila.customer; create table staff like sakila.staff; insert into staff select * from sakila.staff;; set @first_name =(select first_name from customer where first_name='COLLEEN' and last_name='BURTON'); set @last_name =(select last_name from customer where first_name='COLLEEN' and last_name='BURTON'); set @address_id =(select address_id from customer where first_name='COLLEEN' and last_name='BURTON'); insert staff ( first_name , last_name ,address_id, email, store_id , username ,password ) values( @first_name, @last_name, @address_id, concat(@first_name,'.',@last_name,'@sakilastaff.com'), 2, lower(@first_name), '8cb2237d0679ca88db6464eac60da96345513964' ) ; select staff_id, first_name, last_name, address_id, email, store_id, active, username, password from staff order by staff_id;