Software Developer

The command is as follows: :) ALTER TABLE tablename UPDATE column_name = column expresion1 WHERE  expression; Example: :) ALTER TABLE tablename UPDATE time = time / 100 WHERE id = 0;

Open .py file with vim I got error message as following: " YCM error. The ycmd server SHUT DOWN (restart wit...the instructions in the documentation) " Solution: 1. Install cmake # pkg install cmake 2. Compile $ cd /home/j/.vim/bundle/YouCompleteMe $ python3 install.py

Install # pkg install v2ray Configuration Set v2ray system startup. Add content as following below to /etc/rc.conf # sysrc v2ray_enable=yes set v2ray's config.json of client. {   "log": {     "access": "",     "error": "",     "loglevel": "warning"   },   "inbounds": [     {       "tag": "socks",       "port": 10808, // port of client for socks       "listen": "127.0.0.1",       "protocol": "socks",       "sniffing": {         "enabled": true,         "destOverride": [           "http",           "tls"         ],         "routeOnly": false       },       "settings": {         "auth": "noauth",         "udp": true,         "allowTransparent": false       }     },     {       "tag": "http",       "port&q

 Solution: $ mkdir ~/.vim/autoload $ cp ~/.vim/bundle/vim-colors-solarized/autoload/togglebg.vim ~/.vim/autoload

Solution: $ mkdir ~/.vim/colors $ cp ~/.vim/bundle/Zenburn/colors/zenburn.vim ~/.vim/colors/   

Install VIM # pkg install vim VIM Extensions The first thing you need is a good extension manager. Vundle VIM has serveral extension managers, but I strongly recommend Vundle . Let's get Vundle installed: $ git clone https://github.com/gmarik/Vundle.vim.git ~/.vim/bundle/Vundle.vim This command downloads the Vundle plugin manager and chucks it in your VIM bundles directory. Now you  can manage all your extensions from the .vimrc configuration file . $ touch ~/.vimrc Now set up Vundle in your .vimrc by adding the following to the top of the file: set nocompatible              " required filetype off                  " required " set the runtime path to include Vundle and initialize set rtp+=~/.vim/bundle/Vundle.vim call vundle#begin() " alternatively, pass a path where Vundle should install plugins "call vundle#begin('~/some/path/here') " let Vundle manage Vundle, required Plugin 'gmarik/Vundle.vim' " add all your plugins here (no