New answers tagged

0

There seems to be an anomaly or bug when a timestamp column has a default value of CURRENT_TIMESTAMP() - with the parenthesis. 5.7 documentation says it is synonymous with CURRENT_TIMESTAMP but workbench must disagree - sort of. Changing the definition in workbench by removing the parenthesis provides a message that nothing changed. However changing to ...


1

Seems you've found a bug in migration wizard, I follow your description and I was able to repeat issue on my machine. Can you please fill bug report at bugs.mysql.com? Appreciate. We'll do our best to fix that isse. As workaround you can try this way - use Data Export to export only structure of your database. Run exported stricpt on target server. Then run ...


0

You could try using sed and substitute | (the pipe character - not normally found in data dumps) for the " (double quote) character sed -i 's/"/|/g' My_File.csv sed -i does an inline replace - take a backup before messing with your original file. If you're on Windows - as you appear to be, you can get sed functionality from the answer here or use the ...


1

In addition to what Rick wrote: If you just wanna have an ad hoc solution (not something you frequently use) you could also just have your query in the editor without a schema and sequentially make each of the schemas you want to process the default schema by double clicking on it's name in the schema tree. I.e. make first one default, run the query. Make ...


0

Plan A: Write a "Stored Procedure". Pass in the database name. Inside the SP, use CONCAT to build the SELECT, PREPARE, EXECUTE to run the SELECT, and DEALLOCATE to clean up. Plan B: USE MySchema; SELECT * from mytable;



Top 50 recent answers are included