How do I install Python?

In my previous post you have seen how to download mssql-cli. Installing mssql-cli requires a Python command-line tool for managing Python packages.

In this post you will learn downloading and installing Python that will enable to use PIP.

You download Python from here:

https://www.python.org/downloads.

This site has a vast number of downloads not only for Windows but also for other platforms. For Windows 10 there are a number of them.

I installed the following:

python-3.7.0b2-webinstall

Python_00.png

Double click the dwonloaded file to begin installation.

Python_0

Python_2

You get these files into your computer:

Python_4

The PIP tool is in the Scripts directory in the above.

On a Windows 10 computer the following are installed in the All Programs

Python_6

You can get help on PIP as shown here by launching Python 3.7 from the above shortcut and when you are in the Python (>>>) use HELP:

Python_5

Where do you find the latest command-line query tool mssql-cli?

The public preview was announced in December last year. Now there is an update.

Read here.

You can download mssql-cli from here:

Using mssql-cli you get to do all this:

    T-SQL IntelliSense

    Syntax highlighting

    Pretty formatting for query results, including Vertical Format

    Multi-line edit mode

    Configuration file support

You can install mssql-cli if you have Python on your computer. For Windows you can install Python from here and make sure it is added to your PATH.

https://www.python.org/downloads/