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, address_id, email, store_id, username, password, active) 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, 1 AS active FROM customer WHERE first_name = 'COLLEEN' AND last_name = 'BURTON' LIMIT 1; ; select staff_id, first_name, last_name, address_id, email, store_id, active, username, password from staff order by staff_id;