Questions tagged as 'mysql-workbench'

Tagged questions
0
answers

MYSQL 5.6 does not recognize the query as it should

Greetings! I'm building a query to take every moment the value was at 0 on a given day and the highest time of the day before. The data in my database is similar to the one I put in SQL Fiddle . Time_Stamp and Value column. So far, I have...
asked by 07.12.2018 / 18:54
1
answer

Build SQL to generate a dataset and populate a Treeview

I'm having a database here and I'm looking to set up a SQL to generate a dataset in Delphi and then populate a Treeview. The figure below shows part of the bank, but that is the general structure of it: Basicallytheuserlogsintothesystem(tbuse...
asked by 23.06.2015 / 14:45
1
answer

Type of relationships 1: 1

Because when I was to redo the relationships in my table 1: 1 I get two types in WorkBench 1: 1 --------- 1.1_ _ __ (With the dash in the middle but the straight line) What's the difference from one to the other?     
asked by 12.02.2014 / 11:55
3
answers

MySQL 6.1 Workbench CE does not start any more

I do not know if anyone here uses it, I tried to use it for the first time, downloaded it, installed it and used it the first time in a good way, I found it cool, I created a database, I shut down the PC and the next day it did not start at al...
asked by 25.07.2014 / 17:39
3
answers

How to find relationship and cardinality in MySQL?

The image below shows a relationship between two tables created from the MySQL Workbench. What I need to know is how I can find this information inside the database. I need to know exactly what type of cardinality (1: 1 or 1: n). I've a...
asked by 29.09.2015 / 00:21
3
answers

Generate Excel with query php

I need some help. I have a query in php and mysql and I would like to add to this query the option to export the data also to excel. Is it possible to do this with php? <div id="tabs"> <ul> <li><a href="#tabs-1">Inf...
asked by 26.05.2014 / 18:20
3
answers

MySQL Workbench - Create Database based on EER Model (Forward Enginner Options)

Doubt: In WorkBench I created the table in EER Diagram and now I want to connect to Hostname 127.0.0.1. The path I make is Forward Engineer - > Next - > and then I have a number of options, do I have to select...
asked by 25.02.2014 / 11:08
1
answer

Connect MySQL Workbench to Hostinger Server

Several times I tried to connect the MySQL Workbench to the database of my hosted site hostinger.com.br > but it always gives error. As I understand the access data I am passing are valid, why are the same used to connect the application...
asked by 15.06.2015 / 13:10
1
answer

How to download a DB from the console?

I need to download a database on my machine, but it can not handle the MySQL Workbench. Is there a program lighter than the Workbench or what commands do I need to download the DB that I want?     
asked by 29.10.2014 / 17:53
1
answer

What is the difference between the relationship with "identification" and "non-identification" relationship (Mysql Workbench)

I've been learning Database for some time and I do not know the difference. I would very much like to know. On the internet I even found answers, but they are not very enlightening.     
asked by 02.05.2015 / 17:56