Click here to Skip to main content
15,886,069 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
While using MySQLbackup.NET temporary column is not exportable, it says tempcolumn not existed in the table name

Code reference:
DictionaryTables(" table_name") = String.Format("select *,'a' as temp from table_name

Error :
Column temp is not existed in table_name


What I have tried:

<pre>ExportInfo.ExportTableStructure = False
                        Mb.ExportInfo.ExportViews = True
Posted
Comments
Maciej Los 17-Jun-20 3:02am    
What?
Member 13294980 17-Jun-20 4:10am    
I need to export mysql tables and using mysqlbackup.net to do it , but if i add a temporary column through a select statement , there is an error while exporting and it says temp column not exists in the table
Member 13294980 17-Jun-20 8:49am    
yes , that's the question but no reply for that post yet..
CHill60 19-Jun-20 6:11am    
Firstly "Column temp is not existed in table_name" is not what the error says. Instead of trying to interpret error messages just give us the actual text. If that really is what the error says then you have captured an error in your code and are changing the message.
Sharing the actual code that is doing the export is also useful - you have only given us a snippet of the line that sets up a query in a dictionary.
Watch out in that dictionary - are those spaces meant to be in " table_name" - depending on how you are using the information that might very well be your problem

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900