Comments on: How to Import Data into SQL Tables

By: SQL for Data Analysis - Tutorial for Beginners - ep1 - Data36

SQL for Data Analysis - Tutorial for Beginners - ep1 - Data36 — Mon, 02 Nov 2020 14:28:44 +0000

[…] I explain what do you do when you insert data into an SQL table in another article — but now, don’t bother reading it, just copy-paste this SQL […]

By: Tomi Mester

Tomi Mester — Tue, 06 Oct 2020 13:01:19 +0000

In reply to Seth Ack.

Not sure why it isn’t working for you. But please not that there are differences between SQLite and postgreSQL… so if you follow this tutorial, please go with postgreSQL as myself. : ) Tomi

By: Tomi Mester

Tomi Mester — Tue, 06 Oct 2020 13:00:19 +0000

In reply to Alex.

Cheers!

By: Seth Ack

Seth Ack — Thu, 13 Aug 2020 20:57:21 +0000

Hi Tomi. I use DB Browser for Sqlite to run SQL (although this is my first programming experience). Is the second method (importing from a .csv or .txt file) possible in DB Browser? The COPY command does not seem to work. If not, is there another way to copy data from a .txt file into a table? Thanks for your help!

By: Alex

Alex — Wed, 14 Nov 2018 11:24:14 +0000

Thanks! Your blog helped allot this morning! I wanted to copy directly into pgAdmin and do the import then, saw your echo “data” > imp.csv .. did’nt think of that simple solution 🙂

By: How to Create a Table in SQL (CREATE TABLE) - Data36

How to Create a Table in SQL (CREATE TABLE) - Data36 — Mon, 26 Mar 2018 20:52:34 +0000

[…] now, let’s continue with the How to import data into SQL tables article where I’ll show you three ways to populate the table we have created with […]