Questions tagged as 'mysql-workbench'

Tagged questions
1
answer

Why does the mysql Workbench always throw me an error when I synchronize tables?

With the latest version of mysql workbench, I have only problems. I create two tables, one using an n: n relation, I synchronize it and it always ends with the same message "ERROR: Error 1064: You have an error in your SQL syntax; check the manu...
asked by 24.10.2018 / 06:08
0
answers

Problem when running a stored procedure does not execute the change in c # mysql, mysql and workbench

Codigo ConexionBd.ConnectionString = ConecionMySql.CadenaBaseDatos(); Comando = new MySqlCommand("DeleteUser", ConexionBd); Comando.CommandType = CommandType.StoredProcedure; Comando.Parameters.AddWithValue...
asked by 23.10.2018 / 04:42
0
answers

Error with Local data infile MYSQL

I am trying to import data from a csv file into a mysql database by means of the following code LOAD DATA INFILE 'direccion del archivo' INTO TABLE nombre_tabla FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; But when I run it, I get the...
asked by 20.10.2018 / 12:21
0
answers

BackUp Templates in Workbench

My question is how can I support the templates that I generate in the MySQL Workbench (Modeling Aditions), in case they format my PC, how can I do this operation?     
asked by 11.10.2018 / 00:05
0
answers

how to update the database from an .xlsx file with JSP and MySQL?

The problem is that I am working with JSP connected to MySQL . I want that on the page where my database table will appear an update option and when clicking on update, a navigation window will open and you will have to search where that file...
asked by 27.09.2018 / 22:25
0
answers

Error Code 1241. Operand should contain 1 column (s) function MYSQL

Create a function in mysql to work with a sequence the code of the function is as follows: FUNCTION 'fn_nextValue'(SEQNAME varchar(50)) RETURNS bigint(20) BEGIN DECLARE EXIST_SEQ INT; DECLARE CUR_VALUE BIGINT(20); SET EXIST_SEQ = (SELECT COU...
asked by 24.09.2018 / 19:24
1
answer

How to assign a primary key composed as a foreign key in another table with MySQL?

What happens is that I have a primary key composed in a table and that key must be foreign in another table. Could someone help me please? Example: CREATE TABLE 'detallehorario' ( 'Id_Grupo' int(11) NOT NULL, 'Dia' varchar(15) COLLATE l...
asked by 22.09.2018 / 05:06
2
answers

My database allows me to save different grades of the same subject in the same period

I have another question related to the database. I have the following relational database for rating control. However, I have a problem in the PeriodicPeriod table, which is that it is allowing me to place different grades for the same subject...
asked by 15.09.2018 / 05:14
1
answer

UPDATE from a query with conditions

with this query: SELECT id AS wrcId, st AS wrcSt, detail AS wrcDetail, CONVERT(SUBSTR(detail,(LOCATE('#',detail) +1)), UNSIGNED INTEGER)AS ordenId FROM box_12.warehouse_rc WHERE LOCATE('#',detail)>0 AND id IN( SELECT id FROM box_12.esal...
asked by 08.09.2018 / 02:33
1
answer

query of 1 table related to 3 mysql

I have 3 tables: 1. contributions 2. contributions_volunteers 3. contributions_multas All these tables have an import field, and they are all related to the table: 4. associates What I want is to show the partner and the sum of their amounts in...
asked by 08.09.2018 / 16:45