Way to get fillable fields from a specific table

By -

SELECT CONCAT("'",COLUMN_NAME,"',")

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'undp_liupcp_survey'

ORDER BY ORDINAL_POSITION ASC; 

Comments

Post a Comment

Popular posts from this blog

Git post receive setup at server for git push to the production from local machine

By -
IN SERVER cd www mkdir repo cd repo mkdir app.website.git cd app.website.git git init –bare cd hooks touch post-receive chmod R 775 post-receive put the following line in post-receive file git --work-tree=/var/www/html/app.website.com --git-dir=/var/www/repo/app.website.git checkout master -f cd /var/www/html/app.website.com nano /etc/hosts 127.0.1.1 app.website.com cd /etc /apach2 /site-available cp 000-deault.conf app.website.com.conf LOCALLY git remote -v git remote add prod-website ssh://root@192.168.0.1:/var/www/repo/app.website.git
Read more

Deploy laravel application to digital ocean droplet

By -
ssh root@192.168.0.1 adduser coderstation usermod -aG sudo coderstation su - coderstation sudo apt-get install apache2 sudo apt-get install php sudo apt-get install git sudo apt-get install composer sudo apt install mysql-server sudo mysql mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; mysql> exit mysql -u root -p mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket; sudo mysql_secure_installation mysql>CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password'; mysql>ALTER USER 'sammy'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; mysql>GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'sammy'@'localhost' WITH GRANT OPTION; mysql>FLUSH PRIVILEGES; mysql> exit cd /var/www/htm git clone project cd project sudo apt-get install php-xml sudo apt-get install
Read more