filmov
tv
MySQL 8 - How do I create Spatial Tables with the Workbench

Показать описание
Hello to everyone,
Two years ago, I have published a video about how to create a SPATIAL TABLE, using the version 5.7, of MySQL. I decided to update that explanation to the version 8.x, because there is a “little” big difference among the two versions, on the way how to do this task.
So, this means that a user can create a SPATIAL TABLE with the MySQL, version 8.x, that can be used inside the QGIS. The task is relatively simple and similar as creating a shapefile layer with QGIS. So, this task will not be unfamiliar to a QGIS user.
Just to remind, the SPATIAL TABLES are based on the shapefiles' characteristics, where each shapefile only allows the storage of one of the three types of geometries: polygons, lines, or points.
Because the procedures are similar, and the difference are only in the moment when I choose the geometry type of the table, in this video I will only demonstrate how to create a SPATIAL TABLE to store POLYGONS.
Let's see, step by step, how to accomplish the task.
Software used to build this video:
Cartographic base used in this exercise:
Two years ago, I have published a video about how to create a SPATIAL TABLE, using the version 5.7, of MySQL. I decided to update that explanation to the version 8.x, because there is a “little” big difference among the two versions, on the way how to do this task.
So, this means that a user can create a SPATIAL TABLE with the MySQL, version 8.x, that can be used inside the QGIS. The task is relatively simple and similar as creating a shapefile layer with QGIS. So, this task will not be unfamiliar to a QGIS user.
Just to remind, the SPATIAL TABLES are based on the shapefiles' characteristics, where each shapefile only allows the storage of one of the three types of geometries: polygons, lines, or points.
Because the procedures are similar, and the difference are only in the moment when I choose the geometry type of the table, in this video I will only demonstrate how to create a SPATIAL TABLE to store POLYGONS.
Let's see, step by step, how to accomplish the task.
Software used to build this video:
Cartographic base used in this exercise:
How to install MySQL 8.0.40 Server and Workbench latest version on Windows 11
MySQL - The Basics // Learn SQL in 23 Easy Steps
How to install MySQL 8.0.40 Server and Workbench latest version on Windows 10
Installing MySQL and Creating Databases | MySQL for Beginners
How to Set Up MySQL 8 Multi-Master Group Replication on Ubuntu 22.04
How to install MySQL 8.0.35 Server and Workbench latest version on Windows 10
How To Install MySQL (Server and Workbench)
MySQL: JOINS are easy (INNER, LEFT, RIGHT)
Configure Database Connection in laravel12 | Laravel 12 Database Migration | laravel 12 tutorial #2
MySQL Workbench Tutorial
MySQL Upgrade from MySQL 5.7 to MySQL 8 using YUM repository | Tutorial 8
How to install MySQL 8.0.41 Server and Workbench latest version on Windows 11
Learn What's New in MySQL 8.0.23
How to Check and Upgrade Your MySQL Version Easily
Upgrading to MySQL 8 0 Michael Coburn at Percona
Create database using MYSQL Workbench
How to Install MySQL? | MySQL Installation Tutorial
MySQL 8 - Instalando e Configurando | #01
Connecting to MySQL Database from Visual Studio Code | Step-by-Step Guide
JSON Data Improvements in MySQL 8.0
MySQL Full Course for free 🐬
Get Together MySQL 8 0 New Features
Setup Environment Variable for MySQL 8 Database in windows 10 & Windows 11
MySQL 8 at Booking.com
Комментарии