Shulou(Shulou.com)06/01 Report--

How to quickly start contact with TIDB, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Start operation today, operation TIDB. Some people ask, I do not know how to build the environment, how to learn, in fact, TIDB has already prepared an environment for you to use at the first time, as long as you can surf the Internet, have a computer, and have a WEB browser.

First sign up for an account, then log in to the following URL

Https://tour.pingcap.com/

On the left side of the page is the introduction of related operations, and on the right side of the page is a way that tidb-wasm can operate on TIDB through the web page.

You can start typing commands on the left in the shell-like interface on the right side of the page, which is the latest version of TIDB's operating environment.

Now you can start to get in touch with TIDB quickly and set up a database

Create database if not exists Austin

What I am familiar with is that this is the syntax of MYSQL, but what I am not familiar with is that I can start to operate the way to contact TIDB on the WEB page.

In the operation, first of all, TIDB should be case-insensitive human setting, which is also in line with the operating habits of MYSQL.

Basically, the table under construction and some routine operations with the table are no different from MYSQL.

There is no difference between the operation of index and familiar MYSQL.

Some data and indexes are created to see the execution plan of the query statement through a simple query.

Taking a look at the way and explanation of TIDB's EXPLAIN, this can be explained in detail, but in fact, from the generation and presentation of the principle and content, it requires detailed understanding and understanding (not a traditional database, but a distributed database, which is extracted after breaking up the data).

In terms of user creation, version 4.0 has been consistent with the way and method of MYSQL 8 to create users, and the MYSQL 5.7 mode of direct grant cannot be used above.

Compared with other databases, TIDB is friendly to beginners in addition to this understanding, and the means to operate directly on the WEB page can not be provided by other databases at present, so it is very easy to release TIDB quickly, and you can also view some of the structure and contents of TIDB's system table directly through the interface, not done here.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.