Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Mysqli_error () expects parameter 1 to be mysqli, null given

I'm trying to show some data in my browser from the database and when I run it it shows me the following error: mysqli_error () expects parameter 1 to be mysqli, null given I would appreciate some help. Code: <!doctype html>...
asked by 15.06.2018 / 16:10
1
answer

Problem with my database

I am trying to create a database for a school project and I get the following error: (errno: 150 "Foreign key constraint is incorrectly formed") Please help, the code is as follows: CREATE SCHEMA IF NOT EXISTS 'bibliotecaFastDev' DEFAULT...
asked by 26.05.2018 / 08:33
1
answer

Select between several tables MYSQL WORKBENCH

How about, My question is, I have several tables, which I show below where I highlight the relevant data for the query. I want to ask a question, where do I get the number of students per semester of each Program. Something like this...
asked by 24.05.2018 / 02:52
1
answer

MySQL subConsulta

How about, I have a query which works well. SELECT PAPA.idPAPA AS PAPA, HIJO.idHIJO AS HIJO, NIETO.idNIETO AS NIETO, BISNIETO.idBISNIETO AS BISNIETO FROM PAPA LEFT JOIN HIJO ON HIJO.PreH=PAPA.idPAPA LEFT JOIN NIETO ON NIETO.PreN=HIJO.idHIJO...
asked by 25.05.2018 / 00:58
1
answer

AND query, OR in MYQL

How about, good afternoon. I have a database with 4 tables that are linearly related. To which I enter data that depend on different precedents. I have the following diagram which I enter into the base. In it you can see that the letter "I...
asked by 15.03.2018 / 22:28
1
answer

Create tablespace in Mysql

Greetings I would like to know how to create a tablespace and a table that stores your data in the newly created tablespace     
asked by 28.11.2017 / 04:52
1
answer

Save image in blob or by route? [closed]

What would be most appropriate and a good practice to save images in database By route or within the manager as data     
asked by 25.10.2017 / 13:23
1
answer

Optimize Mysql Database?

I have a TABLE called "Data" which I filled with information brought from a CSV file (Generated from a third-party system). the database has multiple columns with Codes that are not numeric. This is just a small example Table Data Easil...
asked by 24.08.2017 / 06:33
1
answer

Connection error Mysql C #

At the moment of executing a select to connect to a Mysql database I get the warning of Mysql connection can not be open the code fragment I use is the following: private string mensaje; private string usuario; private string c...
asked by 21.08.2017 / 23:48
1
answer

Connect MySQL Workbench with an instance of mysql in Google Compute Engine

I have a Google Compute Engine instance in which I create an instance of mysql. I would like to know how I can connect to this instance from MySQL Workbench?     
asked by 27.06.2017 / 03:10