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 cofee_store( id int primary key, product_id int,coustomer_id int, product_time datetime); Alter table cofee_store Add column cofee_orgin varchar(20); describe cofee_store; Alter table cofee_store drop column cofee_orgin; drop table cofee_store; describe cofee_store; create table test(Id int auto_increment primary key,name varchar(20),age int ); insert into test (id,name,age) values(1,'alphin',22),(2,'aliwin',22),(3,'Ashwin',22); select * from test; describe test; -- truncate table test; -- select * from test; alter table test change column name first_name varchar(25); describe test;

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

Copy Clear