Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Is it possible to change the theme or colors of the Workbench?

I would like to leave the black background to tire less the vision. Thank you in advance!     
asked by 31.10.2017 / 02:45
2
answers

Decreasing the value of two fields of a table and sorting according to the result

I have the field "killed" and "died" in the table, I need to make the order of the results come according to the decrease of these two values, My query looks like this: $woes = DB::table('woeplayerrank as woe') ->join('char', 'woe...
asked by 23.10.2017 / 21:20
1
answer

psqlodbca.so: Unable to open file of shared objects: File or directory not found

I can not migrate the PostegreSql database to mysql because of this error:    psqlodbca.so: Unable to open shared object file:   File or directory not found I'm using ubuntu 64 Postgresql 9x and workbench 6.x, how should I proceed?...
asked by 23.10.2017 / 14:44
1
answer

How to join with multiple tables?

I have 4 tables they already have foreign key. aluno: id matricula username curso_id // referencia a id_cursos da tabela cursos, coluna id_cursos. cursos: id_cursos nome_cursos modulos: id_modulos nome_modulos cursos_id...
asked by 04.11.2017 / 18:49
2
answers

Configure Mysql Workbench in docker

I want to set up my workbench so you can connect with mysql that is running on my docker server but when I try to test the connection, always get the following error: IcreatedtheMysqlcontainerusingdocker-compose.Hereistheconfigurationofmydocker...
asked by 05.06.2017 / 03:50
1
answer

Select with max (date), penultima (date)

I have a table with product code and date of sale. I would like to make a select picking the product code, the date of the last sale and the date of the next-to-last sale with group by code. Is it possible? select p.codigo, max(date_format(p...
asked by 13.01.2017 / 14:21
1
answer

Get database dates, and "Highlight" them in a Jquery Calendar

I have a code with two dates that will mark something, such as a one week event for example, one is the start date of the event and the other the closing date of that event, to make it easier to view the user I want I put these two dates in a ca...
asked by 09.06.2016 / 13:59
1
answer

Check start and end date and insert text between them!

Good morning, I have a "ready" code where the user must register an event that will later be shown in a calendar, well the first part is ready and the second is giving me problems, I would like to do a check of the start date and end date and en...
asked by 16.06.2016 / 14:53
1
answer

MySQL GROUP BY - Error in PHP

I have a query in MySQL that, in the command line and in MySQL Workbench, is bringing the correct values, but when executed in PHP, the GROUP BY function is grouping more than it should! Here is the query: SELECT DATE_FORMAT(ctg.d...
asked by 25.02.2016 / 19:17
1
answer

Mysql workbench - Create or Change an event

In this program we have the options to create within a schema: Tables Views Store Procedures Functions All in an interactive way, but I did not find the option to create EVENTS , Does this option exist somewhere, maybe a plugi...
asked by 04.08.2015 / 21:28