delete file or folder based on date on linux CLI
danang setya pramanaList directories before delete find . -type d -ctime +60 -ls List files before delete find . -type f -ctime +60 -ls Delete directories in current directory find . -type…
import large sql dump file to Mysql Database from CLI
mysql.exe -u root set global net_buffer_length=1000000; set global max_allowed_packet=1000000000; SET foreign_key_checks = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; source /home/user/dbdump150113.sql after restore remember to return default setting…
adb cli command
== Adb Server adb kill-server adb start-server == Adb Reboot adb reboot adb reboot recovery adb reboot-bootloader == Shell adb shell // Open or run commands in a terminal on…
Rest CLIENT Ext VS Code for Upload SIngle File & Multiple File
### For Single File POST http://localhost:8080/upload Content-Type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW ------WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="file"; filename="file.jpeg" Content-Type: image/jpeg < C:/Users/user/Pictures/file.jpeg ------WebKitFormBoundary7MA4YWxkTrZu0gW-- ### For Multiple FIle POST http://localhost:8080/upload Content-Type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW ------WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition:…
drop field column table mysql query
ALTER TABLE table_name DROP COLUMN column_name;
error plist undefine in nextron when build production
just try to use this npm install @types/node --save-dev
generate prisma client using custom schema
npx prisma generate --schema .\prisma\schema.prisma
add table in existing table mysql
ALTER table_name ADD nama_field type_field; DONE
change column type mysql
ALTER TABLE table_name MODIFY field DATATYPE; ALTER TABLE table_name ALTER field SET DEFAULT CURRENT_TIMESTAMP();
Create Table From Select Query MySql
CREATE TABLE new_tbl SELECT * FROM orig_tbl;