Questions tagged as 'mysql-workbench'

Tagged questions
0
answers

Query sql with reserved word in column name [duplicate]

     This question already has an answer here:                   A MySQL query with 'ciphers' vs without                                      2 answers                                                 Mysql reserved keywords        ...
asked by 22.06.2018 / 22:07
0
answers

MySQL-workbench giving dump error

I'm working with MySQL-workbench, but when I go to give a dump (import / export), He gives a mistake, looks at the image below, knows how to solve?        
asked by 09.06.2018 / 06:24
0
answers

Error executing MySQL trigger - RESULT SQLSTATE

I made a trigger in mysql to save a query to a table that is executed whenever there is an update or it in the provider table. On my computer, localhost with xampp, it works normal, that is, every time I update or delete a record in the table...
asked by 24.05.2018 / 05:01
0
answers

Connections in MYSQL Workbench

Good evening, could anyone give an explanation of the difference of a dotted and continuous relationship in MYSQL Workbench? Is the following activity correct? Ready activity: Activitystatement:     
asked by 18.06.2018 / 04:24
0
answers

MySQL workbrench

Do not continue, to 99%. How do I continue the installation?     
asked by 07.04.2018 / 02:17
0
answers

mysql php workbench Character Encoding

I have php system 5.4 and mysql configured in the default charset (not in UTF8) the tables are configured as UTF-8. When saved to the database and displayed on the system the information appears accented correctly. However when I open the...
asked by 22.03.2018 / 16:27
1
answer

How do I configure a MySQL database that is on my machine to be accessed in moodle hosted on the web?

I hired hosting services from Uol Host, however I can not change the database provided by them. I would like to know how do I connect a database from my machine to moodle that is installed on the host. In the moodle installation this appears....
asked by 09.03.2018 / 22:09
0
answers

ERROR 1442 - Trigger AFTER INSERT - MySql

My database has the following structure: CREATE TABLE BAIRRO ( BAI_COD INT(4) AUTO_INCREMENT NOT NULL, BAI_NOME VARCHAR(200)NOT NULL, CONSTRAINT PK_BAIRRO PRIMARY KEY(BAI_COD) ); CREATE TABLE PAGAMENTO ( PAG_COD INT(2) AUTO_INCREMEN...
asked by 19.02.2018 / 01:24
1
answer

Specialization multiple foreign key

Hello, I am modeling a database and I came across the following problem: I have a table called time, which is a generalization for 4 specialized tables, where each one will contain a different id, to know which team belongs each player. Next imag...
asked by 13.02.2018 / 06:08
0
answers

INSERT IF NOT SQL (PROCEDURE)

I need to create a SQL procedure that does what's down here! -- procura cadastro SELECT id_cadastro FROM c1datasource.tb_cadastro where cpf_cnpj = '12344'; -- se não achou, insere INSERT INTO 'c1datasource'.'tb_cadastro' ('nome', 'cep', 'cpf_...
asked by 01.02.2018 / 15:26