add table in existing table mysql
danang setya pramanaALTER 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;
i have a trick for windows 11 easy way to run over php 8 script bat
here is the code bat @echo off cd C:\D\nginx-1.26.1 IF "%1" == "stop" ( GOTO STOPSERVER )else IF "%1" == "start" ( GOTO STARTSERVER )else ( echo…
create superuser role mongodb
db.createUser({ user:"danang", roles:, pwd:"powerr00t", })
simple run nginx over php 8
run php8 first php-cgi.exe -b 127.0.0.1:9999 config for nginx.conf http { include mime.types; default_type application/octet-stream; server { listen …
handle error db5 error(11) from dbenv->open yum update
Saat menjalankan perintah: Yum update -y pada server centos, kadang terjadi error dengan muncul pesan kurang lebih seperti ini: root@server: yum update -y error: db5 error(11) from dbenv->open: Resource temporarily…