Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
#create csv file wget "https://randomuser.me/api/?results=100&format=csv" -qO /tmp/peoplecsv/people.csv #create database sqlite3 people.sqlite #set mode and import CSV - note that first line will be field names .mode csv .import people.csv people #check things where imported correctly PRAGMA table_info(people); select * from people; #######Export to CSV###### #export single table sqlite3 -header -csv people.sqlite "select * from people;" > output.csv #if you have more than one table, you can select which table you want with fzf table="$(sqlite3 people.sqlite ".tables"|tr " " "\n"|sort -u|fzf)" sqlite3 -header -csv people.sqlite "select * from $table;"
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
