SQLize Online / PHPize Online  /  SQLtest Online

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;; insert into staff (first_name,last_name,address_id,email,store_id,username,password) select first_name , last_name , address_id , concat(first_name,'.',last_name,'@sakilastaff.com') as email , 2 as store_id , lower(first_name) as username , '8cb2237d0679ca88db6464eac60da96345513964' as password from customer where first_name ='COLLEEN' and last_name ='BURTON'