SQLize Online / PHPize Online  /  SQLtest Online

Share      Blog   Popular
Copy Format Clear
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, store_id, active) SELECT first_name, last_name, address_id, email, store_id, active FROM customer WHERE first_name = "Colleen" AND last_name = "Burton")
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear