SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table A(empid int, employeename varchar(100), managerid int,dateofjoining date, city varchar(100)); create table B(empid int, project varchar(100),salary decimal,Variablepay decimal); insert into A Values(1,'abc',11,'09/02/2022','bng'); insert into A Values(2,'XYZ',22,'08/02/2022','HYD'); select * from A; create table su1(id int,Name varchar(20), salary decimal); insert into su1 values(1,'peeru', 2000); insert into su1 values(2, 'gani', 3000); insert into su1 values (3,'ram',4000); select*from su1; rename table su1 to su2; rename su1tosu2;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear