My Online Code Regerence

 Add new column of id : ALTER TABLE spam_alter_email  ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ; exporting large db with ternimal : mysqldump --max_allowed_packet=1024M -u root -p database > dumpfile.sql   /home/rajeshwar/Videos/Cluster_query/2023-10-06/Cluster_New_update     Gravtar logo : https://ui-avatars.com/api/?name=John+Doe&background=random  load data from file into database : LOAD DATA INFILE '/home/export_file.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '/n' IGNORE 1 ROWS; download large set of databse : mysqldump -h 127.0.0.1 -u root -p spam_alter > database-dump-alter.sql Note for all this : 1: we have to modify max_upload_file_size , memory_size in the php.ini file. 2:php.ini file lives under the composer folder and then php version folder.   plocation key : 2c0bc0ca84f049c9ac43848eb0189e30 URL : $ip = '8.8.8.8' 'https://api.ipgeolocation.io/ipgeo?apiKey=2c...

                           How an Angular App gets Loaded and   Started   To start an angular app , the app first executes the main.ts file  where it looks for the app.module and in the app module we have the bootstrap array that contains the AppComponent and the appComponent get executes with the html code it has.                                                   Creating a New Component To create a component :    1:     import Component from @anguler/core    2:     create the component imported as a method with @ in the beginning    3:     This component method takes an argument like : selector , template/templateUrl , style/styleUrl.    4: Finally export the c...