SQL for beginners: CREATE TABLE statement

preview_player
Показать описание
In our previous videos, we looked at how to use the SELECT and INSERT statements in your SQL queries. Today we are going to tell you about CREATE TABLE statement, which will help you to add a new table to your database.
--
--
Contact us:

--
Subscribe to our channel to get more interesting videos about DBeaver and the database world!
Рекомендации по теме
Комментарии
Автор

I have a query, how can we create temporary table and insert data

kiransingh
Автор

To create the DB table in PostgreSQL you can open the file createdb.sql using DBeaver, select the block CREATE TABLE …, and make right click and select run query. With the empty table created, refresh the tables, right click on the table, select import from CSV file, and follow the importing steps

AlvordCoKe
Автор

Hi your videos are great and really helpful ❤

kiransingh
Автор

Suppose I want to migrate my all the data from Dbeaver db to Sql database, and onceugratwd I need to validate all the data existing in Dbwaver Db should exist in Sql once data migrated, I should generate a report with the help oh Dbeaver script, can u pls provide a solution for this ...

kiransingh