AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Firebird constraint limit3/10/2023 chunk - size CHUNK_SIZE Chunk size for batch insert into the table. I, - no - inference Disable type inference when parsing the input. y SNIFF_LIMIT, - snifflimit SNIFF_LIMIT Limit CSV dialect sniffing to the specified number of bytes. db - schema DB_SCHEMA Optional name of database schema to create table ( s ) in. overwrite Drop the table if it already exists. create - if - not - exists Create the table if it does not exist, otherwise keep going. unique - constraint UNIQUE_CONSTRAINT A column - separated list of names of columns to include in a UNIQUE constraint. no - 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
Read More
Leave a Reply. |