OneCompiler

Basic table-MySQL

173

CREATE TABLE employee(
id INTEGER PRIMARY KEY ,
name TEXT NOT NULL,
email TEXT NOT NULL
);

INSERT INTO employee VALUES(101,'MEGHA','mohite@123');
INSERT INTO employee VALUES(102,'nmu','nmu@123');
INSERT INTO employee VALUES(103,'pranali','sanu@123');

UPDATE employee
SET id=104
WHERE id=101;

select*FROM employee;