Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

MySQL database doubts

In this database and I can not do it: I have this: value_id | entity_type_id | attribute_id | entity_id | value 600 | 2 | 22 | 40 | Gaga 601 | 2 | 20 | 40 | Tonha A...
asked by 14.12.2017 / 20:21
1
answer

Item composition of the same SQL table

Well, I started studying MySQL recently and I found a question I could not solve: An ITEM table has the columns (PK) cd_item, nm_item, ds_item, cd_type_item, the problem in the case is that an item can be formed by the composition of 2 or 3 item...
asked by 13.12.2017 / 04:31
1
answer

Android Application and MySQL Database

I have an application developed in Android and I need to connect to a MySQL database that is local to a Desktop. I can easily get the IP address of the machine where the bank is. How can I make the connection between the application and the loca...
asked by 06.12.2017 / 19:44
1
answer

Foreign key with more than 1 value

I'm working on building my CBT and I've had a problem. I have a schedule table, and this table needs to store some data, among them, the activities that will be passed during the year. Due to this, I created the activities table, but there arise...
asked by 19.11.2017 / 23:58
0
answers

Problem saving month - MySQL Workbench

Good afternoon, I am doing a project management project and I have in the registration form, two date fields, when I enter, when I consult the bank, the dates appear with the wrong month, all indicate month 1. This is the save button code:...
asked by 16.10.2017 / 20:07
0
answers

Export MySQL data to CSV file in UTF-8 format

I am using the Workbench tool to access data from my MySQL database, but when I try to export the returned data to a *. CSV file I am not able to export the same in the format > UTF-8 , but it is exported to any other file format (XML,...
asked by 03.10.2017 / 19:45
0
answers

Comparison with 3 tables

create table Pessoa ( id int not null primary key auto_increment, nome varchar(150) not null, cidade varchar(100) not null, cpf char(14) not null unique, rg int not null unique, INDEX idx_nome(nome) ); create table conta(...
asked by 20.09.2017 / 16:18
0
answers

XAMPP and Workbench problem

Does anyone have any problem when using the workbench to access a mysql XAMPP database? I'm having trouble with this, when trying to connect to the mysql XAMPP database the workbench issues an error sound, but does not display any messages an...
asked by 20.07.2017 / 21:07
1
answer

Access database through MySQL Workbench [duplicate]

I can not access a database through MySQl Workbench. The following message appears: However, with PHPMYADMIN, I can. How do I get access to the MySQL Workbench?     
asked by 21.07.2017 / 22:29
1
answer

Help with database schema

I'm developing an order tracking system, and I'm finishing, but now I came across a problem in the payments part schema: I'm linking id_pedido to payments, but when the request costs R$48,90 and the person pays R$50,00 , I...
asked by 04.07.2017 / 23:35