I had a trigger set in MySQL workbench that used to accomplish what I wanted. Recently, my workplace updated MySQL workbench to version 6.3.10 across all computers and the triggers were dropped during …
Tag: mysql-workbench
ST_Distance_Sphere in mysql not giving accurate distance between two locations
My requirement is to calculate the distance between two locations on a given map using mysql. I found a function in mysql named ST_Distance_Sphere which returns the minimum spherical distance between two locations and/or multi locations on a sphere in meters. When I computed the distance between two locations using ST_Distance_Sphere and the lat_lng_distance function , I found that the
No error message displayed on MYSQL Workbench latest version
I am running the latest version of MYSQL Workbench on a clean ubuntu 14.04 install, using the ubuntu package version. When I run a valid query, it works fine, e.g.: select * from users; At the …
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