Questions tagged as 'mysql'

Tagged questions
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
2
answers

Sort numbers and seasons correctly

Next I need to formulate a SELECT , whose function is to show in order of seasons the episodes, example T1E1 , T1E2 , T2E1 continuously for the following structure: 'eid' int(10) NOT NULL, 'aid' varchar(6) NOT NULL...
asked by 11.02.2018 / 18:36
0
answers

How to make Docker-compose restore mysql database?

I was able to set up a volume for mysql, with the following line in the Dockerfile of the Mysql container. VOLUME /data/mysql:/var/lib/mysql The folder is created and inside it in the host machine, the mysql files appear la, create the data...
asked by 11.02.2018 / 21:14
0
answers

Error Connecting to database?

I'm trying to make a connection to a database and giving the following error    "ERROR: SQLSTATE [HY000] [2003] Can not connect to MySQL server on   '167.114.173.210' (13) " And I have a "Navicat" program and I can access this DB, just t...
asked by 12.02.2018 / 03:55
1
answer

Error Registering in the Database

I'm getting the following error when trying to insert some data into the database:    Unknown column 'F' in 'field list' In case the column is of type enum and can receive 'M', or 'F', testing directly in the database I saw that this erro...
asked by 12.02.2018 / 01:13
1
answer

Help to build mysql query

I have the following table in MySQL: cod, d1, d2, d3, d4, d5, d6, d7, d8, d9, d10, d11, d12, d13, d14, d15 the fields d1 ... d15 are filled with values between 1 and 25 in each record. There is no repetition of values within a record. How can I...
asked by 12.02.2018 / 02:33
1
answer

Laravel - Return values in master layout

I have an application using laravel 5.5, there was a need to insert a dynamic field in the footer that is located in the master layout, but I am not able to return the data in it, I could not find a solution to my problem. p> The main route is...
asked by 09.02.2018 / 15:21
0
answers

Alphabetical order in listData ()

<?php echo $form->dropDownListGroup($model, 'cur_id', array( 'wrapperHtmlOptions' => array( //'class' => 'col-sm-5', ), 'widgetOptions' => array(...
asked by 14.02.2018 / 18:46
0
answers

Java / MySQL - Error in query

Hello, I'm trying to make a simple application to register with the bank with Java and I'm getting the following error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corr...
asked by 14.02.2018 / 22:25
0
answers

MySql UPDATE INNER JOIN Save Results Before Finishing

I have a mysql query in progress, status: seding data, and I want to stop the process without losing data already acquired by INNER JOIN, present in the cache. It is as if it were a command to during the processing of the Query to record in the...
asked by 14.02.2018 / 18:11