<p>(Off the top of my head on the phone)<br>
"ALTER TABLE DROP COLUMN..."?</p>
<div class="gmail_quote">On Nov 3, 2012 5:24 AM, "Erez D" <<a href="mailto:erez0001@gmail.com">erez0001@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">hello,<div><br></div><div>i am downgrading mythtv. to keep my data, i need to import my recording table</div><div>however in the older version the table has less columns</div><div>i have a mysqldump of the wider table and need to insert into older version with narrower table.</div>
<div><br></div><div>i thought about using awk to delete the non relevant fields. however there are man "," inside strings, so splitting fields by "," is not simple</div><div><br></div><div><br></div><div>
any simple idea ? some sql magic ?</div><div><br></div><div>thanks,</div><div>erez.</div></div>
<br>_______________________________________________<br>
Linux-il mailing list<br>
<a href="mailto:Linux-il@cs.huji.ac.il">Linux-il@cs.huji.ac.il</a><br>
<a href="http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il" target="_blank">http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il</a><br>
<br></blockquote></div>