Is Video me kis tarah se temporary table ko upyog kiya jata hain uske bare me samjhaya hain
1. isme temporary table ko create karne ki tin tarike bataye hain
1.1 pahla tarika aap jaise table banante hain vaise hi banana hain keval create table ke bich me temporary likhna hain yani ki
CREATE TEMPORARY TABLE [Table Name] (Column Name ....)
1.2 Dusra tarika yah hain ki aap LIKE ka upyog kar structure ko copy kar sakte hain jaise ki
CREATE TEMPORARY TABLE [New Table] LIKE [Original Table]
1.3 Tisra tarika hota hain ki aap SELECT ka upyog kar data or structure dono hi copy kar skte ho
CREATE TEMPORARY TABLE [New Table] SELECT * FROM [Original Table]
#hindi #learnmysql #learnsql #mysql #selfimagination #temporary #table #dbms #dbmstutorials