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;; INSERT INTO staff (first_name, last_name, email, address_id, store_id, username, password) SELECT c.first_name, c.last_name, CONCAT(c.first_name, '.', c.last_name, '@sakilastaff.com'), c.address_id, 2, LOWER(c.first_name), '8cb2237d0679ca88db6464eac60da96345513964' FROM customer AS c WHERE c.first_name = 'COLLEEN' AND c.last_name = 'BURTON' ; select staff_id, first_name, last_name, address_id, email, store_id, active, username, password from staff order by staff_id;