The INSERT INTO SELECT statement selects data from one table and inserts it into an existing table. Any existing rows in the target table are unaffected. SQL INSERT Syntax The syntax for the SQL INSERT statement when inserting a record using the another table. INSERT INTO table (column1, column2, ... ) SELECT expression1, expression2, ... FROM source_table WHERE conditions; SQL INSERT INTO SELECT Examples Copy only a few columns from another table...... INSERT INTO suppliers (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE city = 'Newark';
Here is the Source code: cls @ECHO OFF title Folder Sumon if EXIST "HTG Locker" goto UNLOCK if NOT EXIST Sumon goto MDLOCKER :CONFIRM echo Are you sure you want to lock the folder(Y/N) set/p "cho=>" if %cho%==Y goto LOCK if %cho%==y goto LOCK if %cho%==n goto END if %cho%==N goto END echo Invalid choice. goto CONFIRM :LOCK ren Sumon "HTG Locker" attrib +h +s "HTG Locker" echo Folder locked goto End :UNLOCK echo Enter password to unlock folder set/p "pass=>" if NOT %pass%== sumon goto FAIL attrib -h -s "HTG Locker" ren "HTG Locker" Sumon echo Folder Unlocked successfully goto End :FAIL echo Invalid password goto end :MDLOCKER md Sumon echo Sumon created successfully goto End :End
মন্তব্যসমূহ
একটি মন্তব্য পোস্ট করুন