Saturday, 15 September 2012

database - Mysql column count doesn't match value count fix for unattended -


I have to load the load of files in a database, the problem occurs, over time it gets more columns < / P>

The files are all inserted from SQLite, but I need them in MySQL, SQLIte does not provide column-names in their SQL files, so MySQL scripts are more or less columns when accidents like in the Insertion Statement

Is this the solution? Maybe there is more than one?

The newly added columns are in the end, so it always happens first. There is a possibility to insert the SQL-file in the temporary table, then to join the empty table (or 1 ghost record) to get the correct amount of columns, and then insert a table on each row from that table. Want data in?

Looks like files:

  Table values ​​in INSERT (1,1, text, 2913, textile,);  

And if the column was added then the table value (1,1, text, 2913, textile, plus-text) in INSERT like file

  ;  


No comments:

Post a Comment