1/1/2023 0 Comments How to install csvkitno - constraints Generate a schema without length limits or null checks. By default, the tables will be named after the filenames without extensions or "stdin". tables TABLE_NAMES A comma - separated list of names of tables to be created. after - insert AFTER_INSERT Execute SQL after the INSERT command. before - insert BEFORE_INSERT Execute SQL before the INSERT command. prefix PREFIX Add an expression following the INSERT keyword, like OR IGNORE or OR REPLACE. query QUERY Execute one or more SQL queries delimited by " " and output the result of the last query as CSV. db CONNECTION_STRING If present, a SQLAlchemy connection string to use to directly execute generated SQL on a database. Usage : csvsql [ - u Dialect of SQL to generate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |