blocks|key|814257|text|嗯，如果它是一个CSV，这是一个一次性的过程，在Excel中打开文件，然后编写公式，以任何您想要的方式填充数据，然后编写一个简单的Concat公式来构造您的SQL，然后为每一行复制该公式。您将获得大量SQL语句，您可以在任何地方执行这些语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|814258|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Well, if it's a CSV, and it this is a one time process, open up the file in Excel, and then write formulas to populate your data in any way you desire, and then write a simple Concat formula to construct your SQL, and then copy that formula for every row. You will get a large number of SQL statements which you can execute anywhere you want.

blocks|key|94050|text|这有点粗糙--但对于一次性的工作，我有时使用Excel。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|94051|如果将CSV文件导入Excel，则可以在公式中使用字符串连接创建创建INSERT语句的公式。因此-如果CSV文件中有3列出现在Excel中的A、B和C列中，则可以编写如下公式.|94052|="INSERT+INTO+MyTable+(Col1,+Col2,+Col3)+VALUES+("+&+A1+&+",+"+&+B1+&+",+"+&+C1+&+")"|code-block|syntax|javascript|94053|然后，您可以将公式复制到所有行中，然后复制，并将答案粘贴到文本文件中，以便在数据库中运行。|94054|就像我说的--这是很粗糙的--但这可能是一种“快速而肮脏”的方式来完成一项工作！|94055|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

It's a bit crude - but for one off jobs, I sometimes use Excel.

If you import the CSV file into Excel, you can create a formula which creates an INSERT statement by using string concatenation in the formula. So - if your CSV file has 3 columns that appear in columns A, B, and C in Excel, you could write a formula like...

<pre><code>="INSERT INTO MyTable (Col1, Col2, Col3) VALUES (" &amp; A1 &amp; ", " &amp; B1 &amp; ", " &amp; C1 &amp; ")"
</code></pre>

Then you can replicate the formula down all of your rows, and copy, and paste the answer into a text file to run against your database.

Like I say - it's crude - but it can be quite a 'quick and dirty' way of getting a job done!

blocks|key|814295|text|您可以按原样将CSV文件导入数据库表，然后运行SQL查询，对导入的表执行所有必需的转换，并将结果插入目标表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|814296|假设CSV文件被导入到temp_table中，其中列为n，city_name|offset|length|style|CODE|814297|+insert+into+target_table
+select+t.n,+c.city_id+as+city+
+from+temp_table+t,+cities+c
+where+t.city_name+=+c.city_name|code-block|syntax|javascript|814298|关于使用Excel的好建议，但我也建议使用Python这样的脚本语言，因为对于某些任务，只编写一个快速的python脚本来完成这项工作要比在Excel或预先制作的工具中找到所需的函数要容易得多。|814299|entityMap^0|0|B|A|R|1|T|9|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|P|$]]

You could import the CSV file into a database table as is, then run an SQL query that does all the required transformations on the imported table and inserts the result into the target table.
Assuming the CSV file is imported into <code>temp_table</code> with columns <code>n</code>, <code>city_name</code>:
<pre><code> insert into target_table
 select t.n, c.city_id as city 
 from temp_table t, cities c
 where t.city_name = c.city_name
</code></pre>
Nice tip about using Excel, but I also suggest getting comfortable with a scripting language like Python, because for some tasks it's easier to just write a quick python script to do the job than trying to find the function you need in Excel or a pre-made tool that does the job.

blocks|key|814315|text|法比奥|type|unstyled|depth|inlineStyleRanges|entityRanges|data|814316|我已经做了Vaibhav做了很多次，这是一种很好的“快速和肮脏”的方式来将数据输入数据库。|814317|如果您需要这样做几次，或者按照某种类型的日程安排，那么更可靠的方法是将CSV数据"as-+is“加载到工作表(即customer_dataload)中，然后使用标准的SQL语句填充缺少的字段。|814318|(我不知道Firebird语法-但类似于.)|814319|UPDATE+person
SET+id+=+(SELECT+newguid()+FROM+createguid)

UPDATE+person
SET+cityid+=+(SELECT+cityid+FROM+cities+WHERE+person.cityname+=+cities.cityname)|code-block|syntax|javascript|814320|等。|814321|通常，将数据输入数据库然后修复数据比在上传过程中修复数据要快得多(而且更可靠)。您还可以从事务中获得好处，以便在不工作的情况下可以回滚！！|814322|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Fabio,

