Click here to Skip to main content
14,643,391 members
Rate this:
Please Sign up or sign in to vote.
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100