After creating a local cluster for the TiDB database and visualizing the existing database via the show database command, I decided to create a database. And like many open-source databases, TiDB simplifies this activity by using a simple command as “create database.” Therefore, this post shows how quickly create a new database followed by the latest display of the existing databases:
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | INFORMATION_SCHEMA | | METRICS_SCHEMA | | PERFORMANCE_SCHEMA | | mysql | | test | +--------------------+ 5 rows in set (0.00 sec) mysql> CREATE DATABASE mynewdbtechdb; Query OK, 0 rows affected (0.18 sec) mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | INFORMATION_SCHEMA | | METRICS_SCHEMA | | PERFORMANCE_SCHEMA | | mynewdbtechdb | | mysql | | test | +--------------------+ 6 rows in set (0.00 sec)
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)