SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Employees ( id_no INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE Departments ( department_id INT AUTO_INCREMENT PRIMARY KEY, department_name VARCHAR(100) ); CREATE TABLE Salaries ( salary_id INT AUTO_INCREMENT PRIMARY KEY, amount DECIMAL(10, 2) ); CREATE TABLE Projects ( project_id INT AUTO_INCREMENT PRIMARY KEY, project_name VARCHAR(100) ); -- Step 3: Insert test data for updates (since id_no = 1 must exist) INSERT INTO Employees (name) VALUES ('John Doe'); -- Add a record -- Step 4: Display all tables -- Online compilers may require querying the `information_schema` SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database_name'; -- Step 5: Add an email column to the Employees table ALTER TABLE Employees ADD COLUMN email VARCHAR(255); -- Step 6: Update id_no 1 to "Karen Nina" UPDATE Employees SET name = 'Karen Nina' WHERE id_no = 1; -- Step 7: Display the updated Employees table SELECT * FROM Employees;