trdsql
Verified for current stable LTS
Trdsql Command: Create Mysql Table From Csv
Use for create mysql table from csv with Trdsql. Exact CLI syntax to create mysql table from csv using Trdsql.
When to use this: Use for create mysql table from csv with Trdsql.
Command Syntax
trdsql -driver mysql -dsn "<username>:<password>@<hostname>/<database>" -ih "CREATE TABLE <table> (<column1> int, <column2> varchar(20)) AS SELECT <column3> AS <column1>,<column2> FROM <path/to/header_file.csv>"trdsql -driver mysql -dsn "<username>:<password>@<hostname>/<database>" -ih "CREATE TABLE <table> (<column1> int, <column2> varchar(20)) AS SELECT <column3> AS <column1>,<column2> FROM <path/to/header_file.csv>"Live Command Builder
Final Command
trdsql -driver mysql -dsn "<username>:<password>@<hostname>/<database>" -ih "CREATE TABLE <table> (<column1> int, <column2> varchar(20)) AS SELECT <column3> AS <column1>,<column2> FROM <path/to/header_file.csv>" Command Breakdown
-driver- Command Option
- Tool-specific option used by this command invocation.
-dsn- Command Option
- Tool-specific option used by this command invocation.
-ih- Command Option
- Tool-specific option used by this command invocation.
FAQ
Purpose: Exact syntax to create mysql table from csv using Trdsql.
Test path: Replace placeholders and run destructive commands in a disposable workspace first.
Flag behavior: Tool version, platform, and shell can change behavior.
Improve This Command
Suggest a correction, safer default, or version-specific note for this entry.
Related Operations
Trdsql Command: Connect To Postgresql Database
trdsql -driver postgres -dsn "host=<hostname> port=<5433> dbname=<database_name>" "SELECT 1" Trdsql Command: Convert Json To Csv With Header Quote trdsql -ocsv -oh "SELECT * FROM <path/to/directory/*.json>" | sed 's/\([^,]*\)/"&"/g' > <path/to/file.csv> Trdsql Command: Interpret Json List As Table trdsql "SELECT * FROM <path/to/file.json>::.list" Trdsql Command: Manipulate Sql Query Multiple Csv trdsql -icsv -ih "SELECT <column1,column2> FROM <path/to/file*.csv> WHERE column2 != '' ORDER BY <column1> GROUP BY <column1>" Trdsql Command: Merge Two Csv Files trdsql "SELECT <column1,column2> FROM <path/to/file1.csv> UNION SELECT <column1,column2> FROM <path/to/file2.csv>"