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 students( id int, name varchar(255), village varchar(255) ); insert into students(id,name,village)values(1,'Naga','Boyapalem'),(2,'Vijay','Ysrcolony'),(3,'Rajesh','Gambheeram'); select*from students; alter table students add column emailid varchar(50); select*from students; update students set emailid='Naga@email.com' where name='Naga'; update students set emailid='Vijay@email.com' where name='Vijay'; update students set emailid='Rajesh@email.com' where name='Rajesh'; select*from students; select name,emailid from students where emailid like '%@email.com';

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

Copy Clear