I've done what Vaibhav has done many times, and it's a good "quick and dirty" way to get data into a database.

If you need to do this a few times, or on some type of schedule, then a more reliable way is to load the CSV data "as-is" into a work table (i.e customer_dataload) and then use standard SQL statements to populate the missing fields.

(I don't know Firebird syntax - but something like...)

<pre><code>UPDATE person
SET id = (SELECT newguid() FROM createguid)

UPDATE person
SET cityid = (SELECT cityid FROM cities WHERE person.cityname = cities.cityname)
</code></pre>

etc.

Usually, it's much faster (and more reliable) to get the data INTO the database and then fix the data than to try to fix the data during the upload. You also get the benefit of transactions to allow you to ROLLBACK if it does not work!!

blocks|key|94178|text|我会和awk一起这么做。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|94179|例如，如果您在CSV文件中包含了这些信息：|94180|Bob,New+York
Jane,San+Francisco
Steven,Boston
Marie,Los+Angeles|code-block|syntax|javascript|94181|下面的命令将为您提供您想要的，在与您的CSV文件相同的目录中运行(在本例中名为name-city.csv+)。|style|CODE|94182|$+awk+-F,+'{+print+"INSERT+INTO+PERSON+(ID,+NAME,+CITY_ID)+VALUES+((SELECT+NEW_GUID+FROM+CREATE_GUID),+'\''"$1"'\'',+(SELECT+CITY_ID+FROM+CITY+WHERE+NAME+=+'\''"$2"'\''))"+}'+name-city.csv|94183|键入awk+--help以获取更多信息。|94184|entityMap|0|LINK|mutability|MUTABLE|url|http://www.grymoire.com/Unix/Awk.html^0|3|3|0|0|0|0|13|D|0|0|2|A|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|15|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|16|8|@$A|17|B|18|M|N]]|9|@]|C|$]]|$1|O|3|P|5|H|7|19|8|@]|9|@]|C|$I|J]]|$1|Q|3|R|5|6|7|1A|8|@$A|1B|B|1C|M|N]]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

I'd do this with <a href="http://www.grymoire.com/Unix/Awk.html" rel="noreferrer">awk</a>.

For example, if you had this information in a CSV file:

<pre><code>Bob,New York
Jane,San Francisco
Steven,Boston
Marie,Los Angeles
</code></pre>

The following command will give you what you want, run in the same directory as your CSV file (named <code>name-city.csv</code> in this example).

<pre><code>$ awk -F, '{ print "INSERT INTO PERSON (ID, NAME, CITY_ID) VALUES ((SELECT NEW_GUID FROM CREATE_GUID), '\''"$1"'\'', (SELECT CITY_ID FROM CITY WHERE NAME = '\''"$2"'\''))" }' name-city.csv
</code></pre>

Type <code>awk --help</code> for more information.

blocks|key|1093864|text|我最近尝试过的一个非常成功的工具是FSQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1093865|编写导入命令，将其粘贴到FSQL中，然后将CSV文件导入Firebird表。|style|CODE|1093866|entityMap|0|LINK|mutability|MUTABLE|url|http://www.volny.cz/iprenosil/interbase/fsql.htm^0|H|4|0|0|C|4|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@$A|U|B|V|F|G]]|9|@]|C|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

A tool I recently tried that worked outstandingly well is <a href="http://www.volny.cz/iprenosil/interbase/fsql.htm" rel="nofollow noreferrer">FSQL</a>.

You write an IMPORT command, paste it into <code>FSQL</code> and it imports the CSV file into the Firebird table.

blocks|key|94249|text|刚刚完成了这个VBA脚本，这个脚本对这个目的来说可能很方便。所需要做的就是更改Insert语句，以包括所讨论的表和列列表(很明显，它们显示在Excel文件中的顺序相同)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|94250|Function+CreateInsertStatement()
++++'Output+file+location+and+start+of+the+insert+statement
++++SQLScript+=+"C:\Inserts.sql"
++++cStart+=+"Insert+Into+Holidays+(HOLIDAY_ID,+NAT_HOLDAY_DESC,+NAT_HOLDAY_DTE)+Values+("

++++'Open+file+for+output
++++Open+SQLScript+For+Output+As+#1

++++Dim+LoopThruRows+As+Boolean
++++Dim+LoopThruCols+As+Boolean


++++nCommit+=+1+'Commit+Count
++++nCommitCount+=+100+'The+number+of+rows+after+which+a+commit+is+performed

++++LoopThruRows+=+True
++++nRow+=+1+'Current+row

++++While+LoopThruRows

++++++++nRow+=+nRow+%2B+1+'Start+at+second+row+-+presuming+there+are+headers
++++++++nCol+=+1+'Reset+the+columns
++++++++If+Cells(nRow,+nCol).Value+=+Empty+Then
++++++++++++Print+#1,+"Commit;"
++++++++++++LoopThruRows+=+False
++++++++Else
++++++++++++If+nCommit+=+nCommitCount+Then
++++++++++++++++Print+#1,+"Commit;"
++++++++++++++++nCommit+=+1
++++++++++++Else
++++++++++++++++nCommit+=+nCommit+%2B+1
++++++++++++End+If

++++++++++++cLine+=+cStart
++++++++++++LoopThruCols+=+True

++++++++++++While+LoopThruCols
++++++++++++++++If+Cells(nRow,+nCol).Value+=+Empty+Then
++++++++++++++++++++cLine+=+cLine+&+");"++++++++++++++++++++'Close+the+SQL+statement
++++++++++++++++++++Print+#1,+cLine+++++++++++++++++++++++++'Write+the+line
++++++++++++++++++++LoopThruCols+=+False++++++++++++++++++++'Exit+the+cols+loop
++++++++++++++++Else
++++++++++++++++++++If+nCol+>+1+Then++++++++++++++++++++++++'add+a+preceeding+comma+for+all+bar+the+first+column
++++++++++++++++++++++++cLine+=+cLine+&+",+"
++++++++++++++++++++End+If
++++++++++++++++++++If+Right(Left(Cells(nRow,+nCol).Value,+3),+1)+=+"/"+Then+'Format+for+dates
++++++++++++++++++++++++cLine+=+cLine+&+"TO_DATE('"+&+Cells(nRow,+nCol).Value+&+"',+'dd/mm/yyyy')"
++++++++++++++++++++ElseIf+IsNumeric(Left(Cells(nRow,+nCol).Value,+1))+Then+'Format+for+numbers
++++++++++++++++++++++++cLine+=+cLine+&+Cells(nRow,+nCol).Value
++++++++++++++++++++Else+'Format+for+text,+including+apostrophes
++++++++++++++++++++++++cLine+=+cLine+&+"'"+&+Replace(Cells(nRow,+nCol).Value,+"'",+"''")+&+"'"
++++++++++++++++++++End+If

++++++++++++++++++++nCol+=+nCol+%2B+1
++++++++++++++++End+If
++++++++++++Wend
++++++++End+If
++++Wend

++++Close+#1

End+Function|code-block|syntax|javascript|94251|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Just finished this VBA script which might be handy for this purpose. All should need to do is change the Insert statement to include the table in question and the list of columns (obviously in the same sequence they appear on the Excel file).

<pre><code>Function CreateInsertStatement()
 'Output file location and start of the insert statement
 SQLScript = "C:\Inserts.sql"
 cStart = "Insert Into Holidays (HOLIDAY_ID, NAT_HOLDAY_DESC, NAT_HOLDAY_DTE) Values ("

 'Open file for output
 Open SQLScript For Output As #1

 Dim LoopThruRows As Boolean
 Dim LoopThruCols As Boolean


 nCommit = 1 'Commit Count
 nCommitCount = 100 'The number of rows after which a commit is performed

 LoopThruRows = True
 nRow = 1 'Current row

 While LoopThruRows

 nRow = nRow + 1 'Start at second row - presuming there are headers
 nCol = 1 'Reset the columns
 If Cells(nRow, nCol).Value = Empty Then
 Print #1, "Commit;"
 LoopThruRows = False
 Else
 If nCommit = nCommitCount Then
 Print #1, "Commit;"
 nCommit = 1
 Else
 nCommit = nCommit + 1
 End If

 cLine = cStart
 LoopThruCols = True

 While LoopThruCols
 If Cells(nRow, nCol).Value = Empty Then
 cLine = cLine &amp; ");" 'Close the SQL statement
 Print #1, cLine 'Write the line
 LoopThruCols = False 'Exit the cols loop
 Else
 If nCol &gt; 1 Then 'add a preceeding comma for all bar the first column
 cLine = cLine &amp; ", "
 End If
 If Right(Left(Cells(nRow, nCol).Value, 3), 1) = "/" Then 'Format for dates
 cLine = cLine &amp; "TO_DATE('" &amp; Cells(nRow, nCol).Value &amp; "', 'dd/mm/yyyy')"
 ElseIf IsNumeric(Left(Cells(nRow, nCol).Value, 1)) Then 'Format for numbers
 cLine = cLine &amp; Cells(nRow, nCol).Value
 Else 'Format for text, including apostrophes
 cLine = cLine &amp; "'" &amp; Replace(Cells(nRow, nCol).Value, "'", "''") &amp; "'"
 End If

 nCol = nCol + 1
 End If
 Wend
 End If
 Wend

 Close #1

End Function
</code></pre>

blocks|key|810124|text|选项1:+1-你试过IBExert了吗？IBExpert+\+Tools+\+Import+(试用版或客户版)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|810125|选项2:+2-将csv文件上传到带有F_BLOBLOAD的临时表中。3-创建一个存储过程，它使用3个函数(f_stringlength、f_strcopy、f_MID)交叉所有字符串，拉出字段来构建插入。|810126|链接:+2：file.html+3：string.html|offset|length|810127|entityMap|0|LINK|mutability|MUTABLE|url|http://freeadhocudf.org/documentation_english/dok_eng_file.html|1|http://freeadhocudf.org/documentation_english/dok_eng_string.html^0|0|0|6|9|0|I|B|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$F|U|G|V|1|W]|$F|X|G|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

option 1:
1- have you tried IBExert? IBExpert \ Tools \ Import Data (Trial or Customer Version).

option 2:
2- upload your csv file to a temporary table with F_BLOBLOAD.
3- create a stored procedure, which used 3 functions (f_stringlength, f_strcopy, f_MID)
you cross all your string, pulling your fields to build your INSERT INTO.

links:
2: <a href="http://freeadhocudf.org/documentation_english/dok_eng_file.html" rel="nofollow">http://freeadhocudf.org/documentation_english/dok_eng_file.html</a>
3: <a href="http://freeadhocudf.org/documentation_english/dok_eng_string.html" rel="nofollow">http://freeadhocudf.org/documentation_english/dok_eng_string.html</a>

blocks|key|1093966|text|使用csv-文件作为外部表。然后，您可以使用SQL将数据从外部表复制到目标表--其中包含了SQL的所有可能性。请参阅http://www.firebirdsql.org/index.php?op=useful&id=netzka|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1093967|entityMap|0|LINK|mutability|MUTABLE|url|http://www.firebirdsql.org/index.php?op=useful&id=netzka^0|1M|1K|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

use the csv-file as an external table. Then you can use SQL to copy the data from the external table to your destination table - with all the possibilities of SQL.
See <a href="http://www.firebirdsql.org/index.php?op=useful&amp;id=netzka" rel="nofollow">http://www.firebirdsql.org/index.php?op=useful&amp;id=netzka</a>

blocks|key|94381|text|您可以使用免费的csvsql来完成这个任务。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|94382|安装它使用这些指令|unordered-list-item|94383|现在，运行类似这样的命令，将数据导入数据库。在上面的链接上有更多的细节，但是应该是这样的：
csvsql+--db+firebase:///d=mydb+--insert+mydata.csv|style|CODE|94384|以下内容与sqlite一起工作，是我用来将数据转换成一种易于查询的格式的工具
csvsql+--db+sqlite:///dump.db+--insert+mydata.csv|94385|entityMap|0|LINK|mutability|MUTABLE|url|http://csvkit.readthedocs.io/en/0.4.4/scripts/csvsql.html|1|http://csvkit.readthedocs.io/en/0.9.1/index.html^0|8|6|0|0|3|6|1|0|1A|1E|0|13|1D|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|G|3|H|5|F|7|14|8|@$A|15|B|16|I|J]]|9|@]|C|$]]|$1|K|3|L|5|F|7|17|8|@$A|18|B|19|I|J]]|9|@]|C|$]]|$1|M|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

You can use the free <a href="http://csvkit.readthedocs.io/en/0.4.4/scripts/csvsql.html" rel="nofollow noreferrer">csvsql</a> to do this. 

<ul>
<li>Install it <a href="http://csvkit.readthedocs.io/en/0.9.1/index.html" rel="nofollow noreferrer">using these instructions</a></li>
<li>Now run a command like so to import your data into your database. More details at the links above, but it'd be something like:

<code>csvsql --db firebase:///d=mydb --insert mydata.csv</code></li>
<li>The following works with sqlite, and is what I use to convert data into an easy to query format

<code>csvsql --db sqlite:///dump.db --insert mydata.csv</code></li>
</ul>

blocks|key|94405|text|您可以使用shell|type|unstyled|depth|inlineStyleRanges|entityRanges|data|94406|sed+"s/,/','/g"+file.csv+>+tmp
sed+"s/$/'),(/g"+tmp+>+tmp2
sed+"s/%5E./'&/g"+tmp2+>+insert.sql|code-block|syntax|javascript|94407|然后添加|94408|INSERT+INTO+PERSON+(ID,+NAME,+CITY_ID)+VALUES(
...
);|94409|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

you can use shell

<pre><code>sed "s/,/','/g" file.csv &gt; tmp
sed "s/$/'),(/g" tmp &gt; tmp2
sed "s/^./'&amp;/g" tmp2 &gt; insert.sql
</code></pre>

and then add 

<pre><code>INSERT INTO PERSON (ID, NAME, CITY_ID) VALUES(
...
);
</code></pre>

blocks|key|94438|text|两个在线工具，帮助我在2020|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|94439|https://numidian.io/convert/csv/to/sql|94440|https://www.convertcsv.com/csv-to-sql.htm|94441|第二个是基于JS的，没有上传你的数据(至少在我写这篇文章的时候不是这样)。|94442|entityMap|0|LINK|mutability|MUTABLE|url|1^0|B|4|0|0|12|0|0|0|15|1|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|H|3|I|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|J|3|K|5|6|7|14|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|G]]|S|$5|O|P|Q|E|$R|I]]]]

Two online tools which helped me in 2020:
<a href="https://numidian.io/convert/csv/to/sql" rel="nofollow noreferrer">https://numidian.io/convert/csv/to/sql</a>
<a href="https://www.convertcsv.com/csv-to-sql.htm" rel="nofollow noreferrer">https://www.convertcsv.com/csv-to-sql.htm</a>
The second one is based on JS and does not upload your data (at least not at the time I am writing this)

I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools and none fit my needs.

The main problem is that all the tools I've been trying like <a href="http://www.sqlmanager.net/products/ibfb/dataimport" rel="noreferrer">EMS Data Import</a> and <a href="http://www.sqlmaestro.com/products/firebird/datawizard/help/06_01_05_csv/" rel="noreferrer">Firebird Data Wizard</a> expect that my CSV file contains all the information needed by my Table.

I need to write some custom SQL in the insert statement, for example, I have a CSV file with the city name, but as my database already has all the cities in another table (normalized), I need to write a subselect in the insert statement to lookup for the city and write its ID, also I have a stored procedure to cread GUIDS.

My insert statement would be something like this:

<pre><code>INSERT INTO PERSON (ID, NAME, CITY_ID) VALUES((SELECT NEW_GUID FROM CREATE_GUID), :NAME, (SELECT CITY_ID FROM CITY WHERE NAME = :CITY_NAME)
</code></pre>

How can I approach this?

Generate insert SQL statements from a CSV file

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要将csv文件导入到Firebird中，我花了几个小时尝试了一些工具，但没有一个适合我的需求。主要的问题是，我尝试过的所有工具，比如和，都希望我的CSV文件包含表所需的所有信息。我需要在insert语句中写入一些自定义SQL，例如，我有一个带有城市名称的CSV文件，但是由于我的数据库已经在另一个表中包含了所有的城市...

问从CSV文件生成insert SQL语句
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从CSV文件生成insert SQL语句EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从CSV文件生成insert SQL语句
EN