Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

SQL query with two fields in PHP and MySQL

I have a small problem please if someone can help me = D, I will be very grateful. When looking for products for sale: just pull me to find a single name or field, I want to search for example "tablet asus" two fields. this is my code:...
asked by 14.01.2018 / 17:13
0
answers

A BD is created from a relational model?

We have a desktop application and we need to do the BD, in the many-to-many relationships that the diagram presents, according to the relational model, a new table must be made that includes the primary keys of the entities involved. When doing...
asked by 11.12.2017 / 18:39
1
answer

Performance and Tuning of MySQL View

, I need your help and knowledge to be able to improve this view that I present in MySQL. It's taking a long time and I want to reduce load times. I have little handling of Sql and T-Sql. Could you help me with the format of this view by apply...
asked by 05.12.2017 / 19:27
0
answers

InnoDB Error Code: 1215. Can not add foreign key constraint that I get on my client table can someone help me thanks

-- MySQL Script generated by MySQL Workbench -- Thu Nov 23 02:24:57 2017 -- Model: New Model Version: 1.0 -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KE...
asked by 23.11.2017 / 08:56
1
answer

MySQL Filter Expired Permissions

I have the following question: I have a table in mysql called drivers in which I keep your data including Date of Issued driver's license and Expiry date. What I need is to filter "Show" all those that are about to expire or have already expi...
asked by 15.11.2017 / 21:08
0
answers

Error: Microsoft Visual C ++ 10.0 is required (Unable to find vcvarsall.bat).

I've been trying to connect Python with MySQL and I could not connect, I'm using Python 3.4 and MySQL Workbench. I have already installed the Microsoft Visual C ++ 2010. If anyone knows, please help me.     
asked by 13.11.2017 / 22:36
0
answers

How to extract data from a MYSQL query in .csv

Good afternoon, I'm trying to get the data from a query to a .csv file and I can not get it to work. Here I put my code. Thanks SELECT CAST(avg(numero) as decimal(18,2)) as media FROM ( SELECT DATE(fecha_creacion) fecha_creacion, COUNT(*)...
asked by 26.10.2017 / 17:13
1
answer

sql-workbench find record that is not repeated in two tables

Good morning everyone ... Let's see who can help me with this simple query ... I have a database formula 1, in it there are two tables, one is cars and the other participation, the participation table has the key (codeCoche) foreign cars that pa...
asked by 01.11.2017 / 16:30
2
answers

MySQL-PHP - ID auto_increment does not increase by 1

My web application registers a user and saves it in the BD but the id's go 4-9-18-27-48-57-66-75. How do you make the auto increment to be 1? Why can this be happening? This is the function that inserts the new $ user in the table: * the func...
asked by 16.10.2017 / 21:11
0
answers

How to export workbench database to phpmyadmin?

Good morning I would like to know how to export a database of workbench to phpmyadmin. More specifically I want to export a database of three tables     
asked by 15.10.2017 / 20:24