Skip to content

Tag: mysql-workbench

ISDATE() equivalent for MySQL

I have a line of code for SQL server which takes a date listed as “YYYYMMDD” where the DD is 00 and converts the 00 to 01 so that it works with datetime. I would like to be able to use MySQL for it the current code which works for SQL server: but isdate is not valid in MySQL, what

file conversion- .mwb to .sql file

I have a database in .mwb format. I want to use it in eclipse so i need to convert it into .sql format. If anyone know how to do that by using any tool. I think My sql workbench can do that, but don’t know how to do that. Answer In the menu click “Database” and then “Forward engineering” (shortcut