Wednesday, March 23, 2022

Select data from csv file to SQLITE database

 drop table if exists <table name>;

create table <table name> (field1 datatype, field2 datatype ....);
.separator ","
.import <csv file name> <table name>
https://heads.dyne.org/

loadcsvtosqlite.cs

Process proc = new Process {
    StartInfo = new ProcessStartInfo {
        FileName = @"loadcsvtosqlite.bat",
        Arguments = @"",
        UseShellExecute = true,
        RedirectStandardOutput = false,
        CreateNoWindow = true
    }
};
proc.Start();
proc.WaitForExit();

loadcsvtosqlite.bat

sqlite3.exe "db name" < loadcsv.sql

loadcsv.sql

drop table if exists <table name>;
create table <table name> (field1 datatype, field2 datatype ....);
.separator ","
.import <csv file name> <table name>
https://stackoverflow.com/questions/2689098/how-to-bulk-insert-a-csv-file-into-sqlite-c-sharp
https://www.howtogeek.com/785314/whats-new-in-gnome-42/
https://www.howtogeek.com/247380/how-to-fix-windows-update-when-it-gets-stuck/
  1. Try running the Windows Update Troubleshooter, which you can search for in the Start menu.
  2. If that doesn’t help, you can try deleting Windows Update’s cache by booting into Safe Mode, stopping the wuauserv service, and deleting the files in C:WindowsSoftwareDistribution.
  3. If all else fails, download updates manually using the WSUS Offline Update tool.
https://tanzucommunityedition.io/download/
https://www.vmware.com/cloud-solutions/app-modernization.html

No comments:

Post a Comment

Beogradsko programiranje=