insert into NEWTABLENAME (name,fathername) select name,fname from OLDTABLENAME
This Query user to copy data from one table to another, we can also use WHERE clause witth SELECT statement to verify data
Such as:
insert into NEWTABLENAME (name,fathername) select name,fname from OLDTABLENAME
Where name IS NOT NULL
This Query user to copy data from one table to another, we can also use WHERE clause witth SELECT statement to verify data
Such as:
insert into NEWTABLENAME (name,fathername) select name,fname from OLDTABLENAME
Where name IS NOT NULL
0 comments:
Post a Comment