Want to import data from CSV file to PostgreSQL via command line on Windows? Using pg-cmd, you can import data from CSV file to PostgreSQL easily and fast, no need to program. Here you can download pg-cmd Windows version. No need to install PostgreSQL client library. Convenient to deploy to ... Read more
Tag Archives: command line
Import data from CSV to MySQL via command line on macos
Want to import data from CSV file to MySQL via command line on MacOS? Using my-cmd, you can import data from CSV file to MySQL (MariaDB, Percona) easily and fast, no need to program. Here you can download my-cmd MacOS version. No need to install MySQL client library. Convenient to deploy to ... Read more
Import data from CSV to MySQL via command line on linux
Want to import data from CSV file to MySQL via command line on Linux (Ubuntu/RedHat/CentOS…)? Using my-cmd, you can import data from CSV file to MySQL (MariaDB, Percona) easily and fast, no need to program. Here you can download my-cmd Linux version. No need to install MySQL client ... Read more
Import data from CSV to MySQL via command line on windows
Want to import data from CSV file to MySQL via command line on Windows? Using my-cmd, you can import data from CSV file to MySQL (MariaDB, Percona) easily and fast, no need to program. Here you can download my-cmd Windows version. No need to install MySQL client library. Convenient to deploy ... Read more
How to execute sql file via command line for PostgreSQL
Use psql psql -U username -d myDataBase -a -f myInsertFile More information: http://blog.manoharbhattarai.com.np/2013/04/03/execute-sql-file-from-command-line-in-postgresql/ ... Read more
How to execute sql file via command line for Oracle
Use sql*plus run SQL file sqlplus username/password@databasename @/path/to/test.sql If you want to see whats going on like this, including any error messages, you need connect to SQL*Plus with sqlplus username/password@databasename Then run the script from the SQL*Plus prompt: set echo ... Read more
How to execute sql file via command line for DB2
You can save a .sql file to your hard drive, and execute it using the DB2 command line using: db2 -vtf C:\path\to\test.sql -v echoes the command text back to the command line -t sets the statement terminator to ;. -f tells the command line to load the commands from the file. See other command ... Read more
How to execute sql file at SQL Server command line
You can use sqlcmd to run a Transact-SQL script file. A Transact-SQL script file is a text file that can contain a combination of Transact-SQL statements, sqlcmdcommands, and scripting variables. To run the script file 1.Open a command prompt window. 2.In the Command Prompt window, ... Read more
How to execute sql file at MySQL command line
If you’re at the MySQL command line mysql> you can declare the SQL file as source, like: mysql> source 'path/to/test.sql'; Or use the MySQL command line client: mysql -hhostname -uuser database < path/to/test.sql ... Read more
Import data to Oracle
OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Import Oracle data from file(csv, txt). Import Oracle data to ... Read more