Linux Usage Summary

Scp-r-P 22/srv/ox/demo [email protected]:/home/ps/Local demo directory file upload to PS

Cp-r/home/ps/demo srv/ox/copy function

New file:Touch setenv.sh

New folder:mkdir setenv

Unzip the file to /usr/local

2, in the /usr/local file directory unzip Apache-tomcat-9.0.2-windows-x86.zip

/usr/local

Rename : Command mvapache-tomcat-9.0.2 tomcat9 change apache-tomcat-9.0.2 name to tomcat9

chmod 777/usr/local/tomcat9/bin/catalina.sh Permissions operation

Delete command Rm-rf app.txt  

Execute commands directly nano/usr/local/tomcat9/bin/phty.txt Edit View file contents

The statements written today:

Delete

Delete from table where id=1;

Update:

Two table UPDATE statements:
Update Product_template t0 set name= (select Name_template from product_product where product_tmpl_id=t0.id);

Update Product_template t0 set bm= (select Name_template from product_product where product_tmpl_id=t0.id limit 1), name= (select Name_template from product_product where product_tmpl_id=t0.id limit 1);

Linux Usage Summary