Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
CREATE TABLE IF NOT EXISTS CUSTOMERS( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25), SALARY DECIMAL (18, 2), PRIMARY KEY (ID) ); ALTER TABLE CUSTOMERS ADD COLUMN EMAIL VARCHAR(50); ALTER TABLE CUSTOMERS CHANGE COLUMN ADDRESS LOCATION CHAR(25); ALTER TABLE CUSTOMERS DROP COLUMN LOCATION; TRUNCATE TABLE CUSTOMERS; DROP TABLE IF EXISTS CUSTOMERS;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear