Questions tagged as 'mysql-workbench'

Tagged questions
0
answers

Does copied code from workbench not work for me on phpmyadmin?

I made a database in workbench and copied it: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_IN...
asked by 15.10.2017 / 21:12
2
answers

Problem retrieving datetime

I have a problem retrieving the dates in my Rest API. I insert a data and the datetime is automatically filled in my BD. for example. 2017-09-27T23:16:46.000Z this value that is generated automatically and I can see it with mysql wo...
asked by 28.09.2017 / 00:40
1
answer

MySQL Select Query

First of all good afternoon everyone. To the point !! I have a table called "control" in which I have registered the kilometers of several vehicles, all well at the time of inserting delete etc. But I am trying to bring the data of a veh...
asked by 28.09.2017 / 21:20
0
answers

Error Code: 1290. The MySQL server is running with the - secure-file-priv mysql workbench

Someone can help me with the error that appears in mysql , when loading a file .csv shows me error 1290    load data infile "C: \ Users \ USER \ Desktop \ Semester 9 2017_2 \ BI \ pec.csv" into table load_person   COLUMNS...
asked by 31.08.2017 / 17:57
1
answer

MySql authentication problem

It turns out that after I did all the steps to tell the database, add connections, until then everything went great, until when I finished adding my tables and their field, that I execute my program I get this. I made a button in my meno that al...
asked by 18.08.2017 / 14:42
0
answers

Indexes in Views

I have a database in MySQL with more than 50 tables and each one has its index, views, views of the views, stored procedures. My question is regarding the views, when creating a view with columns of a certain table and one of those columns th...
asked by 22.06.2017 / 21:30
1
answer

Error synchronizing model in mysql workbench

I want to synchronize my model in mysql workbench and I get this error:    Fetching table list.       0 items from dbEnter OK Fetching view list.       0 items from dbEnter OK Fetching routine list. Operation failed: Table 'proc' is ma...
asked by 20.06.2017 / 06:01
3
answers

Create tables from mysql queries

How could a table be created from several queries in mysql . I have the following questions: --selecciona tipo gasto sin repetir un registro --- SELECT DISTINCT tipo_gasto FROM factura' number of records of that variable SELECT...
asked by 15.06.2017 / 01:54
0
answers

Update mysql row at expiration date

It is possible to create a function on the server side of the mysql database that automatically updates a row when a date field expires in comparison with the current date.     
asked by 28.05.2017 / 19:58
0
answers

query distinct mysql

I have two tables: students (student_id, id_carrera, nro_doc ... rterc, eterc) PK (student_id, id_carrera). debts (rterc, eterc, date_of_voice, number_of_voice, amount, expiration ...) The table does not have debts. The field eterc is e...
asked by 18.04.2017 / 18:57