Viewing in a text editor: $ cat csv_test. X INT NOT NULL, y DATE NOT NULL, z CHAR( 10) NOT NULL From MariaDB 10.1.8, it is possible to do so by setting the IETF_QUOTES option when creating a table.įorgetting to add NOT NULL: CREATE TABLE csv_test (x INT, y DATE, z CHAR( 10)) ENGINE =CSV ĮRROR 1178 ( 42000): The storage engine for the table doesn 't support nullable columnsĬreating, inserting and selecting: CREATE TABLE csv_test ( The LOADD DATA LOCAL INFILE command reads rows of data from a text file into a MariaDB t. User-friendly interface for data science. In this tutorial we will learn how to import a CSV file in MariaDB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |