http://www.cslt.org/mediawiki/index.php?action=history&feed=atom&title=Convert_sql_to_csv 2026-04-03T19:08:32Z 本wiki的该页面的版本历史 MediaWiki 1.23.3 http://www.cslt.org/mediawiki/index.php?title=Convert_sql_to_csv&diff=29831&oldid=prev 2018-02-03T11:41:07Z

<p>以“1. create database and load sql to it. a) create database &lt;database_name&gt; b) use &lt;database_name&gt; c) source &lt;xxx.sql&gt; 2. obtain the column names and save csv. a)...”为内容创建页面</p> <p><b>新页面</b></p><div>1. create database and load sql to it.<br /> a) create database &lt;database_name&gt;<br /> b) use &lt;database_name&gt;<br /> c) source &lt;xxx.sql&gt;<br /> <br /> 2. obtain the column names and save csv.<br /> a) select group_concat(concat(&quot;'&quot;,column_name,&quot;'&quot;)) from information_schema.columns where table_name = '&lt;table_name&gt;';<br /> b) select &lt;column_string&gt;<br /> union all <br /> select * from &lt;table_name&gt; into outfile '/var/lib/mysql-files/xxx.csv' <br /> fields terminated by ',' <br /> optionally enclosed by '&quot;' escaped by '\\' <br /> lines terminated by '\n';<br /> <br /> 3. replace \N with '' in csv.<br /> a) sed -i 's/\\N//g' xxx.csv</div>

Wangyang